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.

Hey everyone,

 

I am stuck with what seems a basic task. Basically, whenever we add a certain event to a specific Google Calendar, I would like for that event (Date, Duration, Description) to be added to a new row in a single Google Sheet. 

 

My flow is the following:

App: Google Calendar

Event: New or Updated event

→

App: Google Sheets

Event: Create Spreadsheet Row(s) (with the details)

 

Now the issue is that only some events are being recorded, while majority is not. More importantly, I am constantly getting the following warnings “You have 22162 tasks being held”. Did I somehow create some sort of loop as we definitely don’t have that much events in the calendar? I see that for the recurring events Zapier managed to write down some, so should I somehow limit the export on the upcoming event’s only? so it’s not being done retroactively? Or the issue is somewhere else?

 

Thanks everyone!

Hi @lauv 

 

Can you please share the setup you currently have in Zapier? 

 

If you have 22162 tasks on hold this means it is because your trigger flooded Zapier and so all the tasks are currently pending UNTIL you tell Zapier to run them. (which is not recommended for this many tasks of course)

 

 

@MohSwellam yes, of course

 

 

 

Hi @lauv , 

I would have a couple of suggestions:

 

  1. You were saying when a certain event is scheduled, I suggest using “New Event Matching Search”, this is a great resource about how to use it https://zapier.com/apps/google-calendar/integrations/google-calendar/10047/copy-new-google-calendar-events-that-match-a-search
  2. Go to Zap History (https://zapier.com/app/history) and select all the On Hold zaps and delete them
  3. Use Zapier Transfer to transfer any data already in your calendar (https://transfer.zapier.com/new) 

Hopefully this helps solve your issue 🙂 Please let me know 

Hello @lauv! Just wanted to check in and see how you’re getting along with the suggestions provided. Let us know if you need any additional help.

Terms & Conditions