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 - Get spreadsheets

Use the Google Sheets - Get spreadsheets action A tool for building the processes, logic, and direction within workflows. Actions are the steps the workflow performs to complete a process. to retrieve a list of all the spreadsheets on your Google Drive.

For more information about the Google Sheets connector, go to Google Sheets.

Before you begin: 

Jump to:

Configure the Google Sheets - Get spreadsheets action

  1. Add the action to the workflow and open the action configuration panel. For more information, see Add an action to the workflow.

  1. Select a Connection. If you do not have a connection, see Add a connection.
  2. Create or select a variable for the Spreadsheets output.

For more information on all the required and optional configuration fields, go to Google Sheets - Get spreadsheets action fields, buttons, and settings.

Google Sheets - Get spreadsheets action fields, buttons, and settings

Section

Field

Description

Variable types
(unlabeled)

Connection Credentials and other settings that enables workflows to communicate with external systems, services, or applications. It's required to pass data between the workflow and the indicated service, which could be a cloud service, business application, or content store.

The Google Sheets connection to use for retrieving the list of spreadsheets.

To refresh the available connections, click Refresh.

(n/a)
Output

Spreadsheets

The variable to store the retrieved list of spreadsheets for use later in the workflow.

  • Spreadsheets: (Collection) The list of spreadsheets.

    • ID: (Text) The unique identifier of the spreadsheet.

    • Name: (Text) The name of the spreadsheet.

Object