How to add Google Sheets module on Make

Navigate to https://www.make.com/en/login and log into your Make account. Once logged in, go to the Scenarios tab in the left sidebar. Click Create a new scenario to start fresh, or select an existing scenario to edit. This opens the visual scenario builder where you will add your Google Sheets module.

In the scenario builder canvas, click the plus icon (+) to add a new module. In the search bar that appears, type Google Sheets and select it from the results. A menu will display available actions such as Add a Row (appends data), Watch New Row (triggers on new rows), Bulk Add Rows (advanced multi-row operations), and others. For most basic integrations, select Add a Row to append new data to your spreadsheet.

After selecting your action, click the Create a connection button. A new window will pop up displaying your available Google accounts. Select the Google account that contains the spreadsheet you want to connect. If you have multiple Google accounts linked to your browser, ensure you select the correct one. Google will then display a permission screen showing what access Make is requesting. Review the permissions and click Continue to proceed. Check all permission checkboxes to grant Make the necessary operations on your spreadsheets, then click Continue again to confirm. The connection typically establishes within a few seconds as Make verifies with Google's servers.

Once the connection is established, you'll see a Spreadsheet field. Click on Choose file to display a list of your available Google Sheets. Select the specific spreadsheet you want to work with for this automation. You can identify your sheet by its name or by the URL format https://docs.google.com/spreadsheets/d/[SHEET-ID]/edit. If you have many sheets, use the search function to quickly locate the correct one.

After selecting your spreadsheet, look for the Sheet dropdown menu. Click on it and select the specific tab (sheet) within your spreadsheet where you want data to be added or modified. This is important if your spreadsheet contains multiple tabs (e.g., Sheet1, Sheet2, Clients, etc.). By default, the first available sheet is selected, but you can change this to any tab in your workbook.

Depending on your chosen action, configure the relevant fields. For Add a Row, you'll see a Values section where you map data to columns. Drag outputs from previous modules (e.g., form responses, API data) into the corresponding column fields. For example, map {{1.name}} to Column A and {{1.email}} to Column B. If your spreadsheet's first row contains headers, toggle Table contains headers to Yes. Choose between Select mode (simple mapping) or Map mode (advanced) based on your data structure complexity.

If you're using a trigger module like Watch New Row or Watch Changes, you may need to configure a webhook. Click Create a webhook, optionally name it, and copy the generated webhook URL. If required by your setup, paste this URL into the Google Sheets Add-on (available via Google Workspace Marketplace) or into a custom Apps Script. This enables instant notifications when changes occur in your sheet, rather than relying on slower polling intervals.

Before activating your scenario, test it to ensure the connection and configuration work correctly. Click Run once in the scenario editor toolbar at the bottom. If your scenario includes an upstream trigger (e.g., a form submission), submit test data through that trigger. Watch for green checkmarks on each module, indicating successful execution. Open your Google Sheet and verify that the test data was added correctly (e.g., a new row appeared with your test values). If you see a red error icon, review the error message and adjust your configuration accordingly.

Once testing is complete and you've verified the data in your Google Sheet, click Save in the top-right corner of the scenario editor. This saves all your module configurations and connections. You'll see a confirmation message indicating the scenario has been saved successfully.

Navigate to the Scenarios tab in the left sidebar. Find your newly created scenario in the list and toggle the switch to ON to activate it. Once activated, your automation will run according to your trigger settings (e.g., whenever a form is submitted or on a schedule). You can monitor execution history and logs via the Make dashboard to track successful runs and troubleshoot any issues.