# Updating Multiple Google Sheets Rows **URL:** \ **Category:** Questions\ **Tags:** workflow-building\ **Created:** [April 10, 2025, 6:55pm UTC](https://community.n8n.io/t/updating-multiple-google-sheets-rows/99578 "2025-04-10T18:55:07Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![DertMcGert](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/dertmcgert/32/72165_2.png) [@DertMcGert](https://community.n8n.io/u/DertMcGert)\ **Post date:** [April 10, 2025, 6:55pm UTC](https://community.n8n.io/t/updating-multiple-google-sheets-rows/99578/1 "2025-04-10T18:55:07Z")
Hello, I am using an AI bot to search for address for the names in a google sheet. However, it is only updating the first row of data. I’ve tried adding to the prompt to update more, but not sure what I’m missing. ![Screen Shot 2025-04-10 at 2.55.32 PM](https://europe1.discourse-cdn.com/n8n/original/3X/6/3/63e7c7abba56c999463133415485b323b9c2bf5b.png) ---
**Author:** ![rbreen](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/rbreen/32/106993_2.png) [@rbreen](https://community.n8n.io/u/rbreen)\ **Post date:** [April 10, 2025, 7:12pm UTC](https://community.n8n.io/t/updating-multiple-google-sheets-rows/99578/2 "2025-04-10T19:12:37Z")
Hi @DertMcGert, Your flow didnt come through. Make sure to add the whole flow in a code block so it renders. Try creating a row number in the google sheet. Then this flow will work. I created a wrkflow where it pulls data in from the google sheet, and merges the data on the row number. Then updates the sheet with the coresponding row number. Hope this helps! Robert ---
**Author:** ![DertMcGert](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/dertmcgert/32/72165_2.png) [@DertMcGert](https://community.n8n.io/u/DertMcGert)\ **Post date:** [April 10, 2025, 7:52pm UTC](https://community.n8n.io/t/updating-multiple-google-sheets-rows/99578/3 "2025-04-10T19:52:19Z")
Thanks for your help. I was able to fix the code input. ---
**Author:** ![rbreen](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/rbreen/32/106993_2.png) [@rbreen](https://community.n8n.io/u/rbreen)\ **Post date:** [April 10, 2025, 8:12pm UTC](https://community.n8n.io/t/updating-multiple-google-sheets-rows/99578/4 "2025-04-10T20:12:53Z")
What are the columns of your google sheet so I can replicate. ---
**Author:** ![rbreen](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/rbreen/32/106993_2.png) [@rbreen](https://community.n8n.io/u/rbreen)\ **Post date:** [April 10, 2025, 8:19pm UTC](https://community.n8n.io/t/updating-multiple-google-sheets-rows/99578/5 "2025-04-10T20:19:09Z")
Also, do you have a name I can test with? ---
**Author:** ![rbreen](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/rbreen/32/106993_2.png) [@rbreen](https://community.n8n.io/u/rbreen)\ **Post date:** [April 10, 2025, 8:37pm UTC](https://community.n8n.io/t/updating-multiple-google-sheets-rows/99578/6 "2025-04-10T20:37:46Z")
Here’s how I would do it. As a tool, the agent doesnt bring in one row at a time. Bring the google sheet in as a get row first, then feed it to the agent. I tested with myself, so this code has a different city. But should work for you. ---
**Author:** ![DertMcGert](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/dertmcgert/32/72165_2.png) [@DertMcGert](https://community.n8n.io/u/DertMcGert)\ **Post date:** [April 10, 2025, 9:04pm UTC](https://community.n8n.io/t/updating-multiple-google-sheets-rows/99578/7 "2025-04-10T21:04:07Z")
Thank you! I’m out of SerpAPI credits 🤦‍♂️. But this makes sense to me, and it should work. ---
**Author:** ![rbreen](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/rbreen/32/106993_2.png) [@rbreen](https://community.n8n.io/u/rbreen)\ **Post date:** [April 10, 2025, 9:29pm UTC](https://community.n8n.io/t/updating-multiple-google-sheets-rows/99578/8 "2025-04-10T21:29:28Z")
Perfect! If it solves your question, make sure to mark it as the solution so others can benefit from it. ---
**Author:** ![rbreen](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/rbreen/32/106993_2.png) [@rbreen](https://community.n8n.io/u/rbreen)\ **Post date:** [April 13, 2025, 8:38pm UTC](https://community.n8n.io/t/updating-multiple-google-sheets-rows/99578/9 "2025-04-13T20:38:07Z")
Hi @DertMcGert, Did this solution help you solve your issue? Robert ---
**Author:** ![DertMcGert](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/dertmcgert/32/72165_2.png) [@DertMcGert](https://community.n8n.io/u/DertMcGert)\ **Post date:** [April 14, 2025, 2:32pm UTC](https://community.n8n.io/t/updating-multiple-google-sheets-rows/99578/10 "2025-04-14T14:32:16Z")
It did, thank you. I marked as a solution. ---
**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:** [April 21, 2025, 2:32pm UTC](https://community.n8n.io/t/updating-multiple-google-sheets-rows/99578/11 "2025-04-21T14:32:35Z")
Closed on April 21, 2025, 2:32pm UTC This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.