Generate Google doc with Airtable (using Google Script)

[Ludo_Figueiredo]

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 ).

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

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.

[kuovonne · Accepted solution]

Ludo_Figueiredo:

I don’t know if airtable can send webhook

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,