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.

I’m new to zapier and I love it, in concept.  I was able to get it to do one important function which is to update a google shees with a new event added to google calendar. I love seeing new events auto populate into my spreadsheet.

However, I’m going in circles trying to get it to do some other things I’m hoping it will help me with.

I need it also to update a google sheet row when an event in google calendar is changed

and I need it to delete a google sheet row when an event is cancelled.

I have a feeling I’m doing something wrong in the row field but I’ve tried every option and It’s still not working.  

If anyone could help with their Zapertise I would be very grateful.

Please provide screenshots of your Zap step configurations.

Action: GSheets - Lookup Row

Triggers/Actions/Searches available for the apps:

GCal: https://zapier.com/apps/google-calendar/integrations#triggers-and-actions

GSheets: https://zapier.com/apps/google-sheets/integrations#triggers-and-actions

Thanks Troy

 

 

Hi @ThePuliceDept 
Just checking in to see if you still need help with this? 

Thanks for checking in. I have it working mostly, though not consistently. The biggest challenge is with calendar changes. Zapier can’t find the correct row to make the change so I have to manually go in and make the changes.

@ThePuliceDept 

You might want to consider a zap that triggers when the event is created and adds the Gcal event ID to the Google Sheet - giving you a search key you can use to record changes.

Thanks. I tried that but again the zap failed to find the row and make the change. It just added a new row again. I love the idea of zaps but the lack of customer service makes it hard to advocate its use company wide.

Hi @ThePuliceDept - have you been touch with support yet. They run 24/7 and will definitely help guide you through this. You can open a ticket here: https://zapier.com/app/contact-us

In terms of trying to get help here. Can you show us screenshots of how the various steps of your zap are setup?

Terms & Conditions