I’m confused about this action, which I think is relatively new. It says, “Update one or more rows in a specific spreadsheet (with line item support)”, which sounds great, but then in the set up it requires you to pick ONE row to update.
I have tried entering a range (2-4), which creates an error saying that no data (row) was found that matched. I have tried entering the rows with commas separating (2,3,4), which results in it updating row 234 (I got the same result when I tried entering the rows with spaces separating them).
Is there something that I’m missing here? How does this action update multiple rows?
Help article about using line items in Zaps: https://zapier.com/help/create/basics/use-line-items-in-zaps
Data needs to be an array of line items.
Check out Formatter > Utilities > Line Item options
Did you find an answer to this? Troy’s answer is unfortunately not helpful.
@xavierB and @AshleighDLC!
I’ll do my best to explain this in more detail for you.
Your data needs to be in line item format to use the Update Spreadsheet Row(s) action for Google Sheets. Line items are subsets of data, there’s a video in this help doc that explains them really well: Create line items in Zaps
For your example
@AshleighDLC, you would need the row numbers to be line items. In the Zap this will look like a list of row numbers with commas in between them, but the way that the data is structured is different.
If you currently have a list of row numbers, you can convert them into line items using Formatter by Zapier. Use the Text to Line-item transform:
You’ll need to do that for each bit of data that you want to add to the rows (eg for each column in the sheet).
I hope that helps, please let us know if you have any questions!