Help

Generate Google doc with Airtable (using Google Script)

Topic Labels: Automations
Solved
Jump to Solution
385 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Ludo_Figueiredo
4 - Data Explorer
4 - Data Explorer

Hello, I am making a special CRM. I have customer information (name, phone, address…) and with this information, I would like to fill a google doc (there are variables like {{name}} and they have to be replaced with airtable data ).

1

I am used to javascript but I am a beginner in the API world. I have already tried that:
2

3

I don’t know how I can tell my script to only use the data from the row where my checkbox is checked (and how to tell Airtable to run my google App script when the checkbox is checked. I wanted to try the Google web app and use webhook but I don’t know if airtable can send webhook or if I have to add it a special code). I would like to only use code and not an app like Zapier (for flexibility and because I am curious).

Best regards.

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

Airtable can call a webhook using fetch in a script.

Have your Airtable script gather the info for the record and post the data to the Google App Script,

See Solution in Thread

1 Reply 1
kuovonne
18 - Pluto
18 - Pluto

Airtable can call a webhook using fetch in a script.

Have your Airtable script gather the info for the record and post the data to the Google App Script,