Hi -
I have a zapier form that collects some information. Everything but the email address is being passed correctly to Google Sheets. I’ve read the help materials and turned off and on the zap bc zaps don’t pick up changes in google sheets unless the zap has been turned off/on. In addition, I remapped the email address field.
The screenshot above shows the test run went through but the first one, where I put my own email address in, is blank.
Thank you!
Hey! This is a common one, here's what's likely happening:
The blank email on your first submission is because that entry was captured before you remapped the field. Zapier doesn't retroactively update old records, so that first row will always be blank. Your remap is correct, new submissions should come through fine.
To confirm it's working:
If the email is still blank on new submissions, the issue is usually that the form is passing the email as a label instead of a value in the field mapping. Go into your Zap step → click the email field → make sure you're selecting the actual email value and not a field label.
Let me know if it's still not working after that, happy to help you dig deeper!
Thanks for the reply. I submitted a new entry and it did not work.
I’m trying to see where I can switch from “label” to “value” but not seeing that anywhere. Here’s the screen from the Forms:
And I don’t see where I would do that in the zap:
+14Hi
After testing the GSheets Zap step, for the RUN DETAILS tab, check the DATA IN/OUT tabs to see the data that was used as inputs and the row/data that was returned as outputs.
Post screenshots showing that data to give us more info to work with.
This post has been edited by a moderator to remove personally identifiable information (PII). Please remember that this is a public forum and avoid sharing personal or potentially sensitive details.
+14
Screenshots do not show the DATA IN for the GSheet step.
Help links for how to use a previous Zap Run as a trigger step test record:
https://help.zapier.com/hc/en-us/articles/35632951078029-Use-previous-Zap-runs-as-trigger-test-records
All other fields have an Input. Why would there not be a Data Input field for the Email? How do I add this?
+14
Did you try this tip?
Help links for how to use a previous Zap Run as a trigger step test record:
https://help.zapier.com/hc/en-us/articles/35632951078029-Use-previous-Zap-runs-as-trigger-test-records
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
