i only found a trigger to update a single row in googe sheets, i would like to update multiple rows at once since tasks from asana is moved from a section to another.
Best answer by christina.d
View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Userlevel 7
+9
- Certified Zapier Expert
- 617 replies
-
21 March 2022
Hi
Use this action to create multiple rows at once. Your data needs to be an array or line-items.
Userlevel 7
+11
- Community Manager
- 4706 replies
-
21 March 2022
Hey there,
The Create Spreadsheet Row(s) action would allow you to create multiple new rows but not update multiple existing rows. There’s a feature request open for the ability to update multiple rows in Google Sheets so I’ve added your vote for that. I don’t know when that feature request would be implemented by but we’ll email you as soon as it is!
In the meantime, you may be able to get around this by using Looping by Zapier to make a loop of the different rows to be updated and then inside the loop you’d add an Update Spreadsheet Row action. If you don’t know which rows need updating then you may also need to enlist the help of a Lookup Spreadsheet Row action to search for the relevant row. Then, when the Zap runs it should be able to go through each row in the loop and update it as necessary.
You can find out more about setting up loops here:
And here: Loop your Zap actions
Hope that helps! 
Userlevel 7
+9
- Zapier Staff
- 2653 replies
-
4 January 2023
- Answer
Hey friends! I wanted to pop in and let ya’ll know the “Update Spreadsheet Row(s) action” now supports updating multiple rows! 🎉
Thanks for your patience on this one and happy zapping. ⚡️
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.