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 am geTting new lines on my google sheet , but not all LEADS ARE SHOWING UP ON THE GOOGLE SPREDSHEET 

Welcome to the Community, @IDANG! 🎉

It sounds like the Zap is triggering for some new leads and adding them to the Google Sheet, but it’s not triggering for all leads so some leads are missing from the spreadsheet. If so, is there any common difference between the leads that are triggering the Zap and those that are? 

If not, is it more that the Zap is triggering for all leads but is not always adding the lead to the spreadsheet? In which case are you seeing any errors in the Zap History? If so, please can you share a screenshot of the full error message here? Please remove/hide any private information from the screenshot before sharing (like names, email addresses etc.).


Also, which app is being used as the trigger for the Zap currently? 

If you can share some further details here we’ll be better able to help troubleshoot this. Looking forward to hearing from you! 

Hi Sam 

I do have errors messages 

 

Unable to get a value when looking for "rows". Is it empty or missing?

 

Run ID: 00ef779e-80a6-afe1-9131-1c300b02fce1

 

spreadsheet:

1rjb7VlP04DSkgl-c5cb8zmeiPYPqp-z2mN7xLlbLJjg

worksheet:

0

COL$A:

{{197643953__fieldsfname][value]}}

COL$B:

{{197643953__fieldsfemail]evalue]}}

COL$C:

{{197643953__fieldsffield_ad4f3df]4value]}}

COL$D:

{{197643953__fieldsffield_993d308]3value]}}

COL$E:

{{197643953__meta_date][value]}}

rows:

1:COL$A:

{{197643953__fieldsfname][value]}}

COL$B:

{{197643953__fieldsfemail]evalue]}}

COL$C:

{{197643953__fieldsffield_ad4f3df]4value]}}

COL$D:

{{197643953__fieldsffield_993d308]3value]}}

COL$E:

{{197643953__meta_date][value]}}

Fields with no value:

drive

Thanks for getting back to me here, @IDANG. 

It looks like you’ve also reached out to our Support team about this and they were able to identify the reason why the lead information isn’t being added to the Google Sheets spreadsheet. I’ll share the relevant details from their response in case it’s helpful: 

I've taken a look at the Zap Run you sent over and the error from Google Sheets occurred because there were no values provided to create a new row:
 
898f86a9eccbebbcff92793d42a69148.png
view larger
 
The Google Sheets step is expecting values from the fields highlighted above however the webhook provided values in different fields.
 
Are you able to modify the service sending the webhook to ensure they send values in the same fields each time such as "fieldssemail] value]"?


Hope that helps to get you pointed in the right direction. If you have any follow up questions on their response it would be best to continue the conversation with Support directly by replying to their last email. They’ll be able to reference the logs for your Zap and advise on any further changes that might need to be made. 🙂

Terms & Conditions