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.
|
|
|
The the OAuth provider label can not be Google.
|
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.
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.