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 - Create a spreadsheet

Use the Google Sheets - Create a spreadsheet action A tool for building the processes, logic, and direction within workflows. Actions are the steps the workflow performs to complete a process. to create a new spreadsheet 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 - Create a spreadsheet 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. Specify the Title for the new spreadsheet.

  3. Create or select a variable for the Spreadsheet output.

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

Google Sheets - Create a spreadsheet 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 create the new spreadsheet. The spreadsheet is created for the user configured in the connection.

To refresh the available connections, click Refresh.

(n/a)
 

Title

The name of the new spreadsheet.

Text, Decimal, Integer, Boolean, DateTime, Collection

Output

Spreadsheet

Stores the result of the action as an object with the following variables:

  • Spreadsheet ID: (Text) The ID of the spreadsheet.

  • Properties: (Object)

    • Title (Text) The title of the spreadsheet.

  • Spreadsheet URL: (Text) The Google Drive link to the spreadsheet.

 Object