Skip to main content
Question

How to access a the value of a relation data item from Notion database(s)?

  • December 1, 2024
  • 3 replies
  • 59 views

SO, I have a Notion workspace that has multiple databases; in this case, a Content database which sports an item from a related database for Channels. I am trying to create a new Google Calendar entry when the Notion Content database is updated, grabbing key elements from that table and putting it in a Generate Detailed Events in Google Calendar from New Notion Database Items Zap.  This is working for elements that are native to the Content database itself, for all of them are readily available. However, in the Content database is also Channel which is related to the channel Name in the Channel database. I want to use the value of channel Name for the Google Calendar Event Description, but that value is not actually present when I look into the Data In from Content - there is only a Properties Channel value and that value is a giant hexadecimal string. Select THAT value simply puts the string in the Description, which - of course - is not what I want. I’m an utter newbie, so if doing what I want to do is arcane, I haven’t a chance in the world of stumbling on the right solution. I’m hoping someone here can give me guidance. Thanks, in advance.

Did this topic help you find an answer to your question?
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

JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • 2336 replies
  • December 4, 2024

Hi ​@DrawMaster,

 

Welcome to the Community.

 

You're trying to integrate Notion with Google Calendar via Zapier. Still, you need help pulling data from a related database in Notion because its API only provides the unique ID of associated items, not their content. Workarounds include duplicating the data into the central database, using third-party tools like Automate.io for advanced Notion integrations, or directly accessing the Notion API with coding to fetch related data.

 

Let us know if you have further inquiries.


  • Author
  • Beginner
  • 1 reply
  • December 4, 2024

Thank you so much for the helpful reply, JammerS … will explore those options.


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • 6380 replies
  • December 4, 2024

Hi ​@DrawMaster,

That’s awesome ​@DrawMaster! A huge thanks to Jammer for lending a hand here.

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗