Skip to main content

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.

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.


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


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


Reply