Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

  • July 14, 2023
  • 3 replies
  • 193 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.  

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

3 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • 34082 replies
  • July 14, 2023

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 | Platinum Authorized Zapier Solution Partner | #1 Zapier Community Contributor
Simon Says
  • Simon SaysBeginner
  • Author
  • Beginner
  • 1 reply
  • July 14, 2023

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

 

ken.a
Forum|alt.badge.img+6
  • ken.aZapier Staff
  • Zapier Staff
  • 6780 replies
  • July 17, 2023

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! 😊

Terms & ConditionsAccessibility statement