# How to Update Multiple Rows in Google Sheets at Once in n8n? **URL:** \ **Category:** Questions\ **Tags:** node, workflow-building, google-sheets\ **Created:** [November 9, 2025, 9:37am UTC](https://community.n8n.io/t/how-to-update-multiple-rows-in-google-sheets-at-once-in-n8n/218558 "2025-11-09T09:37:24Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Tenzin\_Nyima\_10B15](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/tenzin_nyima_10b15/32/135900_2.png) [@Tenzin\_Nyima\_10B15](https://community.n8n.io/u/Tenzin_Nyima_10B15)\ **Post date:** [November 9, 2025, 9:37am UTC](https://community.n8n.io/t/how-to-update-multiple-rows-in-google-sheets-at-once-in-n8n/218558/1 "2025-11-09T09:37:24Z")
![Screenshot 2025-11-09 143445](https://europe1.discourse-cdn.com/n8n/original/3X/0/d/0d4a0832ed4ff511c6930259ed4945903271c40b.png) Hi everyone I’m currently learning n8n and experimenting with Google Sheets automation. I’ve set up a workflow (screenshot attached) that includes: - Trigger: “When chat message received” - AI Agent connected to: - Google Gemini Chat Model - Simple Memory - Get Row(s) in Google Sheets Tool - Update Row in Google Sheets tool When I ask the AI agent something like —\> “Update all tasks due today to priority: High” The agent responds saying it can only update them → one by one\*. Even when I approve it, it behaves in an odd way. instead of updating, it creates duplicate rows with similar data. I understand that the “Update Row” node in Google Sheets requires a unique identifier (like a row number or unique column) to match and update a specific row, so it makes sense that it’s only handling one row at a time. I’d like to know if there’s any workaround to update multiple rows at once. For example, all rows that meet a certain condition. Has anyone managed to handle bulk updates in Google Sheets through n8n? Any tips, patterns, or workarounds (like Function nodes, batch operations, code nodes (JS, Python etc.) would be appreciated. Thanks in advance! 🙏 ## Please share your workflow ## Share the output returned by the last node [ { “output”: “I found two students with G\_activity ‘Book Binding’:\n\n\* **Tenzin Bhuti** (Admission Number: 6675, Class: XIIB)\n\* **Tenzin Yingsal** (Admission Number: 2343, Class: XIB)\n\nI can update these records for you, but I need to do them one by one. Would you like me to update Tenzin Bhuti’s G\_activity to ‘Origami’ first?” } ] ## Information on your n8n setup - **n8n version: 1.119.0** - **Database (default: SQLite):** - **n8n EXECUTIONS\_PROCESS setting (default: own, main):** - **Running n8n via (Docker, npm, n8n cloud, desktop app): Docker** - **Operating system: Windows 11** ---
**Author:** ![mohamed3nan](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/mohamed3nan/32/188347_2.png) [@mohamed3nan](https://community.n8n.io/u/mohamed3nan)\ **Post date:** [November 9, 2025, 10:53am UTC](https://community.n8n.io/t/how-to-update-multiple-rows-in-google-sheets-at-once-in-n8n/218558/2 "2025-11-09T10:53:41Z")
Hi @Tenzin_Nyima_10B15 The limitation here is that the Google Sheet operation only supports updating a single row at a time: ![image](https://europe1.discourse-cdn.com/n8n/original/3X/5/3/53935f1d72f4514e819d271b7b9a67b29808c396.png) A trick I use to work around this is by using the **“AI Agent Tool”** with **“Batch Processing”** , this allows the main agent to call the tool with a customized batch size, or let the model decide it: ![image](https://europe1.discourse-cdn.com/n8n/original/3X/4/6/4658bb27053476ed837d96de33a61b88631c6278.png) Writing a clear or detailed description for the AI Agent Tool will make it easier for the main agent to use it effectively.. Try this approach, I think it’s quite efficient: ![image](https://europe1.discourse-cdn.com/n8n/original/3X/5/b/5be83a25787d1d753e5272b883ccf8baa4c632fd.png) ---
**Author:** ![Tenzin\_Nyima\_10B15](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/tenzin_nyima_10b15/32/135900_2.png) [@Tenzin\_Nyima\_10B15](https://community.n8n.io/u/Tenzin_Nyima_10B15)\ **Post date:** [November 10, 2025, 2:03am UTC](https://community.n8n.io/t/how-to-update-multiple-rows-in-google-sheets-at-once-in-n8n/218558/3 "2025-11-10T02:03:36Z")
Thanks a lot for taking the time to reply! 🙏 I tried your approach with the AI Agent Tool and batch processing, but unfortunately, it didn’t work on my end. When I asked the AI (via the Chat tool) to update all the student records that have **G\_activity: “Origami”** to **“Book Binding”** , it said it couldn’t do it and needed all the values of the other fields. Even after providing all the details, the change didn’t reflect in my Google Sheet. I might be doing something wrong with the prompt or setup though. Really appreciate your help though! ![Screenshot 2025-11-10 072351](https://europe1.discourse-cdn.com/n8n/original/3X/f/9/f9c60b755e8be39a6a7a4b98a21a8098080d6ada.png) ---
**Author:** ![mohamed3nan](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/mohamed3nan/32/188347_2.png) [@mohamed3nan](https://community.n8n.io/u/mohamed3nan)\ **Post date:** [November 10, 2025, 3:10am UTC](https://community.n8n.io/t/how-to-update-multiple-rows-in-google-sheets-at-once-in-n8n/218558/4 "2025-11-10T03:10:51Z")
> [@Tenzin\_Nyima\_10B15](#): > > When I asked the AI (via the Chat tool) to update all the student records that have **G\_activity: “Origami”** to **“Book Binding”** , it said it couldn’t do it and needed all the values of the other fields. you want to update the column that is used for matching which is not possible ![image](https://europe1.discourse-cdn.com/n8n/original/3X/2/3/23bb72263ec6a39b06485217c851474420ef9907.png) ---
**Author:** ![Tenzin\_Nyima\_10B15](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/tenzin_nyima_10b15/32/135900_2.png) [@Tenzin\_Nyima\_10B15](https://community.n8n.io/u/Tenzin_Nyima_10B15)\ **Post date:** [November 10, 2025, 4:21am UTC](https://community.n8n.io/t/how-to-update-multiple-rows-in-google-sheets-at-once-in-n8n/218558/5 "2025-11-10T04:21:26Z")
Thank you for poiiting out my mistake! It works now. I am able to update multiple rows in Google Sheets by asking the AI agent through the Chat Message trigger node. ---
**Author:** ![system](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/system/32/195824_2.png) [@system](https://community.n8n.io/u/system)\ **Post date:** [November 17, 2025, 4:22am UTC](https://community.n8n.io/t/how-to-update-multiple-rows-in-google-sheets-at-once-in-n8n/218558/6 "2025-11-17T04:22:13Z")
Closed on November 17, 2025, 4:22am UTC This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.