Search

Append Column

Last Updated: Mar 15, 2021

Articles

Use this function to append the column at the end of the selected worksheet.

Syntax

Append Column (id_or_url, sheet_name_or_index , no_of_columns, 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
no_of_columns Number of columns to be appended at the end of the worksheet
private_key Private key of the service account
client_email Email ID of the service account

Returns

Return Value Description
Output
  • On Success returns 1, <Column Count> column(s) appended successfully
  • On Failure returns 0, Error Message

Sample

Append Column (ABC123, Invoice, 3, —–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 sheet Invoice using the ID ABC123 and appends 3 columns at the end of the sheet.
    Returns 3 column(s) appended successfully on appending the columns.

To view all the Google Sheets functions, click here.

Did you find what you were looking for?