About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Failed to create a database item in Notion: Book Type is expected to be rich_text.

  • 14 July 2023
  • 3 replies
  • 97 views
Simon Says

I’m trying to set up a connection between Google Sheets and Notion. Zapier successfully reads both the Sheet and Notion database. I have mapped all Google Sheets columns with Notion database properties, but when I test the Zap I get the following error message:

 

Failed to create a database item in Notion

Book Type is expected to be rich_text.

 

“Book Type” is the name of one of the Notion database properties (set up as a text property) and should be receiving data from the Sheets column named “What Type of Book Is This” which contains text. Given that both sets of data are in text format I am not sure what to do to fix this. Any advice, please?

 

Thanks.  

3 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Simon Says 

Good question.

Please post screenshots with how your Zap steps are configured to give us more context, thanks.

 

Help article about Notion Rich Text field types: https://developers.notion.com/reference/rich-text

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Simon Says

Here’s the screenshot of how the mapping was set up:

 

ken.a
Userlevel 7
Badge +6

Hi there @Simon Says,

I’m jumping in to see if I can help!

Thanks for the screenshot, but it’s not quite we’re looking for. Could kindly share another screenshot that includes the "Action" section along with all its fields in your Notion step where the error is occurring? To give you an idea, here's an example screenshot of what we're hoping to see:

46dd6c0979e3d815d621b8da43084ef1.png
(view larger)

Please don't include personal information in the screenshot, or be sure blur out any personal information.

Thanks! 😊

Reply


Terms & Conditions