Insert row on top in Google Sheet

Questions & Answers
1

Hello,

I’m looking for a way to insert a row at the top of my Google Sheet table just below my column names, but at the moment I can only add a row at the bottom of my table.

I’ve read a solution that hides column A, but I want to keep this column.

Do you have a solution?

Thanks

2

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

2 Likes
3

Thank you for your feedback,

However, I got an error like this: The requested URL was not found on this server.

I used the following URL request: https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}:batchUpdate , as indicated in the google documentation.

Do you have any idea why I’m getting this error?

4

You are likely using a full URL instead of a relative URL, as described below the URL field.

2 Likes