Question

No Notion database shown when I try to create an item

  • 6 April 2023
  • 4 replies
  • 714 views

I created a Google form that should pass information to Notion (create a new item in the database).

The Notion page is public and so is the database.

I connected accounts, but when I try to pick a database to add an item to, nothing is shown:

 

I tried disconnecting and connecting again but no luck. Can someone shed a light? :)


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Userlevel 3
Badge +4

Hi @edug 

Thanks for reaching out to the Community! I’m sorry to hear that you’re having trouble with creating your Zap.

Could you send screenshots of how you’ve configured the steps of your Zap so far? (If there’s any personal information, kindly blur them.)

I want to ensure we're on the same page so I can point you in the right direction.

Looking forward to your response! 😊

Userlevel 7
Badge +14

Hi @edug 

Good question.

Help: https://help.zapier.com/hc/en-us/articles/8496040151821-Common-Problems-with-Notion#when-creating-a-database-item-i-m-getting-an-error-about-an-invalid-option-0-1

 

My databases are not listed in the dropdown menu

Zapier can only access any databases that have been shared with your bot integration.

  1. In Notion, click "Settings & Members" on the left sidebar. 
  2. In the dialog box, click "My Connections".
  3. Click the "..." next to the Zapier Connection.
  4. Select "Access selected pages" in the dropdown menu, and ensure that the page you want to access is checked.

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

When using field types “Tags”, “Select”, or “Multi-select”, the tags or options used need to be created in the database in advance. Go back to the database in Notion and add the tag or options to a database item first.

I can't see all fields

The following Notion field types are not supported:

  • Files and media
  • Formulas
  • Relations
  • Rollups
  • Status

If you have fields that belong to one of these field types, they won't appear in Zapier.

Thanks both for the super fast first answer, Here are more details

 

Notion has access to it:

Database also added:

 

It’s connected and ‘assigned’ to create a database item

 

however it won’t show any:

 

if I click custom, it only shows the google form with a dummy test

 

Userlevel 7
Badge +14

@edug 

Check your Notion Zap app connection here: https://zapier.com/app/connections

 

About Notion's Integration

What kind of authentication does Notion use?

Notion uses OAuth.

Do I need a paid Notion account to use Notion with Zapier?

You don't need a specific Notion plan to use Notion with Zapier.

Do I need special account permissions in Notion to use Notion with Zapier?

You need to be a Notion admin to connect Notion to Zapier.

Are there any API token limits in Notion when I use Notion with Zapier?

No, there are no token limits when using Notion with Zapier.

Are there any webhook subscription limits in Notion when I use Notion with Zapier?

Notion doesn't have any webhook subscription limits when you use Notion with Zapier.

Are custom fields in Notion supported when I use Notion with Zapier?

Notion supports most custom fields. However, "Files & media", "Formula", "Relation", "Status", and "Rollup" are not supported.

Does Notion use real trigger samples from my Notion account?

Yes, Notion provides real trigger samples from your Notion account.

What kind of Notion hosted account can I use with Zapier?

Notion's Zapier integration supports cloud-hosted accounts only.