Productivity

Google Sheets

5min
Document image


Google Sheets is a spreadsheet application. With the Google Sheets app in , you can manage the spreadsheets, rows, and cells in your Google Sheets account.

Requirements

To use the Google Sheets app in , you must have a Google account.

'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 

To create the connection:

1

Log in to your  account, add a Google Sheets module to your , and click Create a connection.

If you add a module with an ​instant​ tag, click ​Create a webhook​​, then ​Create a connection​​.

2

Optional: In the Connection name field, enter a name for the connection.

3

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.

4

Click Sign in with Google.

5

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 . If you want to make changes to your connection in the future, follow the steps here.

The  Google Sheets Add-on is currently not available, and the following procedure should be followed to use the Perform a Function and Watch Changes instant modules.

You can 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.



To use the Google Sheets the Perform a Function and Watch Changes instant modules, you must first paste a script and your module's webhook address into your spreadsheet.

1

Log in to your  account, add either the Perform a Function or Watch Changes module to your , and click Create a webhook or Add.

2

Optional: Enter a name for the webhook in the Webhook name field.

3

Click Save.

4

Next you will paste a script into your spreadsheet. Click here to access the script and copy the entire content.

5

Open the spreadsheet and go to Extensions > Apps Script. You will see a new project containing default content.

6

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.

7

To obtain the webhook address, go back to your scenario, click on the module, and click Copy address to clipboard.

8

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';.

9

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.

10

Click the Save icon.

11

In the left sidebar, click the Triggers icon.

12

Click Add Trigger.

13

In the Select event type field, select On edit, and click Save.

14

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.

Templates

You can look for Google Sheets templates in Make's template gallery, where you'll find thousands of pre-created .

Google Sheets resources