{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":21251,"path":"integrate-applications/integration-hub/gsheets-spoke.md","title":"Google Sheets Spoke","bundle":null,"doc_type":null,"release":"australia","body":"\n# Google Sheets Spoke\n\nManage spreadsheets in Google Sheets from your ServiceNow instance.\n\n## Request apps on the Store\n\nVisit the [ServiceNow Store](https://store.servicenow.com/sn_appstore_store.do#!/store/home) 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](https://www.servicenow.com/docs/r/store-release-notes/sn-store-release-notes.html).\n\n## Integration Hub subscription\n\nThis spoke requires an Integration Hub subscription. For more information, see [Legal schedules - IntegrationHub overview](https://www.servicenow.com/content/dam/servicenow-assets/public/en-us/doc-type/legal/snc-addendum-integrationhub.pdf).\n\n## Spoke version\n\nGoogle Sheets spoke v1.0.7 is the latest version. For version history of the spoke, see [Google Sheets spoke release notes](https://www.servicenow.com/docs/r/store-release-notes/store-integrationhub-rn-google-sheets.html).\n\n## Spoke dependencies\n\nIf you’re having trouble installing the app, ensure that these dependent plugins are installed:\n\n-   ServiceNow Flow Designer - Dynamic Inputs \\(com.glide.hub.dynamic\\_inputs\\)\n-   ServiceNow IntegrationHub Action Step - REST \\(com.glide.hub.action\\_step.rest\\)\n-   Complex Object \\(com.glide.cobject\\)\n-   ServiceNow IntegrationHub Runtime \\(com.glide.hub.integration.runtime\\)\n\n**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.\n\n## Supported versions\n\nThis spoke was built for Google Sheets v4, but may be compatible with later versions.\n\n## Spoke requirements\n\nGoogle Cloud Platform account.\n\n## Spoke actions\n\nThe Google Sheets spoke provides actions to automate Google Sheets tasks when events occur in your ServiceNow instance. Available actions include:\n\n|Category|Action|Description|\n|--------|------|-----------|\n|Sheet Management|Add Row|Adds a row with the specified values to a sheet.|\n|Clear Cells|Clears the values in the sheet for the specified range.|\n|Copy Sheet|Copies a sheet from a spreadsheet to another spreadsheet.|\n|Create Sheet|Creates a sheet in the specified spreadsheet.|\n|Delete Sheet|Deletes a sheet in the spreadsheet.|\n|Get Cell Values|Retrieves the values in the sheet for the specified range.|\n|Update Cells|Updates a range of cell values in a sheet.|\n|Spreadsheet Management|Get Spreadsheet Details|Retrieves details about the specified spreadsheet.|\n\n## Connection and credential alias requirements\n\nIntegration 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](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/platform-security/r-credentials.md).\n\nFor information about setting up the spoke, see [Set up the Google Sheet spoke](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/integration-hub/setup-gsheets.md).\n\n"}}