Use this function to read the values of a row in a worksheet from the provided index.

Syntax

Get Row Values (id_or_url, sheet_name_or_index, row_index, private_key, cient_email)

Parameters

Returns

Sample

Get Row Values (ABC123, Invoice, 2, —–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, accesses the sheet Invoice using the ID ABC123 and gives the values in the row 2.
  Returns the values 3, XYZ, LAX.

To view all the Google Sheets functions, click here.