​@Mishal Ali 

It is not working because you are not mapping a valid email in the To step, kindly add a valid email instead of text “sample text question”, If possible add validation in your form for the email field. Review screenshot.

 

hi ​@Mohammad_Shahzaib_Nawaz 

thank you for your help

I am not sure why the trigger does not read the 1st entry in the table with full field

i will try to  redo it and hope it work

it is my first test with tables 

thank you for you time again :)

​@Mishal Ali 

Could you please share how you configured the zapier table step (2nd Step), as well as the image of how you set up the table?

​@Mohammad_Shahzaib_Nawaz  thank you Mohammad for your replay

here is the configuration

google form to zap table no problems 

records go as configured

trigger:

action: (create record)

I tied to use cap letter and I added the email original field type as shown above try to find the misconnection but same did not work

I tried with google sheet but still cannot pull the email from table or g-sheets to my gmail send email action

even tried to get all fields testing same

but,

if I add the same field twice in a separate raws,

test:

it works. but I dont not why. 

also the email is sent once only not twice. the action reads 1 field only 

--

I tested other email fields from g-forms or tables ( text field type) but did not work

 google form respondentEmail  field works but as I mentioned above my application is public and does not require signing in

what am I missing? :(

thank you again for reaching the end on my post and 

​@Mishal Ali 

From what I understand, you have set up your zap as follows,
1. Google Form (Trigger - New Submission).
2. Zapier Table (Append Data in Table -  Create Row).​​​​​​

3. Send Email (Gmaill).

If this is your setup then in the gmail step you can use the output of email from the 1st step i.e (Google Form Submission) and map that email in Gmail Step.

FYI to get a row from Zapier Table you will have to use the Find Record in Zapier Table, select a column based on which you can lookup, e.g:
you can use record Id as a lookup column in this case and pass the output id of Record Created.
 

thank you ​@Mohammad_Shahzaib_Nawaz  for the suggestion  I will try use find record and record ID

I did try to use email field from google sheet but same error.

right now it shoes error but I receive an email which is weird. but I am going to try different setup by break it into 2 separate zaps. for testing only

thank you very much for your responds

regards :)

Hi ​@Mishal Ali,

It looks like the Tables field currently contains placeholder data rather than a real email address. I’d recommend skipping the action steps for now, publishing the Zap, and then doing a live run to see if everything works as expected in a real scenario.

Kindly give it a try and let me know how it goes? I'll keep an eye out for your response!

Hi ​@ken.a 

indeed it works. even it shows error to fetch the email field from tables or from google forms

somehow when add the email twice, separate lines, worked, but now shows error

everything works fine with the error message. I do receive an email for. the trigger works

thank your time and your replay

regards :)

Hi ​@Mishal Ali,

To troubleshoot the email field issue, double-check field mapping to ensure proper alignment, test with different records to identify data inconsistencies, and verify formatting for duplicates or hidden characters. Review Zap History for error details, re-authenticate connected apps to rule out access issues, and if problems persist, reach out to Zapier Support for further assistance.

Please don't hesitate to reach out if you have any further questions or need additional support. We're here to help.

hi ​@JammerS 

thank you for your time trying to help

I deleted everything and started from scratch and now it works

google form to google sheets to gmail send email

before, the sending email step could not read from the table or sheet or the form.

even the email is sent with the testing error in the setup

now the action works fine even when I added the action to send the submission into new sheet.

I will duplicate it and testing different setups and app just to ensure and understand more options

thank you all for your help and time

regards 😃

Hi ​@Mishal Ali,

Thanks for the update! Starting fresh often fixes issues caused by outdated data or mismatched fields, especially with apps like Google Forms, Sheets, and Gmail. Duplicating and testing different setups is a smart way to learn and explore new options. If you need more help, feel free to reach out anytime. Great job troubleshooting and happy Zapping.

thank you ​@JammerS 

indeed

I already redone previous zaps testing different approaches and apps exploring the actions and getting familiar with them 

regards

Hi ​@Mishal Ali,

It's great to see you exploring different setups and getting hands-on with Zapier. That's a powerful way to learn and find the best solutions. If you have questions or need help as you refine your Zaps, we're here to support you. Keep up the excellent work, and feel free to share your progress.