Google Sheets Sink

Send data to Google Sheets and update/append values on a spreadsheet.

Metadata

Name	Type	Required	Default	Description
`spreadsheetId`	string	✓		The Spreadsheet ID to be used as identifier
`clientId`	string	✓		Client ID of the sheets application
`clientSecret`	string	✓		Client Secret of the sheets application
`accessToken`	string	✓		OAuth 2 access token for google sheets application. This typically expires after an hour so refreshToken is recommended for long term usage.
`refreshToken`	string	✓		OAuth 2 refresh token for google sheets application. Using this, the Google Calendar component can obtain a new accessToken whenever the current one expires - a necessity if the application is long-lived.
`applicationName`	string			Google Sheets application name
`operation`	string		`append`	Operation to execute (update or append)
`range`	string			The cell range of rows and columns to write data to.
`majorDimension`	string		`ROWS`	Specifies the major dimension that the given values should use (ROWS or COLUMNS).
`columnNames`	string		`A`	Optional custom column names that map to cell coordinates based on their position.
`valueInputOption`	string		`USER_ENTERED`	Controls how the entered values should be be interpreted when adding them.