Create Worksheet
Last Updated: Sep 13, 2021
Last Updated: Sep 13, 2021
Use this function to create a new worksheet in a Google Sheet with the given row-column count.
Create Worksheet (id_or_url, sheet_name , row_count, col_count, private_key, cient_email)
| Input Parameter Name | Description |
|---|---|
| id_or_url | ID or URL of the Google Sheet |
| sheet_name | Name of worksheet |
| row_count | Number of rows to be generated in a worksheet |
| col_count | Number of columns to be generated in a worksheet |
| private_key | Private key of the service account |
| client_email | Email ID of the service account |
| Return Value | Description |
|---|---|
| Output |
|
Create Worksheet (ABC123, Invoice, 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.