Google Sheets
Google Sheets is a spreadsheet application. With the Google Sheets app in Make, you can manage the spreadsheets, rows, and cells in your Google Sheets account.
Requirements
To use the Google Sheets app in Make, you must have a Google account.
Make's use and transfer of information received from Google APIs to any other app will adhere to the Google API Services User Data Policy.
Connect Google Sheets and Make
To create the connection:
Log in to your Make account, add a Google Sheets module to your scenario, and click Create a connection.
If you add a module with an instant tag, click Create a webhook, then Create a connection.
Optional: In the Connection name field, enter a name for the connection.
Optional: Switch on the Show advanced settings toggle and enter your Google Cloud Platform project client credentials. For more information, see the Create and configure a Google Cloud Platform project for Google Sheets section.
Click Sign in with Google.
If prompted, authenticate your account, grant all requested permissions, and confirm access.
You've successfully created the connection and can now use the Google Sheets app in your scenarios. If you want to make changes to your connection in the future, follow the steps here.
You can set up the webhooks for the Perform a Function and Watch Changes instant modules with the Make Google Sheets Add-on or using a specific script in Google Sheets.
Set up a Google Sheets webhook with the Make add-on
To set up the webhooks for the Perform a Function and Watch Changes instant modules with the Make Google Sheets Add-on:
Log in to your Make account, add either the Perform a Function or Watch Changes module to your scenario, and click Create a webhook or Add.
Optional: Enter a name for the webhook in the Webhook name field.
Click Save.
Open Google Sheets and the spreadsheet where you want to add the webhook.
Go to Extensions > Add-ons > Get add-ons.
Search for the Make add-on, and click Install.
You'll be prompted to authenticate your account and confirm access.
The Make add-on should now be added to your spreadsheet.
Go to Extensions > Make > Settings.
In the Settings window, you can paste the webhook URL you copied from the Watch Changes and/or Perform a Function modules in Make. You can also select a Sheet and a Range to watch for changes.
Once you've configured the settings, click Save.
The Perform a Function or Watch Changes module will now send data through the webhook when the selected event occurs.
Set up a Google Sheets webhook with a script
To set up the webhooks for the Perform a Function and Watch Changes instant modules using a script, watch the video tutorial that explains the step-by step process, or follow the steps below. Click here to access the script used in the tutorial.
Log in to your Make account, add either the Perform a Function or Watch Changes module to your scenario, and click Create a webhook or Add.
Optional: Enter a name for the webhook in the Webhook name field.
Click Save.
Next you will paste a script into your spreadsheet. Click here to access the script and copy the entire content.
Open the spreadsheet and go to Extensions > Apps Script. You will see a new project containing default content.
Delete the default content and paste the script you copied in Step 4. This script must be updated with the webhook address from your Google Sheets module.
To obtain the webhook address, go back to your scenario, click on the module, and click Copy address to clipboard.
Now return to the Apps Script project in your spreadsheet. At the beginning of the script, you will see the lines WATCH_CHANGE_WEBHOOK_URL = 'https://hook.eu1.make.com/xxx'; and PERFORM_FUNCTION_WEBHOOK_URL = 'https://hook.eu1.make.com/xxx';.
Depending on the module you are using, replace https://hook.eu1.make.com/xxx with the webhook address you copied in Step 7.
It is important to paste the full webhook address into the script to avoid any errors.
Click the Save icon.
In the left sidebar, click the Triggers icon.
Click Add Trigger.
In the Select event type field, select On edit, and click Save.
If prompted, authenticate your account and confirm access.
The Perform a Function or Watch Changes module will now send data through the webhook when the selected event occurs.
To connect to Make using your own client credentials, you can create and configure a project in the Google Cloud Platform.
Create a Google Cloud Platform project for Google Sheets
To create a Google Cloud Platform project:
Log in to the Google Cloud Platform using your Google credentials.
On the welcome page, click Create or select a project > New project. If you already have a project, proceed to the step 5.
Enter a Project name and select the Location for your project.
Click Create.
In the top menu, check if your new project is selected in the Select a project dropdown. If not, select the project you just created.
To create a new project or work in the existing one, you need to have the serviceusage.services.enable permission. If you don’t have this permission, ask the Google Cloud Platform Project Owner or Project IAM Admin to grant it to you.
Enable APIS for Google Sheets
To enable the required APIs:
Open the left navigation menu and go to APIs & Services > Library.
Search for the following API: Google Sheets API and Google Drive API.
Click Gmail API, then click Enable. If you see the Manage button instead of the Enable button, you can proceed to the next step: the API is already enabled.
Configure your OAuth consent screen for Google Sheets
To configure your OAuth consent screen:
In the left sidebar, click Google Auth Platform.
If you don't see Google Auth Platform in the left sidebar, click View all products at the top of it, then pin Google Auth Platform to the sidebar.
Click Get Started.
In the Overview section, under App information, enter Make as the app name and provide your Gmail address. Click Next.
Under Audience, select External. Click Next.
For more information regarding user types, refer to Google's Exceptions to verification requirements documentation.
Under Contact Information, enter your Gmail address and click Next.
Under Finish, agree to the Google User Data Policy.
Click Continue > Create.
Click Create OAuth Client.
In the Branding section, under Authorized domains, add make.com and integromat.com. Click Save.
Optional: In the Audience section, add your Gmail address on the Test users page, then click Save and continue if you want the project to remain in the Testing publishing status. Read the note below to learn more about the publishing status.
In the Data Access section, click Add or remove scopes, add the following scopes:
https://www.googleapis.com/auth/spreadsheets
https://www.googleapis.com/auth/drive
You can add scopes using:
- A table with filters
- A window to manually enter scopes:
Click Update.
Click Save.
Publishing Status
Testing: If you keep your project in the Testing status, you will be required to reauthorize your connection in Make every week. To avoid weekly reauthorization, update the project status to In production.
In production: If you update your project to the In production status, you will not be required to reauthorize the connection weekly. To update your project's status, go to the Google Auth Platform, the Audience section, and click Publish app. If you see the notice Needs verification, you can choose whether to go through the Google verification process for the app or to connect to your unverified app. Currently connecting to unverified apps works in Make, but we cannot guarantee the Google will allow connections to unverified apps for an indefinite period.
For more information regarding the publishing status, refer to the Publishing status section of Google's Setting up your OAuth consent screen help.
Create your Google Sheets client credentials
To create your client credentials:
In Google Auth Platform, click Clients.
Click + Create Client.
In the Application type dropdown, select Web application.
Update the Name of your OAuth client. This will help you identify it in the platform.
In the Authorized redirect URIs section, click + Add URI and enter the following redirect URI:
https://www.integromat.com/oauth/cb/google/
Click Create.
Click the OAuth 2.0 Client you created, copy your Client ID and Client secret values, and store them in a safe place.
You will use these values in the Client ID and Client Secret fields in Make.
Templates
You can look for Google Sheets templates in Make's template gallery, where you'll find thousands of pre-created scenarios.