Welcome to the Make community!
Previously-asked similar questions were asked on this forum, but were inconclusive:
- Google Sheets Add a Row - Automation is adding a new row above the header, not in the first empty row
- Automation is adding a new row above the header, not in the first empty row
You’ll need to use Google Sheets “Make an API Call” module to call the spreadsheets.batchUpdate endpoint to request for a “InsertDimensionRequest”.
You may get something that looks similar to this by following the above documentation (this example is for DeleteDuplicatesRequest)
