I am geTting new lines on my google sheet , but not all LEADS ARE SHOWING UP ON THE GOOGLE SPREDSHEET
New lines are showing up on my Google Sheet, but not all leads are being added.
Best answer by SamBBest answer by SamB
Thanks for getting back to me here,
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:
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. 🙂
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.