Google Sheets Spoke
Manage spreadsheets in Google Sheets from your ServiceNow instance.
Request apps on the Store
Visit the ServiceNow Store 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.