Is it impossible to add multiple google sheets rows at the same time?

hey guys, pls help!! I have this scenario in make.com where i have a “google sheet get range values” to get a certain number of rows from a spreadsheet, and then I need to insert those rows into another sheet. I am currently using an “google sheet update row”, but when i do that, all the values from the get range values change in the same row. But instead, I want them to populate each cell from the column. How can I do that?

image

image

Hello @Easy_Buy,

There are a few methods you can use to add multiple rows at the same time in Google Sheets.
You’ll need to construct your own values object and use a Google Sheets Make an API Call module to add them using the batchUpdate endpoint. More details can be found in this post I made about a month ago which goes over how to do it manually or use a third-party custom app (for some fee).

Please check it out and let us know if you have any questions!

1 Like

Welcome to the Make community!

See How to bulk update non-consecutive rows in Google Sheets using the batchUpdate API? - #3 by samliew

samliewrequest private consultation

Join the unofficial Make Discord server to chat with other makers!

1 Like