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?
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!
Welcome to the Make community!
See How to bulk update non-consecutive rows in Google Sheets using the batchUpdate API? - #3 by samliew
samliew – request private consultation
Join the unofficial Make Discord server to chat with other makers!