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.
2 Likes
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: https://console.cloud.google.com/apis/credentials
How to create an OAuth app in GCP: https://www.make.com/en/help/tutorials/calling-google-apis-via-the--http-make-a-oauth-2-0-request--module â 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.
https://www.make.com/oauth/cb/oauth2
https://www.make.com/oauth/cb/google-custom
https://www.make.com/oauth/cb/google-restricted
https://www.make.com/oauth/cb/google-cloud-speech
https://www.make.com/oauth/cb/google-analytics-4
https://www.integromat.com/oauth/cb/oauth2
https://www.integromat.com/oauth/cb/google-custom
https://www.integromat.com/oauth/cb/google-restricted
https://www.integromat.com/oauth/cb/google-cloud-speech
https://www.integromat.com/oauth/cb/google-analytics-4
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: https://console.cloud.google.com/apis/credentials/consent
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 https://console.cloud.google.com/apis/credentials/consent
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.