What is your goal?
"I’m building an automated newsletter submission pipeline. When an email arrives with event submissions, Claude processes them into structured JSON, and the results should be written as new rows into a Google Sheet for review before publishing."
What is the problem & what have you tried?
“My scenario runs successfully with 14 Google Sheets Add a Row operations, each reporting a row number in the output log. The correct spreadsheet and sheet tab are selected, the Google account is the owner, connection verifies successfully, no named ranges or filters on the sheet. But no data appears in the spreadsheet after the run. Tried both Search by path and Select from all. Any ideas?”
Error messages or input/output bundles
No errors, just not loading any data in google sheets
Claude AI is stumped
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 click here and provide the requested information.
A. 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).
Expand Instructions ◀
Please directly upload screenshots into the post editor. Using the forum’s image hosting allows for zooming in when clicked, and avoids third-party cookies or tracking.
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 Images
- Drag image files directly into the rich-text editor, or
- Click on the upload button in the editor toolbar to select files:
B. 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.
Expand Instructions ◀
A. Export Blueprint
In the scenario editor, click the three dots at the top-right, then select “Export blueprint”.
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.
C. Properly-formatted Output Bundles from a Scenario Run
Please provide the Output bundle of each of the relevant modules from the Scenario History, or by re-running the scenario.
Expand 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 with the “Preformatted Text” (code) button in the rich-text editor. Otherwise the forum software will change the content, making them invalid!
Formatting IS Important!
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.
Providing the Output bundle will allow others to replicate what is going on, especially if there are complex data structures (like nested arrays and collections) and data from external services. This helps us with answering your question with valid examples, like mapping raw variable names (instead of the label/display name).
Sharing these details will help you get better answers, faster.
— @samliew
P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!
Hey Colleen
This is a sneaky one because Make reports success even when something’s off. A few things to check
-
Re select the spreadsheet from scratch make caches the Sheet ID at mapping time, so if the file was ever copied or renamed, the module silently targets the old one even if the name looks correct in the dropdown.
-
Check if your rows are writing to row 1 every time. If first row contains headers isn’t enabled, Make overwrites row 1 on each run and it looks like nothing happened.
-
Verify the mapped fields actually have values at runtime. Open the execution log, click the Sheets module bubble, and check the Output tab if the field values are empty there, the issue is upstream in your mapping, not the Sheets connection itself.
-
Check for active filter views in the sheet. Go to Data remove filter. The rows may have been written but are hidden under a filter.
I have been experiencing similar issues. are you using 'Use column headers as IDs of the columns’? I noticed thats when i started experiencing issues. It’ll work when I add a new module but it will stop randomly.
Hey Colleen, ran into this exact thing before. When Add a Row says success and hands back a row number but you see nothing, it’s almost always one of two things.
First one: the rows are landing way down the sheet. Make appends after the last cell that has anything in it, so if there’s a stray value or some leftover formatting sitting down at like row 2000, every new row drops below that. Quick check: look at the row numbers in your output log. If they’re big instead of 2, 3, 4 and so on, hit Ctrl+End in the sheet and you’ll probably find all your data parked way down there.
Second one: it’s writing to a different file or tab than the one you’ve got open. Happens a lot when the spreadsheet name isn’t unique, because Search by path and Select from all can resolve to different copies. Open the module, grab the actual spreadsheet ID it’s using, and compare it to the ID in the URL of the sheet you’re looking at. Same thing with the tab if you’ve got more than one.