Skip to main content
Question

Issue with Zaps taking too long to trigger Spreadsheet updates


PaulyP

Zapier taking extremely long to trigger new or updated spreadsheet row trigger when a trigger column is updated. Sometimes 7 minutes, sometimes 20. sometimes 5. its extremely unpredictable. Is there a way to trigger on demand? the tablers feature doesnt allow the character limit i need so that wont work. is make.com my only option?

Did this topic help you find an answer to your question?

11 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30739 replies
  • September 9, 2024

Hi @PaulyP 

Which spreadsheet app are you using in the Zap?


PaulyP
  • Author
  • Beginner
  • 5 replies
  • September 9, 2024

google sheets


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30739 replies
  • September 9, 2024

@PaulyP 

GSheets help links:

 

Consider using Airtable instead of GSheets.

NOTE: Airtable triggers are scheduled and can take from 1-15 minutes to fire depending on your Zapier plan.


PaulyP
  • Author
  • Beginner
  • 5 replies
  • September 9, 2024

Is there a faster way… I know make.com lets you do it immediately


I have the professional zapier plan. does that take 1 minute to trigger with airtable.


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30739 replies
  • September 10, 2024

@PaulyP 

Zapier plans/pricing and features which details the trigger time interval for non-instant Zap triggers:

https://zapier.com/pricing

 

If you are trying to use another integration platform, make sure to check their documentation and requirements for that app.

 


PaulyP
  • Author
  • Beginner
  • 5 replies
  • September 10, 2024

That doesnt make sense to me. it says 2 minutes for pro… mine take 7


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30739 replies
  • September 10, 2024

@PaulyP

There could be other reason impacting your Zap triggering.

We’d need more info and screenshot about how your GSheet is configured and how your Zap steps are outlined and configured in EDIT mode.


PaulyP
  • Author
  • Beginner
  • 5 replies
  • September 10, 2024

I feel like im getting trolled here


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30739 replies
  • September 10, 2024

@PaulyP 

There could be other reason impacting your Zap triggering.

We’d need more info and screenshot about how your GSheet is configured and how your Zap steps are outlined and configured in EDIT mode.


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30739 replies
  • September 10, 2024

@PaulyP 

From one of the previously provided help links:

https://help.zapier.com/hc/en-us/articles/29384048552205-Google-Sheets-error-Zap-not-triggering

 

Google Sheets error: Zap not triggering

 

Symptoms

When using Google Sheet triggers in your Zap, the Zap does not run even though the spreadsheet was updated. Your Zap is turned on, but there is no corresponding Zap run in your Zap history.

Causes

This happens when you make any of the following structural changes to your spreadsheet:

  • Delete existing rows or columns.
  • Add rows anywhere other than to the bottom of your sheet.
  • Sort your worksheet.
  • Rename, add, or rearrange columns.
  • Rename your spreadsheet or worksheet.
  • Add frozen, hidden, or protected columns or rows.

Any of these changes will break the connection between Zapier and your spreadsheet.

How to fix it

To fix this:

  • Turn your Zap off. 
  • Update your spreadsheet.
  • Re-test your Google Sheets triggers or actions in any connected Zaps. Depending on the changes you made, you may need to remap fields.
  • Turn the Zap on again. 
  • Before making any structural changes to your spreadsheet, you must repeat this process every time you or a teammate updates the spreadsheet.
  • Alternatively, you could switch to using another spreadsheet app such as Zapier Tables. Zapier Tables lets you use your table in the following ways without affecting your Zaps:
    • Create views or filters to display subsets of a table’s data. 
    • Trigger and continue Zaps from records, either manually or automatically when a record is created or updated. 
    • Add rows anywhere within a table.
    • Delete rows within a table. However, deleting a column used in your Zap will cause it to break.

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30739 replies
  • September 10, 2024

@PaulyP 

Related Zapier Community topics for GSheet zap triggers that may provide guidance:

https://community.zapier.com/search?q=google%20sheets%20not%20triggering&source%5B0%5D=community