Documentation
    {{docApp.userSession.userId}}
    {{docApp.userSession.userName}}
    {{docApp.userSession.email}}
    Issuer : {{docApp.userSession.issuerInstance}}
    Expires : {{new Date(docApp.userSession.validUntil).toLocaleDateString()}}

{{docApp.title}}

{{docApp.description}}

How can we help?

{{docApp.searchError}}
{{product.name}}

Searching in {{docApp.searchFilterBySpecificBookTitle}}

{{docApp.searchResultFilteredItems.length}} results for: {{docApp.currentResultsSearchText}} in {{docApp.searchFilterBySpecificBookTitle}}
Search results have been limited. There are a total of {{docApp.searchResponse.totalResultsAvailable}} matches.

You have an odd number of " characters in your search terms - each one needs closing with a matching " character!

{{docApp.libraryHomeViewProduct.title || docApp.libraryHomeViewProduct.id}}

{{docApp.libraryHomeViewProduct.description}}

  1. {{book.title}}

{{group.title || group.id}}

{{group.description}}

  1. {{book.title}}

{{group.title}}

{{book.title}}
More...

Sheets / Update

  • Article
  • 3 minutes to read

Operation Information

Updates cells within a Google Sheets spreadsheet.

API Documentation: https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/update.

This is a Free Tier Integration.

Authentication

This operation requires authentication, the details of which can be securely stored on your instance in a KeySafe Key of type Google Drive.

To create a key of this type:

  • In the Configuration area of your Hornbill instance, navigate to Platform Configuration > Security > KeySafe;
  • Click on the + Create New Key button;
  • On the resulting Create New Key form, choose Google Drive in the Type pick list;
  • Give the Google Drive KeySafe key a Title (this is the name / identifier for the Google Drive account as you will see it when using the cloud automation node in your workflows);
  • Optionally populate the Description field;
  • Click the Create Key button to create your new key;
  • Once the Key is created, you will need to connect to the target service, and your account, in order to authorize the connector app access to the listed operations. Click the Connect button and you will be redirected to the service provider in a popup window;
  • Log in to your account, and then you will be prompted to review the options you are authorizing the Hornbill connector to be allowed to perform using the chosen account;
  • Accept the review and you will be returned to your KeySafe key.

Tip

If you have revoked your Google KeySafe Token with the Revoke Access button, before you can reconnect Hornbill to your Google account you will need to log in to your Google account and remove Hornbill from the list of third-party apps with account access.

If this is not performed prior to reconnecting your account, then Hornbill will only be able to access the account for up to 1 hour before the access token is expired.

Revoking Access

If at any point you wish to revoke access to any of the above accounts from your Hornbill instance, just hit the Revoke button in the relevant KeySafe key(s).

Warning

This will revoke the rights of any existing Cloud Automation Node in your Hornbill Workflows that are using the revoked Google Drive account, so you will need to manage these workflows accordingly.

Input Parameters

Display Name ID Type Description Required Supported Values
Spreadsheet ID spreadsheetId string The ID of the spreadsheet to append Yes None provided
Sheet Name sheetName string The name of the sheet to append. Defaults to first sheet in spreadsheet if not provided No None provided
Starting Column startingColumn string The column to start inserting data in to Yes A, B, C, D, E, F, G, H, I, J, K, L, M, N, O, P, Q, R, S, T, U, V, W, X, Y, Z
Row row number Row number to update Yes None provided
Cell Data fields array Array of data, each value will be entered in to the cells starting at the Starting Column Yes None provided
Value Input Option valueInputOption string Determines how input data should be interpreted, see https://developers.google.com/sheets/api/reference/rest/v4/ValueInputOption for details. Yes RAW, USER_ENTERED

Output Parameters

Display Name ID Type Description
Success? success boolean Boolean value, is only set when the update is successful
Errors errors string Any errors returned by Google Sheets
Updated Columns updatedColumns number Number of updated Columns
Updated Cells updatedCells number Number of updated Cells
Updated Row updatedRow number The row number that was updated
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document