Use this function to list the names of all the worksheets in a given Google Sheet.

Syntax

Get Worksheets (id_or_url, private_key, cient_email)

Parameters

Returns

Sample

Get Worksheets (ABC123, —–BEGIN PRIVATE KEY—–\nABCD\n—–END PRIVATE KEY—–, name@project-id.iam.gserviceacValues.com)

• Uses the private key —–BEGIN PRIVATE KEY—–\nABCD\n—–END PRIVATE KEY—– to connect to the Email ID name@project-id.iam.gserviceacValues.com, lists the names of all the worksheets using the ID ABC123.
  Returns the values Travel, Expenses, Invoice.

To view all the Google Sheets functions, click here.