Apps script in glide

Ask for Help
1

Hello, can someone help me, how do I run a script in app script from a glide webhook. I’ve been trying for days until I get to this. :pensive:

2

Can you describe what exactly your script does? We might be able to have another method to help with that.

3

The only thing I want to achieve is to send a gmail message when a button is pressed

4

An alternative for you is to use the Glide webhook to send a payload to Make/Zapier, then send a Gmail message through a new module inside the scenario.

Or are you trying to cut down the cost by using Apps Script?

5

At this moment I already use Zapier to send emails, however they are not unlimited and I need to send an email every time a user places an order for an ecommerce

6

So each time a user orders, it will create a new row in your sheet, right?

You can have a trigger that runs every time a row is created in a specific sheet, and trigger the email to be sent.

1 Like
7

Thank you very much for this guide, I did not know how efficient it was to write to the community. I have been making apps in glide on a daily basis for 4 months and now I am ready to use scripts, I am happy, thank you very much.

1 Like
8

Feel free to let us know if you have any other questions! We have a superb community here.

2 Likes
9

You could collect orders in separate spreadsheet to save rows in Glide. Glide’s webhook is basically a POST request to wherever, so we can use doPost(e) function in apps script to receive data from Glide, then process it, append row, send email… And all that with one script project.

And if you want to display orders history to a user in your app, you can achieve this too with another apps script project, attached to the orders spreadsheet and Fetch JSON column + transpose method in Glide.

I could put together a little tutorial if you want (I love apps script and try to adopt it everywhere)))

2 Likes
10

hello
i think my problem is very simple and i post this requete many time, but I have no response.
Maybe, you help me, I try to explain simply
My script is very simple and I use myself with google shett

function getStudents(parameter) {
instructions to modify list of row, not all only one filtered list
};

I would automatize this by an Glide Action that allows to launch an external script with a button lik this ?
I don’t know how to do

thanks a lot

11
12

Thanks ThinhDinh
I was looking in the community and this answer appears on another site.
By studying Stackoverflow’s proposal, I understood that it’s very simple, no need for any triggers onChange or others
In summary :
I have a parameter to pass: the name of the association and the run will be on the association received.
Via Glide, I write in a cell the name of the association I want modify
The script runs if the cell is not empty and therefore filled with the name of the association
The execution will only be done on this association.
At the end of the script I erase the contents of this cell.
So I wouldn’t need Onchange.
I did a little test, this run how I hope. Now I have to do to integrate it into Glide

PS: My difficulty and my silly questions come from the fact that I have reflexes of an old programmer, I have to get used to thinking about Javascript and Glide

Thanks also to Jeff, Darren for their help

1 Like