Search

Get Row Values

Last Updated: May 27, 2021

Articles

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

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
private_key Private key of the service acValues
client_email Email ID of the service acValues

Returns

Return Value Description
Output
  • On Success returns 1, Row Values
  • On Failure returns 0, Error Message

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.

Did you find what you were looking for?