Can I do changes to App Script in Google sheets?

Hello community ,
I have this script in Google sheets and i want inside the Make with an automation to change the webhook link


The concept is to copy a new Google sheets for a new user and each google sheet triggered from a different webhook.

You could, using the Apps Script API, but is this the right approach?

Because when you copy the sheet, it doesn’t know the new webhook address to set it to yet.

Make doesn’t have an integration for this third-party service or a module for this particular endpoint.

If the external service has a Developer API Reference/Documentation then you should be able to integrate the endpoints in Make using the app’s universal module (Make an API call) or generic HTTP “Make a request” module.

You can also suggest for it to be made in the Idea exchange. Don’t forget to search for it first, just in case someone already suggested it, so that you don’t end up creating a duplicate.

If you need assistance in setting up the app’s universal module, or the generic HTTP module, please provide additional information about what you have tried with regards to the external service’s Developer API Reference – how you are setting the connection up, a link to the endpoint are you trying to connect to, and what errors you are encountering.


Thanks you @samliew for your answer !
Yes this will be a little bit tricky part .
Because first i copied ( and created a new scenario with existing Google sheet with this App script inside)
And i want to create a new make scenario which can edit the script and change the link of webhook

If you set up a Google OAuth connection using the HTTP Make a OAuth 2.0 request module, you can call the Apps Script API to get existing script, then replace the webhook URL in the script with the new URL.

1. Enable the API

Direct Link: Google Cloud console

2. Insert all the known Google Redirect URIs for your app

Direct Link:

How to create an OAuth app in GCP: ← FOLLOW THIS

Here are all the known redirect URIs you need for your Google Cloud Console OAuth app. If you set these up, you can reuse the same GCP app for other Google apps and modules on Make.

Once you’ve set these up, you can use/reuse the same Make connection for all the supported Google apps & modules on Make - you’ll only have to enable the respective APIs for your custom app in Google Cloud.

3. Publish your GCP OAuth2 app

Direct Link:

You might need to set your OAuth application to “Production”, otherwise the credentials expire very frequently.

1. To do this, go to menu item “OAuth consent screen”

or click here

2. Then click the button below if the Publishing status is not “In production”

4. Configure the HTTP OAuth2 module

You need a “Authorize parameters” key of redirect_uri with the above Make OAuth2 callback URL.

You can find the Client ID and Client Secret in the OAuth2 app you created in GCP, on the right-hand side of where you inserted the 8 callback URLs in step 2:

Alternatively, you can put the Webhook URL in a hidden cell and reference it from your script.

This way you don’t have to fiddle with the API, and you can use the Update a Cell module.

Thank you @samliew for you valuable help !
I appreciate it a lot