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’m using Google Forms to populate a Google Sheet then grabbing new information using Zapier to send a personalized thank you email using Business Gmail. A few weeks ago everything worked, now none of the data is being used by gmail and the send using gmail will not work. I’ve tried every fix I can find (and understand) but cannot get it working. Any clues or help please. Thank you.

Hi @Bill Vick! 

So, the Zap is being triggered but the information isn’t correctly being used in the Gmail and so the Gmail wont send, is that right?

The first thing to check is if there are any blank rows in the Google Sheet as this can mess with Google Sheets Zaps. If there are, turn off the Zap, delete the blank row and turn the Zap back on again. 

If there aren’t any any empty rows, could you give us a bit more information about the error that you’re seeing? Is the Zap not finding any information in the Google Sheet or is it trying to use the wrong information? And is does it fail every time, or only sometimes?

Hi @Bill Vick - We noticed that you received an answer from Support so I’m going to share it here:

If we look at the last task that ran on July 30 - we can see that it was in Row 1377 of the Sheet.

 





But if we look at the Sheet today - we are only at Row 1301.
 




This tells me some rows were deleted from the Sheet at some point after that last run on July 30th..

Due to the way we look for New Rows - deleting rows while the Zap is ON can cause issues just like this where the Zap doesn't trigger.

https://zapier.com/apps/google-sheets/help#common-problems-google-sheets-zapier

If you do need to delete rows form the Sheet - it is always best to Turn the Zap OFF, delete the rows, and then Turn the Zap ON again.

Turning the Zap OFF/ON will reset the tables we use to check for New Rows.

So when you did that today - the Zap started working again.

Terms & Conditions