Google Sheets Export

Export the current Grid results directly into Google Sheets.

Google Sheets Export Setup

  Use these steps to allow the extention to export query results to Google Sheets using your own Google Cloud project.  

1. Create a Google Cloud project

1. Visit https://console.cloud.google.com/projectcreate.
2. Enter a project name (for example, AxialSqlToolsSheetsExport) and create the project.
3. Switch to the new project from the project picker.  

2. Enable the Google Sheets API

1. In the Cloud Console, open APIs & Services → Library.
2. Search for Google Sheets API and click Enable for your project.  

3. Configure OAuth consent (required even for testing)

1. Go to APIs & Services → OAuth consent screen.
2. Choose External user type and click Create.
3. Fill out the app information (app name, user support email, developer contact info) and save.
4. Under Scopes, the export flow only needs the default Google Sheets scope (.../auth/spreadsheets), which is automatically requested by the tool.
5. In Test users, click Add users and add the Google accounts that should be allowed to sign in while the app is unpublished.
6. Save and Publish to the Testing state (do not move to Production unless you intend to verify the app with Google).  

4. Create OAuth credentials

1. Open APIs & Services → Credentials and click Create credentials → OAuth client ID.
2. Choose Desktop app as the application type and provide a name.
3. Download the client configuration JSON.  

5. Configure the exntension settings

1. In the extension settings, populate Client ID and CLient Secret from the downloaded OAuth client JSON.
2. Click "Authorize Google Sheets", a browser window will prompt you to sign in. Use one of the test users you added earlier.
3. Done.