Exporting your table records to Google Sheets

  • Rversion finale: Australia
  • Mis à jour 12 mars 2026
  • 1 minute de lecture

    • Integrate your ServiceNow instance and Google Cloud Console so that you can export table records directly to the cloud-based Google Sheets in Google Drive. With this integration, you can view, share, and work on data outside the platform by using spreadsheets.

    In the Google Cloud Console, enable the Google Sheets API to authenticate the requests from your ServiceNow instance through an OAuth application.

    Remarque :
    OAuth enables you to grant access to your data and files to third parties without sharing usernames or passwords.
    Before you can do the integration, you must set up the OAuth application so that you can authenticate the requests from your ServiceNow instance. For more information on how to do the setup, see Set up the OAuth application on the Google Sheets API at https://console.developers.google.com/.

    Next, you register the Google Drive application in your ServiceNow instance to enable OAuth authorization for exporting your table records directly to Google Sheets.

    Then, you configure the connection and credential aliases to authenticate the integration between your ServiceNow instance and Google Drive.
    Remarque :
    Aliases help keep credentials separate from the integration logic, making it easier and safer to manage sensitive information.
    The connection and credentials record contains the information that the Google Sheets API needs to authenticate the requests from your ServiceNow instance. It includes the user credentials and connection type, which are required for your instance to communicate with Google Cloud.