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!
Best answer by Troy Tessalone
Take a look at the screenshots below.
The “User email address” variable mapped for Email address field is different from the “Form Data: Your email address” variable that has the actual email address value from the Zapier Form.
Try following this help link to use a previous Zap Run as a trigger step test record to then reconfigure the Zap action step for GSheets:
https://help.zapier.com/hc/en-us/articles/35632951078029-Use-previous-Zap-runs-as-trigger-test-records
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
+14
For us to have current context, post screenshots showing how your Zap steps are now configured.
Hi - the steps haven’t changed. I think there’s something in here that isn’t functioning but I dont know how to fix it. In this form, the email is in Data out:
But the next step in Google Sheet isn’t taking in the email address:
In fact, there isn’t an email address field on Data In:
There is an email address for Data out for sheets, but it’s blank (not surprisingly):
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
Latest screenshots do not show how the Zap 2 CONFIGURE tab is configured.
Make sure the mapped variable contains the label “Form Data: Your email address”.
+14
Take a look at the screenshots below.
The “User email address” variable mapped for Email address field is different from the “Form Data: Your email address” variable that has the actual email address value from the Zapier Form.
Try following this help link to use a previous Zap Run as a trigger step test record to then reconfigure the Zap action step for GSheets:
https://help.zapier.com/hc/en-us/articles/35632951078029-Use-previous-Zap-runs-as-trigger-test-records
+11Well spotted
Have a great rest of your week! 😁
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
