Add data to a Google Sheet starting from row 8

[Herman_Mantilla]

Hi, how can I add data to a Google Sheets starting from row 8? I’m trying using add a row, but it only allows me to add information starting from the beginning of the column and I need to use the template seen in the screenshot as seen and start adding info from row 8 where these columns are:

Microsoft Click ID
Conversion Name
Conversion Time
Conversion Value
Currency Conversion

But Make.com, is not allowing me, sent screenshots to show what make.com shows me

Thank you very much in advance!

[samliew]

You can make a batchUpdate call using the Sheets “Make an API call” module to specify the row number you want to insert.

For more information, see

• Google Sheets Add a Row - Automation is adding a new row above the header, not in the first empty row - #4 by samliew, and

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