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.

  • In accordance with the Nintex Privacy Policy, Nintex Services do not retain any information obtained from third party services.

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 A software component that allows seamless integration with third-party services, business applications, and content stores. Examples include Salesforce, Box, and Microsoft SharePoint. Connectors are used to create connections required for workflow actions and start events. 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.

Jump to:

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 lookup

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

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 form 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 form control uses a Google Sheets - Get spreadsheets data lookup to list the spreadsheets available from the Google Sheets connection.

You can create a data lookup to:

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