Use this function to delete the row with the provided index range from the worksheet.

Syntax

Delete Row (id_or_url, sheet_name_or_index , row_index, private_key, client_email)

Parameters

Returns

Sample

Delete Row (ABC123, Invoice, 1, —–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 deletes the row 1.
  Returns Selected row deleted successfully on deleting the row.

To view all the Google Sheets functions, click here.