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 Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

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.

Question

New lines are showing up on my Google Sheet, but not all leads are being added.

  • 25 July 2023
  • 3 replies
  • 88 views
IDANG

I am geTting new lines on my google sheet , but not all LEADS ARE SHOWING UP ON THE GOOGLE SPREDSHEET 

3 replies

SamB
Rank
Userlevel 7
Badge +11

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! 

IDANG

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__fields[name][value]}}

COL$B:

{{197643953__fields[email][value]}}

COL$C:

{{197643953__fields[field_ad4f3df][value]}}

COL$D:

{{197643953__fields[field_993d308][value]}}

COL$E:

{{197643953__meta[date][value]}}

rows:

1:COL$A:

{{197643953__fields[name][value]}}

COL$B:

{{197643953__fields[email][value]}}

COL$C:

{{197643953__fields[field_ad4f3df][value]}}

COL$D:

{{197643953__fields[field_993d308][value]}}

COL$E:

{{197643953__meta[date][value]}}

Fields with no value:

drive

SamB
Rank
Userlevel 7
Badge +11

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 "fields[email][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. 🙂

Reply


Terms & Conditions