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

Use the Google Sheets - Update 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 update a specific range of cells within a spreadsheet.

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

Before you begin: 

Jump to:

Configure the Google Sheets - Update 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 update.
  3. Specify the Range to identify the sheet and area to update.
  4. Click Add Row in Cell data.
  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 to update.
  7. Add more rows and cells of data as needed.
  8. Create or select a variable for the Cell Data output.

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

Google Sheets - Update 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 for updating the range of cells within a spreadsheet.

To refresh the available connections, click Refresh.

(n/a)
 

Spreadsheet

The spreadsheet you want to update. 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
 

Range

The area of the spreadsheet containing the cells to update. This includes the sheet ID value and cell values using A1 notation.

A1 notation

This is a string like Sheet1!A1:B2, that refers to a group of cells in the spreadsheet, and is typically used in formulas. For example, valid ranges are:

  • Sheet1!A1:B2 refers to the first two cells in the top two rows of Sheet1.

  • Sheet1!A:A refers to all the cells in the first column of Sheet1.

  • Sheet1!1:2 refers to all the cells in the first two rows of Sheet1.

  • Sheet1!A5:A refers to all the cells of the first column of Sheet 1, from row 5 onward.

  • A1:B2 refers to the first two cells in the top two rows of the first visible sheet.

  • Sheet1 refers to all the cells in Sheet1.

Named ranges are also supported. When a named range conflicts with a sheet's name, the named range is preferred.

If the sheet name has spaces or starts with a bracket, surround the sheet name with single quotes ('), e.g., 'Sheet One'!A1:B2. For simplicity, it is safe to always surround the sheet name with single quotes.

Text, Decimal, Integer, Boolean, DateTime, Collection
 

Cell Data

The data you want to update in the spreadsheet.

Click Add row, then Add cell. Type in the data value within the cell field. This updates the data in the first cell of the first row of the defined area.

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

  • Add cell: Adds a cell data field to that row. A new cell updates data in the next cell of the r ow.
    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