Update row in google sheet (ERROR)

I need to weekly update specific rows and columns in a Google Sheet with data obtained from an API.

The rows that need to be updated are from the 12th to the 16th, as highlighted in my sheet.

Additionally, the data should be inserted starting from column H.

This update will occur weekly.

How can I ensure that the data is consistently updated in these designated rows and columns?"

@samliew can we do this is make.com?

Need example bundle JSON.

Please provide a copy of this sheet.


Hi @itsmeayyub

Ofcourse! Make.com allows us to make it possible. However, you need to upload the resource from you want to update the sheet on community.

For additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel

1 Like

The easiest way I could find is.

Create a new sheet tab.

Get data in it and using the formula fetch the data from sheet2 to sheet1.

Hi @itsmeayyub First, I recommend following best practices and reformatting your Google sheet so that your headers sit at the top, not in rows.
Give each column a header, then each row will represent an item (or a record).
That way, mapping your data in Make will be more straightforward.

After that, if you’re still having trouble with your scenario, let us know and share screenshots of your module settings and your bundle JSON outputs.
Hope that helps :slight_smile: