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 want to connect a google Sheet and a Google Calendar, such that when I add a new Row to the Sheet, it creates a new Event on the calendar using the data from that new row.

I set up a Zap that I thought wold do this. “New Sheet Row” triggers “New Calendar Event.” When I was creating the Zap, it asked me to enter data for an event, which I figured was some sort of sample. 

Every time I add a Row to the Sheet, it pulls that sample data to create an Event. So it is just creating the same Event over an over when new Rows are created, ignoring the actual data from the Sheet.

Did I do it wrong? Is this how it is supposed work? Is there a way to accomplish what I want? Thanks!

Hi @PowerZap 

Good question.

Please post screenshots with how your Zap steps are configured in order for us to have more context.

Make sure you are mapping variables between Zap steps using the ‘custom’ option: https://zapier.com/help/create/basics/set-up-your-zap-action#set-up-your-action

Try turning your Zap ON and test live, then check your Zap Runs to see the DATA IN/OUT for each Zap step: https://zapier.com/app/history/

Thanks! Well, I thought I had it a minute ago-- I had not realized that in Set Up Action I could select data columns instead of just entering text in fields. I put Event details into a single row before setting up the action again, and selected the columns that had the right data. When I finished setting the Zap up, it did create an Event using the data from the first row in the columns I had selected. 

However, if I add a new row with new data to the sheet, it does not create an event on the calendar. Also, if I edit data in the fields on the first row, it does not update the event. Is there something I need to do to make the zap… zap? I have waited a while, refreshed, etc. Screenshots below. 

 

@PowerZap

Might be best to review the available help articles for how to use GSheets in Zaps: https://zapier.com/apps/google-sheets/help

Zaps work while turned ON for new data going forward.

You can check your Zap Runs to see the DATA IN/OUT for each Zap step to help you troubleshoot: https://zapier.com/app/history/

GSheets Zaps take a few minutes to trigger.

You’ll need 2 different Zaps to handle the new VS updated GSheet rows.

You’ll likely want to add a Zap step that saves the GCal Event ID back on the GSheet in a new column so that can be used for updating the GCal Events using the New/Updated trigger.

Hey @PowerZap! I just wanted to check in here to see how things were going! Were you able to check out Troy’s suggestions and make the edits you needed to get things working? Let us know - we want to make sure you’re good to go here!

Hey there, @PowerZap! I can see you were able to reach out to support who mentioned:

I took a look at the logs for your Zap and I was able to identify the three times the same 'Potsdam Summer Festival' event was created in your Google Calendar. These logs were tests, so the Google Calendar step was tested three times, resulting in three of the same events being created in the Calendar.
 
Luckily, it doesn't look like you're encountering this issue now that the Zap is on as each of your three runs are of separate events. You can view these in your Zap History: https://zapier.com/app/history/
 

 

I’ll also pop some of Troy’s troubleshooting steps below just in case it’s useful to anyone following along!

 

Might be best to review the available help articles for how to use GSheets in Zaps: https://zapier.com/apps/google-sheets/help

Zaps work while turned ON for new data going forward.

You can check your Zap Runs to see the DATA IN/OUT for each Zap step to help you troubleshoot: https://zapier.com/app/history/

GSheets Zaps take a few minutes to trigger.

You’ll need 2 different Zaps to handle the new VS updated GSheet rows.

You’ll likely want to add a Zap step that saves the GCal Event ID back on the GSheet in a new column so that can be used for updating the GCal Events using the New/Updated trigger.


Welcome to the Community! 🎉

Terms & Conditions