Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

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?

Hi @AshleighDLC 

Good question.

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.

Hi @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:

  • In the Set up action section, click the Transform dropdown menu and select Text to Line-item.
  • In the Values section, click the Input field and select a trigger field with information formatted as comma-separated values (e.g., “apples,bananas,oranges”).
  • Click Continue.

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!

Terms & Conditions