Last Updated: May 10, 2022
Use this function to insert a row at the provided index range in the worksheet.
Insert Row (id_or_url, sheet_name_or_index , row_index, private_key, cient_email)
Input Parameter Name | Description |
---|---|
id_or_url | ID or URL of Google Sheet |
sheet_name_or_index | Name or index of worksheet |
row_index | Index of a Row |
row_values | Row values to be inserted(comma seperated |
private_key | Private key of the service account |
client_email | Email ID of the service account |
Return Value | Description |
---|---|
Output |
|
Insert Row (ABC123, Invoice, 2, (1,2,3,4) —–BEGIN PRIVATE KEY—–\nABCD\n—–END PRIVATE KEY—–, name@project-id.iam.gserviceaccount.com)
To view all the Google Sheets functions, click here.