Sign up for free
Functions

EXPORT_TO_GOOGLE_SHEETS

Add or append 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
EXPORT_TO_GOOGLE_SHEETS(data, destination, url)
data

Range with the data to send to Google Sheets. For example: "A1:B10".

destination

Range in Google Sheets where you want to add the values. For example: "A1:B10" or "Sheet1!A1:B2". Don't use the sheet name in the destination when the url points to the specific sheet.

url

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

Examples

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