About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

  • Home
  • Get Help
  • Troubleshooting
  • Using Google sheets to track status and send automated emails using Gmail but running into "too much data sent" issue.
Best answer

Using Google sheets to track status and send automated emails using Gmail but running into "too much data sent" issue.

  • 1 June 2023
  • 3 replies
  • 128 views
YashB
Userlevel 1

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.

icon

Best answer by chanelle 1 June 2023, 22:03

View original
2 Attachments

3 replies

chanelle
Userlevel 7
Badge +8

Hi @YashB -

Thank you for the full description and proactive approach with the screenshots, that helps a ton! I do believe there may be two issues here, also referenced in our help doc Common Problems with Google Sheets: 

  1. There have been changes made to the columns while the Zap is on
  2. Formulas can make Google Sheets Zaps do weird things 😒 

If you have any questions after giving the article a glance over, feel free to hop back over and we can continue on with troubleshooting! 

YashB
Userlevel 1

There was not a lot of information about how formulas affect Google sheet triggers on the article. I saw another article that mentioned how google sheet runs all formulae on sheet periodically, which is making me believe that is the reason all 1200 rows are being updated and sent over to Zapier together.

I was able to find a work around that would not use formulas at all so all data should remain static until manual update of the sheet. Workaround: Set the trigger column to be the denied column instead of populating the information into a different worksheet.

chanelle
Userlevel 7
Badge +8

Thank you for coming back and sharing what ended up working for you! I will add this to my “book of knowledge” to help others troubleshoot in the future! 😄

Reply


Terms & Conditions