Sign up for free
Functions

UPDATE_GOOGLE_SHEETS

Update cell values in Google Sheets spreadsheets.

icon of Google SheetsGoogle Sheets
Not a big fan of functions?
Use the Actions Wizard to configure any action in Rows without functions.

Parameter List

Syntax
UPDATE_GOOGLE_SHEETS(data, destination, url)
data

Range with the data source that will be sent to Google Sheets. For example: A1:B10.

destination

Google Sheets range where to update the values. For example: "A1:B10" or "Sheet1!A1:B2". Don't use the sheet name in the destination when the url is for a specific sheet.

url

The spreadsheet URL from Google Sheets. For example: https://docs.google.com/spreadsheets/d/{spreadsheetId}/edit#gid=0.

Examples

UPDATE_GOOGLE_SHEETS(A1:B2, "A2:B3", https://docs.google.com/spreadsheets/d/18kZlHtXpmxFBw942sQDAW3L9O2kHKG14x0JVbUI1eXc/edit#gid=303775600) returns a summary of the values that were updated on Google Sheets.