Welcome to the Make community!
Please see these duplicate threads asked and answered by other community members:
- How to bulk update non-consecutive rows in Google Sheets using the batchUpdate API? - #3 by samliew
- Updating specific fields in google sheets
- How to bulk map an array of values into multiple rows in same column in Google Sheet - #5 by samliew
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.