Trigger App: Google Sheets
Trigger event: When a new row is added or existed row is updated
Action App: Gmail
Action Event: Send template email
Usecase: I have a google sheet where I house contact names, numbers, and emails (~1200 rows). Once I manually check a checkbox on the same row, their contact record is populated on another worksheet using the Query formula. =IFNA(QUERY('Sheetname'!A53:C53,"select A,B where C=True",0), ""). This new worksheet is used in a zap where updated rows are used to send emails to our customers. If a checkbox is checked for column denied, then that contact will appear in denied worksheet and a denied email will be sent to the client. Screenshot attached.
Issue: Lately we have been running into all our tasks being held because “Too much data sent” by google sheet. To me, it seems like because google sheet formulas are periodically updated, the formula above updates all rows even if there is nothing to update and all 1200 rows are sent to Zapier.
Any feedback / solutions are appreciated.
Best answer by chanelleView original