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.

Hi, I have a Google spreadsheet set up to create a Google calendar based on new rows, or update a pre-existing calendar if any data in any row changes. Lastly, it sends an email to designated addresses. Everything works except my Find Event and Update event zaps.

 

So far, when I create a new row, a new Google calendar is created, but if I update the row, nothing updates in the Google calendar. It stays the same as before. As of right now, the data is test data to ensure everything works properly first.

 

I tried following the suggestions here, but creating a separate field for the GCal Event ID won’t be possible. There will be multiple people working in this spreadsheet who will either not know how to obtain the ID or remember to input it each time.

 

Here are my screenshots:

 

 

 

I would appreciate any help you can provide. Thanks!

Hi @ekemp2 

When the new GCal Event is created add a step to update the GSheet with the GCal Event ID in a new column.

That way for updated rows, it can use the exiting GCal Event ID.

No need for anyone using the GSheet to know how to obtain the GCal Event ID as that would be done via the Zap.

Hi @Troy Tessalone , thank you! Do I add that between steps 2 and 3? In step 2, I checked off create a new GCal Event if it can’t find one already. And which zaps do I use to achieve this?

 

 

@ekemp2 

Realistically you’d need Paths. (requires Pro+ Zapier plan)

One path would be for if there is a GCal Event ID and another path for if there is not from the GSheet trigger data.

You can simplify the logic like this:

If there is no GCal Event ID, then create a GCal Event and update the GSheet Row with the GCal Event ID.

If there is a GCal Event ID, then use that to update the GCal Event.

No GCal Find Event step necessary.

@ekemp2 

Here’s another possible issue:

GSheets need to be configured a specific way to be used in Zaps: https://help.zapier.com/hc/en-us/articles/8496276985101-Work-with-Google-Sheets-in-Zaps#don-t-include-punctuation-in-your-sheet-name-0-3

@ekemp2 

As an alternative, I’d recommend using Airtable instead of GSheets.

Airtable has Automations that have a native integration with GCal.

I got it to work now, thank you @Troy Tessalone!

That’s awesome @ekemp2! A huge thanks to Troy for pointing you in the right direction!

Happy Zapping! ⚡️

Terms & Conditions