---
sourceDocument: Yokohama ServiceNow AI Platform Administration
sourceDocumentLink: https://www.servicenow.com/docs/r/yokohama/platform-administration

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama ServiceNow AI Platform Administration

ft:clusterId :

    - platadm

bundleId :

    - platadm

workflow :

    - Platform


---

# Exporting your table records to Google Sheets

# Exporting your table records to Google Sheets {#ariaid-title1}

* Release version: Yokohama
* 
* Updated May 5, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

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.  
Note:  
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](https://www.servicenow.com/docs/LYTid9XxlnsOXQkEuXv9Ig "Set up the OAuth application on the Google Sheets API so that you can authenticate requests from your ServiceNow instance to access Google Sheets.") 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.  
Note:  
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.
* **[Set up the OAuth application on the Google Sheets API](https://www.servicenow.com/docs/LYTid9XxlnsOXQkEuXv9Ig)**   
  Set up the OAuth application on the Google Sheets API so that you can authenticate requests from your ServiceNow instance to access Google Sheets.
* **[Configure ServiceNow connection and credential aliases for Google sheets](https://www.servicenow.com/docs/wQR_hfT3IPfpja3JoceSDw)**   
  Configure connection and credential aliases to authenticate an integration between your ServiceNow instance and Google Drive.
* **[Create an application registry for Google Sheets on a ServiceNow instance](https://www.servicenow.com/docs/LLhdnyqfxI~6FY3dYhkqVA)**   
  Register the Google Drive application in your ServiceNow instance to enable OAuth authorization for exporting table records directly to Google Sheets.

**Related concepts**   

* [Exporting and importing data via XML](https://www.servicenow.com/docs/UihJMJZvzLgPisbqOYq3kQ "Migrate data from one instance to another by exporting and importing XML files.")
* [Exporting currency fields to Excel](https://www.servicenow.com/docs/ezER0sHyNwWYIPPiX39fGQ "Exporting currency fields to Excel applies Account formatting and can be configured to convert all values to US dollars or to export values in the user's session currency.")
* [Enable export debug logging](https://www.servicenow.com/docs/JdOezxY76O_GXv7HdGO7Vw "When the property glide.export.debug is true, the instance logs export processing including database query time and the time taken to write data to the file.")
* [Data export reference](https://www.servicenow.com/docs/N8iJBejRHNHfWjavaOF_Yw "Reference topics provide details on exporting data.")  
**Related tasks**   

* [Export data from a record](https://www.servicenow.com/docs/wzONObNrCvtAaoJhKFyKLw "Export a record to PDF or XML.")
* [Export data from a list](https://www.servicenow.com/docs/JmEccrnibXN3LNA34qyk7Q "Export a list of records to a variety of file formats.")
* [Export directly from a URL](https://www.servicenow.com/docs/MXrZPpk61ZvRp2va6tT4fg "Dynamically export data from a script or web service by building a URL query.")