Supported Google Sheets Connector Types
Add a Google Sheets connector to authorize ThingWorx Flow to execute Google Sheets actions. ThingWorx Flow supports the following connector types for Google Sheets:
OAuth
OAuth (Named User)
OAuth (Session User)
* 
Before you create a Google Sheets OAuth connector, ensure that you load Google Sheets OAuths to the ThingWorx Flow server.
Adding an OAuth connector
1. Drag any action under Google Sheets to the canvas, place the pointer on the action, and then click or double-click the action.
2. For Connector Type, select OAuth (Named User) or OAuth (Session User).
3. In the Google Sheets list, select Add new Google Sheets login – Named User or Add new Google Sheets login – Session User.
* 
If you have not loaded Google Sheets OAuths to the ThingWorx Flow server, this option is not available.
4. Provide your user name and password to log in to Google Sheets.
5. Review access permissions, and click Allow.
6. Edit the Connector Label, if you want. Labels are case-sensitive. Do not use spaces, special characters, and leading numbers.
7. Click ADD to add the Google Sheets OAuth connector.
Was this helpful?