Updating multiple rows in Google Sheets using Zapier

I need help with updating multiple rows within my google spreadsheets

Imagine it like this. I have data A,B,C

Table goes by collumns Jan,Feb,Mar

Rows are 2,3,4

I would like to add data exactly like in this example, according to rows 2:A , 3:B , 4:C in collumn January

There is an option to update only one row so i can imput only data A and not data A and for the next row data B? this does not make any sense

Please i need help. Has anyone experienced adn resolved this issue ?

Page 1 / 1

Hi @Patrick2304

OPTIONS:

Action: GSheets - Update Spreadsheet Rows
- Handles data structured as an array of line items
- Line Items help:
Action: GSheets - Update Row
- Use Looping to iterate thru each row to update
  - Looping help: https://zapier.com/apps/looping/integrations#help
Action: GSheets - API Request
- Allows you to make a custom GSheets API Request
  - GSheets API: https://developers.google.com/workspace/sheets/api/guides/concepts

Hi @Patrick2304,

Checking in to see if Troy’s advice helped you move forward.

If you're still experiencing issues, don't hesitate to let us know. We’re glad to help!

Sign up