# Google Sheets Add a Row reports success but no data appears in spreadsheet **URL:** \ **Category:** Questions\ **Tags:** google-drive, google-sheets, ai\ **Created:** [June 4, 2026, 6:38pm UTC](https://community.make.com/t/google-sheets-add-a-row-reports-success-but-no-data-appears-in-spreadsheet/110279 "2026-06-04T18:38:00Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Colleen\_H](https://avatars.discourse-cdn.com/v4/letter/c/977dab/32.png) [@Colleen\_H](https://community.make.com/u/Colleen_H)\ **Post date:** [June 4, 2026, 6:38pm UTC](https://community.make.com/t/google-sheets-add-a-row-reports-success-but-no-data-appears-in-spreadsheet/110279/1 "2026-06-04T18:38:01Z")
### 🎯 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 ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [June 5, 2026, 1:28am UTC](https://community.make.com/t/google-sheets-add-a-row-reports-success-but-no-data-appears-in-spreadsheet/110279/3 "2026-06-05T01:28:29Z")
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](https://support.microsoft.com/en-au/windows/use-snipping-tool-to-capture-screenshots-00246869-1843-655f-f220-97299b865f6b)”, 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: > > > ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/c/5c7c8f11d1316a1cc6984d252a732946207bf634.png) > > ## 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** ”. > > > ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/5/152b265128a71a7a2937c4f701c4beba3f5f610c.png) > > > > > > - You can upload files and images to this forum by clicking on the upload button: > > > ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/c/5c7c8f11d1316a1cc6984d252a732946207bf634.png) > > > > > > ## B. Create Public Share Link > > > > > > In the scenario editor, click on the **Share button** : > > > ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/a/0ad95b052c1a1651a310868e4eacd432c289022c.png) > > > Read more about the [scenario sharing feature](https://help.make.com/scenario-sharing) 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](https://help.make.com/scenario-history), or by [re-running the scenario](https://help.make.com/scenario-run-replay). > > > **Expand Instructions ◀** > > > > > Click on the white speech bubbles on the top-right of each module and select “**Download output (_or input_) bundles**”. > > > ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/8/2876156ab3ea5bc9e40bbc0edfb9f025406b7c48.png) > > > > > > ## 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: > > > ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/c/5c7c8f11d1316a1cc6984d252a732946207bf634.png) > > > > > > ## 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, > > > > > > - **Method 2: Highlight the pasted content, then click the preformatted text/code button** — > > > ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/7/b/7b91db14846cb99e1084b77e4362a273f8324e74.png) > > > > > > - **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](https://academy.make.com) will save you lots of time and frustration using Make! ---
**Author:** ![Daramola\_oyinkansola](https://avatars.discourse-cdn.com/v4/letter/d/6f9a4e/32.png) [@Daramola\_oyinkansola](https://community.make.com/u/Daramola_oyinkansola)\ **Post date:** [June 5, 2026, 1:54am UTC](https://community.make.com/t/google-sheets-add-a-row-reports-success-but-no-data-appears-in-spreadsheet/110279/4 "2026-06-05T01:54:13Z")
Hey Colleen This is a sneaky one because Make reports success even when something’s off. A few things to check 1. 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. 2. 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. 3. 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. 4. 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. ---
**Author:** ![Ancort05](https://avatars.discourse-cdn.com/v4/letter/a/8491ac/32.png) [@Ancort05](https://community.make.com/u/Ancort05)\ **Post date:** [June 5, 2026, 2:47am UTC](https://community.make.com/t/google-sheets-add-a-row-reports-success-but-no-data-appears-in-spreadsheet/110279/5 "2026-06-05T02:47:48Z")
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. ---
**Author:** ![Michael\_Gronning](https://avatars.discourse-cdn.com/v4/letter/m/41988e/32.png) [@Michael\_Gronning](https://community.make.com/u/Michael_Gronning)\ **Post date:** [June 16, 2026, 4:23pm UTC](https://community.make.com/t/google-sheets-add-a-row-reports-success-but-no-data-appears-in-spreadsheet/110279/6 "2026-06-16T16:23:33Z")
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. ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [September 14, 2026, 4:33pm UTC](https://community.make.com/t/google-sheets-add-a-row-reports-success-but-no-data-appears-in-spreadsheet/110279/7 "2026-09-14T16:33:11Z")