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.
1 Like
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
1 Like
Thanks for your help. I was able to fix the code input.
1 Like
What are the columns of your google sheet so I can replicate.
Also, do you have a name I can test with?
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.
2 Likes
Thank you! I’m out of SerpAPI credits 
. But this makes sense to me, and it should work.
1 Like
Perfect! If it solves your question, make sure to mark it as the solution so others can benefit from it.
It did, thank you. I marked as a solution.
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.