Google sheet is not updating

Questions
,
1

:bullseye: What is your goal?

use webhooks to send data from website form submissions to Google sheets

:thinking: What is the problem & what have you tried?

The scenario was running fine till last week. Now the data is not getting updated to google sheets. However, the scenario is not showing any errors. In troubleshooting the scenario is running fine from start to end. but google sheet is not getting updated data

:clipboard: Error messages or input/output bundles

No Error

4

When a Make scenario runs end-to-end with no errors but Google Sheets doesn’t update, it’s usually not a webhook issue, but a silent mismatch at the Sheets step.

A few common things to check first:

  • Whether the Sheet / Tab structure changed (renamed tab, deleted column, reordered headers)

  • Whether the module is still pointing to the same spreadsheet + worksheet ID

  • Whether the incoming webhook payload still matches the expected fields (empty values can cause “successful” runs with no row added)

Since it was working until last week, this often points to a schema or reference change, not a runtime failure.

If you want, you can share the Sheets module mapping (no sensitive data needed), and it’s usually possible to spot the break quickly.

5

Welcome to the Make community!

We’d love to help, however, we require more information that demonstrates the problem to help us reproduce the scenario and any issues and errors.

To allow others to assist you, please provide the following:

1. All Relevant Screenshots

We need to see what you’re working with to give you the best advice. Screenshots are important because Make is a visual editor — a picture provides us with more context.

It would help us identify the issue by having screenshots of:

  • the full scenario, and the zoomed in parts of the scenario that you are referring to (if your scenario is huge),
  • a full scenario run/execution from the history (showing output “speech” bubbles),
  • relevant module fields (showing how you’ve used any built-in functions, and how you’ve mapped the variables),
  • relevant filters between modules (showing which operators and any built-in functions you’ve used, and how you’ve mapped the variables),
  • relevant module input/output bubbles,
  • if applicable, any error messages,
  • and if applicable, any external services (spreadsheet headers/ sample data/ regex101.com/ etc. to show the item/ record exists, and is set up correctly).
Need helpâť“View instructions â—€

We would appreciate it if you could directly upload screenshots here instead of linking to them outside of this forum. This allows us to zoom in on the image when clicked, and also having improved privacy from third-party sources.

Taking Screenshots

  • Microsoft Windows: Take screenshots using the “Windows Snipping Tool”, by pressing either PrtSc or WinShiftS keys on your keyboard.
  • MacOS: Take screenshots by pressing CommandShift4 keys on your keyboard.

Uploading Attachments

  • Drag image files directly into the rich-text editor, or
  • Click on the upload button in the editor toolbar to select files:

2. Scenario Blueprint

Providing your scenario will allow others to quickly recreate and see how you have set up the mappings in each module, and also allows us take screenshots or provide module exports of any solutions we have for you in return. This would benefit you in implementing our suggestions as you can view screenshots of the changes or paste corrected modules back into your scenario.

Need helpâť“View instructions â—€

A. Export Blueprint

In the scenario editor, click the three dots at the top-right, then select “Export blueprint”.

  • You can upload files and images to this forum by clicking on the upload button:

    Uploading an attachment here will look like this:
    blueprint.json (12.3 KB)

B. Create Public Share Link

In the scenario editor, click on the Share button:

Read more about the scenario sharing feature in the Help Centre.

3. Properly-formatted Output Bundles from a Scenario Run

Please provide the input/output bundles of each of the relevant modules by running the scenario, or get the bundles from a previous run from the Scenario “History” tab.

Providing the bundles from a scenario run will allow others to replicate what is going on, especially if there are complex data structures (nested arrays and collections) and external services. This helps mapping the correct raw variable names from collections (instead of the label/display name).

Need helpâť“View instructions â—€

Click on the white speech bubbles on the top-right of each module and select “Download output (or input) bundles”.

A. Upload a Text File

Save each bundle contents in a plain text editor as a moduleNumber-output.txt file. Open the file to check if it has not added additional formatting or encoded the plain text.

  • You can upload files and images to this forum by clicking on the upload button:

    Uploading an attachment here will look like this:
    module1-input.txt (1.2 KB)
    module1-output.txt (3.4 KB)

B. Insert a Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the bundles AND format them correctly.

:warning: Formatting IS Important! :warning:

Here are some ways to provide text content in a way that it won’t be modified by the forum.

  • Method 1: Type code fence manually —
    Manually type three backticks ``` in a separate line before and after the content, like this,

    ```
text goes here
```

  • Method 2: Highlight the pasted content, then click the preformatted text/code button —

  • Method 3: Upload your file elsewhere and share the public link —
    This method is only advised for large files exceeding the forum upload limit.

Sharing these details will make it easier for others to assist you, so that you can get better answers, faster.

Hope this helps! If you are still having trouble, please provide more details.

— @samliew
P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!

6

Hi — if the scenario runs end-to-end with no errors but the Sheet doesn’t change, it’s usually one of these:

1) Google Sheets module is writing to the wrong place

  • Wrong Spreadsheet / Sheet / Tab

  • Wrong Range or Row number (updates a different row than you’re looking at)

  • If using “Update a row”: the Row ID may be blank/incorrect, so nothing gets updated.

2) It’s creating/updating, but not visible because of filters / protected ranges

  • Check if the sheet has filters, frozen header, or you’re viewing a filtered subset.

  • Check for protected range / sheet protection (writes can silently fail depending on setup).

3) The Google connection/token needs re-auth
This happens after some time or permission changes.

  • Reconnect the Google Sheets connection in Make (Connections → Google Sheets → Reauthorize).

  • Also confirm the Google account still has Edit access to that spreadsheet.

4) Webhook is firing, but bundles are empty / mapping is blank
In the run log, open the bundle right before Google Sheets:

  • Make sure the fields you map into Sheets are not empty.
    If they’re empty, Sheets writes “nothing” and looks like it didn’t update.

5) The module is set to “Search rows” but not finding a match
If you “Search Rows” then “Update Row”, and the search returns 0 rows, the update never happens.
Fix by:

  • Adding a fallback path: if 0 rows → Add a row

  • Or ensure your search key (email/ID) matches exactly (trim spaces, consistent casing).

:white_check_mark: To diagnose fast: please share screenshots of:

  • The Google Sheets module settings (which action you use)

  • The run log for the Google Sheets module (Input + Output)

  • Whether you are using Add row or Update row, and how you determine the row

Once we see the Sheets module output, we can tell immediately if it’s writing elsewhere, not finding a row, or failing auth.