Manage spreadsheets in Google Sheets from your ServiceNow instance.

Request apps on the Store

Visit the ServiceNow Store website to view all the available apps and for information about submitting requests to the store. For cumulative release notes information for all released apps, see the ServiceNow Store version history release notes.

Integration Hub subscription

This spoke requires an Integration Hub subscription. For more information, see Legal schedules - IntegrationHub overview.

Spoke version

Google Sheets spoke v1.0.7 is the latest version.

Spoke dependencies

If you’re having trouble installing the app, ensure that these dependent plugins are installed:

  • ServiceNow Flow Designer - Dynamic Inputs (com.glide.hub.dynamic_inputs)
  • ServiceNow IntegrationHub Action Step - REST (com.glide.hub.action_step.rest)
  • Complex Object (com.glide.cobject)
  • ServiceNow IntegrationHub Runtime (com.glide.hub.integration.runtime)
Note: Some of these plugins are licensable features and require an appropriate license if used outside the spoke implementation. For information on licenses, contact your account manager.

Supported versions

This spoke was built for Google Sheets v4, but may be compatible with later versions.

Spoke requirements

Google Cloud Platform account.

Spoke actions

The Google Sheets spoke provides actions to automate Google Sheets tasks when events occur in your ServiceNow instance. Available actions include:

Category Action Description
Sheet Management Add Row Adds a row with the specified values to a sheet.
Clear Cells Clears the values in the sheet for the specified range.
Copy Sheet Copies a sheet from a spreadsheet to another spreadsheet.
Create Sheet Creates a sheet in the specified spreadsheet.
Delete Sheet Deletes a sheet in the spreadsheet.
Get Cell Values Retrieves the values in the sheet for the specified range.
Update Cells Updates a range of cell values in a sheet.
Spreadsheet Management Get Spreadsheet Details Retrieves details about the specified spreadsheet.

Connection and credential alias requirements

Integration Hub uses aliases to manage connection and credential information. Using an alias eliminates the need to configure multiple credentials and connection information profiles when using multiple environments. If the connection or credential information changes, you don't need to update any actions that use the connection. For more information, see Connections and Credentials.

For information about setting up the spoke, see Set up the Google Sheet spoke.