Use this function to rename a worksheet in the Google Sheet.

Syntax

Rename Worksheet (id_or_url, sheet_name_or_index , new_sheetname, private_key, cient_email)

Parameters

Returns

Sample

Rename Worksheet (ABC123, Invoice, Travel_Invoice, —–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 worksheet Invoice using the ID ABC123 and renames it to Travel_Invoice.
  Returns Worksheet has been renamed successfully on renaming the worksheet.

To view all the Google Sheets functions, click here.