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,

[ARC_Gonza]

Hello
I'm trying to do just what you describe in your message. Were you able to fix it with google app script? Could you tell me how?
Thank you so much.

[Ludo_Figueiredo]

Hello, 

First I create a json object with my airtable data:

I also have a variable called url:

let url = "the url link provided by google script";

Then I get that data into my google script with the function doPost(e) and I parse the result:

I also created a Google doc with my variables {{ name of the text to be replaced }} and I always create a copy from that template in my code. To finish, I use the drive API and body.replaceText('{{ name of the text to be replaced }}', data )

I have been really fast but if you have any questions don't hesitate.