Use this function to update the specified range of cell(s) with the specified value.

Syntax

Update Cells (id_or_url, sheet_name_or_index , rng, value, row_values, private_key, cient_email)

Parameters

Returns

Sample

Update Cells (ABC123, Invoice, A1:B1, (1,2), —–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 updates the cells in the range A1:B1 with the values 1, 2.
  Returns Cell value is updated on updating the row.

To view all the Google Sheets functions, click here.