Note: Use and transfer of information received from Google APIs to any other app will adhere to Google API Services User Data Policy, including the Limited Use requirements.

Google Sheets

Google Sheets is a spreedsheet file service developed by Google. Users create, edit, and share spreadsheet files on their Google Drive accounts and invite others to view and/or edit them. You can access spreadsheet titles and data (defined in rows and cells). In the context of Nintex Automation Cloud, Google Sheets is a connector Service used to define a connection required for associated actions and start events. Examples include Salesforce and Box. Method of integration to cloud services, business applications and content stores. used to create connections for Google Sheets actions. Use Google Sheets actions to work with data and spreadsheets in Google Sheets. For more information, see Google Sheets.

Create a Google Sheets connection

Note: Your browser-stored credentials are accessed to create connections. Either clear credentials from browser memory or make sure the stored credentials are for the intended environment.

Create a connection and sign in with Google Sheets from the connections page or from the action configuration panel when configuring the action. For information about creating connections and assigning permissions, see Manage connections.

Create a data source

Use the Google Sheets data source to create a drop-down list of items within a form. Each data source is configured for a specific Google Sheets connection. You can create as many data sources as you need. For more information on creating a data source and assigning permissions to it, see Data sources.

For example, to allow users to select a specific spreadsheet in a form, add a drop-down list of sheets to the form using a Data lookup control A form control that allows users to select from a drop-down list of values that have been fetched from a third-party service.. The Data lookup control uses a Google Sheets - Get spreadsheets data source to list the spreadsheets available from the Google Sheets connection.

You can create a data source to:

  • Get spreadsheets - List all the spreadsheets from your Google Sheets connection.