Use this function to insert a row at the provided index range in the worksheet.

Syntax

Insert Row (id_or_url, sheet_name_or_index , row_index, private_key, cient_email)

Parameters

Returns

Sample

Insert Row (ABC123, Invoice, 2, (1,2,3,4) —–BEGIN PRIVATE KEY—–\nABCD\n—–END PRIVATE KEY—–, name@project-id.iam.gserviceaccount.com)

• Uses the private key —–BEGIN PRIVATE KEY—–\nABCD\n—–END PRIVATE KEY—– to connect to the Email ID name@project-id.iam.gserviceaccount.com, accesses the sheet Invoice using the ID ABC123 and inserts the row at index 2 and inserts the values 1, 2, 3, 4 in the row.
  Returns Row inserted successfully on inserting the row.

To view all the Google Sheets functions, click here.