Connection between google form & airtable doesn't work

[barsac]

Hi,
We’re tring to make a connexion between Google form & airtable to send a automatic e-mail to thanks people who answer to our satisfaction form.
Could you help me please

[Prem_Patel]

@barsac Welcome to the community.

Please share screenshot and details of your scenario.

Best,

[barsac]

Hi,
I’m trying this basic connexion
Test1.docx (148.0 KB)
Make doesn’t recognize the field email.
Thanks for your help

[barsac]

Also, Make dosen’t recognize the others airtable’s fields (like name, mail etc …).
Do you know if there is an update time between the differents tools?
Thanks

[Prem_Patel]

Can you share the form and Airtable table structure(headers) so i can replicate the workflow it so it will be easy for you to understand.

[barsac]

Hi,
Thanks for your anwser. Please find enclosed the information.
Test2.docx (100.9 KB)

[Prem_Patel]

Thanks for the efforts. Here is the similar use case example to add google from responses to airtable : 1. Review output from google form watch responses module and map answers to airtable create a record module

2. More detailed mapping is needed not just direct mapping of answer field, you have to expand each array and collection until you see “value” which is an answer actually
   
   

and using this way of detailed mapping will solve your problem of record creation and from there you can use airtable automation if you want to or just add gmail module next to airtable like this with some email to welcome them.

This mapping can be hard, so you can use Watch responses from google sheet, where responses are stored, use this module to see direct answers from form, no more detailed mapping:

First you need to connect google sheet In your google form builder

and select that google sheet in module above to simply the answers mapping.

I am sure this will help!

Best,
@Prem_Patel