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 - Append cell data

Use the Google Sheets - Append cell data action A tool for building the processes, logic, and direction within workflows. Actions are the steps the workflow performs to complete a process. to add data to the next empty row of a specific sheet in a spreadsheet.

For example, you can use this action to add form input data as new records to lists of data on the spreadsheet.

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

Before you begin: 

Jump to:

Configure the Google Sheets - Append cell data 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. Select the Spreadsheet you want to add the data to.
  3. Select the Sheet you want to add the data to.
  4. Click Add Row.
  5. Click Add cell.
    Note: 

    Don't leave a cell empty. You must at least add a space to each cell, else your return may present an Invalid Fragment error.

  6. Enter the data you want added to the sheet.
  7. Add more rows and cells of data as needed.
  8. Create or select a variable for the Updated data details output.

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

Google Sheets - Append cell data 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 to append data in the spreadsheet.

To refresh the available connections, click Refresh.

(n/a)
 

Spreadsheet

The spreadsheet to add the data to. When you specify the Google Sheets connection, all the spreadsheets in the selected connection are available to select from in the drop-down list. If you want to select a spreadsheet that is not in the list, you can insert a variable in the Spreadsheet field. When using a variable, use the spreadsheet ID. A spreadsheet ID can be extracted from its URL. For example, the spreadsheet ID in the URL https://docs.google.com/spreadsheets/d/abc123 is "abc123".

Text, Decimal, Integer, Boolean, DateTime, Collection
 

Sheet

The sheet name or number within the spreadsheet that you want to append the data to. When you specify the spreadsheet, all the sheets in the selected spreadsheet are available to select from in the drop-down list. If you want to select a sheet that is not in the list, you can insert a variable in the Sheet field. When using a variable, use the sheet ID.

Text, Decimal, Integer, Boolean, DateTime, Collection
 

Cell Data

The data you want to add to the spreadsheet.

Click Add row, then Add cell. Type in the data value within the cell input box. This appends the data to the first cell of the first empty row of the sheet.

  • Add row: Adds a new row of data cells to the end of the sheet.

  • Add cell: Adds a cell input box to that row. A new cell adds data to the next cell of the row.

    Note: 

    Don't leave a cell empty. You must at least add a space to each cell, else your return may present an Invalid Fragment error.

You can delete a cell or row by clicking the ellipsis and selecting Delete.

 Collection

Output

Updated data details

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

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

  • Updated Range: (Text) The range (in A1 notation) that updates were applied to.

  • Updated rows: (Integer) The number of rows where at least one cell in the row was updated.

  • Updated columns: (Integer) The number of columns where at least one cell in the column was updated.

  • Updated cells: (Integer) The number of cells updated.

 Object