Common problems with Notion on Zapier

How to work with dates in Notion

Notion uses a specific date format called ISO 8601, which includes the:

  • Year.
  • Month.
  • Date.

It can also optionally include:

  • Time.
  • Timezone offset. 

When you use a Notion date field in Zapier, Zapier will try to convert your provided date to this format. However, if you are inputting a date, time, and timezone into a date field, Zapier recommends using Formatter to modify the date format.

How Zapier settings can affect dates 

If you do not have a timezone set in your Zapier account or within your Zap, Zapier will automatically set the timezone as UTC for any data that interacts with a date field. 

To avoid any confusion, Zapier recommends setting the timezone in either your Zapier account or Zap to match the timezone you set up in your Notion account. This will ensure your dates are read correctly and a timezone offset will automatically be applied when interacting with a date field.

Search for a database item by a date field

When searching for a database item by a date field using the Find Database Item action, Zapier expects to read the time and timezone associated with a date, based on your Zapier account.

This can have unintended consequences when searching for a date only. 

To override Zapier’s default time and timezone setting for Notion date fields, you can add the time format T00:00-0000 to the date field you are searching. This represents 12:00am in UTC and ensures that only the date is considered in the search.

 

My databases are not listed in the dropdown menu

If you're having trouble listing your database in your Zap, try these steps:
After trying these steps, you should be able to refresh your fields and view your database in your Zap.
 
 

When creating a database item, I’m getting an error about an invalid option

If your database contains a column that is either a "Select" or "Multi-select" property type, you can only add options that match what you have in Notion. To add additional options, you must first add them in Notion.
 
 

I can't see all fields in my Zap

Not all Notion property types are supported in Zapier. The following property types are not supported:
  • Files and media
  • Formulas
  • Relations
  • Rollups
  • Status
These property types will not appear in your triggers or actions.
 
 

My Zap is triggering too much

If you find your Zap is triggering too frequently, you can add a filter to run only for certain conditions of your database. This will prevent your Zap from running on every change made to your database, ensuring actions get performed only on the items you want.
 
 
 

I'm not seeing content appear in my Zap

When using either the New Database Item trigger or Find Database Item action, it’s not expected behavior that your Zaps will show you data from your content block.

Let us know in this Community thread if you want to be notified when this is available.

 

My Zap doesn’t trigger from updates made to my content 

When using the New Database Item trigger, it’s not expected behavior that your Zaps will trigger if you make updates to your content block.
 
Let us know in this Community thread if you want to be notified when this is available.

 

Unexpected error: !DOCTYPE html

This means Zapier has had temporary trouble communicating with Notion’s servers. App servers can be unavailable for short periods of time. To fix this:
 

I gave Zapier full access to all of my pages, but new pages don’t appear

If you create new pages after connecting to your Notion account and want to interact with them in your Zaps, you'll need to grant Zapier permission in your Notion account. This is because Notion’s API requires you to specify permissions for each page that Zapier can access.
 

 

miscEye icon Can't find what you're looking for?
  • Try searching in Community, as someone else may have already asked your question.
  • Post your question in the Community:
    • If you’re looking for help with a specific task, ask in Get Help.
    • If you’re looking for troubleshooting advice, ask in Troubleshooting.
Was this article helpful?
0 out of 3 found this helpful