ThingWorx Flow > Connectors Overview > System Connectors > Google Sheets
  
Google Sheets
Google Sheets is an online spreadsheet application that lets you create and manage spreadsheets and share them with other users.
Connector Release Version
Google Sheets connector was delivered in the 8.4.1 release.
Supported Actions
Add Rows
Create Sheets
Create Spreadsheet
Delete Rows or Columns
Delete Sheets
Get Metadata
Get Sheet Data
Update Rows
Supported Trigger
New Row
Integration Services
Google Sheets API
Supported Authorization
OAuth
* 
Before adding an OAuth connection, ensure that you follow the steps provided in Obtaining Client Id and Client Secrets.
Authorize Google Sheets
Google Sheets authorization has to be done for each Google Sheets connector action. To authorize Google Sheets, do the following:
1. In the Authorize Google Sheets field, select Add new Google Sheet login.
2. On the Set Access window, review the list of access permissions, and then click ALLOW.
3. Enter your credentials, and then click Sign in.
4. In the Add Authorization window, rename the Authorization Label if needed, and then click ADD.
* 
Click TEST to validate the authorization.
©2019 Google LLC All rights reserved. is a trademark of Google LLC.