Set up Authorization code OAuth flow for Google Sheets - Amazon Glue
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Set up Authorization code OAuth flow for Google Sheets

Prerequisites

  • A Google account where you can sign in to use the Google Sheets app. In your Google account, Google Sheets contains the data that you want to transfer.

  • A Google Cloud Platform account and a Google Cloud project. See Create Google Cloud Project for more details.

To set up your Google account and get OAuth 2.0 credentials:

  1. Once the Google Cloud project is setup, enable the Google Sheets API and Google Drive APIs in the project. For the steps to enable them, see Enable and disable APIs in the API Console Help for Google Cloud Platform.

  2. Next, configure an OAuth consent screen for external users. For more information about the OAuth consent screen, see Setting up your OAuth consent screen in the Google Cloud Platform Console Help.

  3. In the OAuth consent screen, add the following scopes:

    For more information about these scopes, see OAuth 2.0 Scopes for Google APIs in the Google Identity documentation.

  4. Generate OAuth 2.0 client ID and secret. For the steps to create this client ID, see Setting up OAuth 2.0 in the Google Cloud Platform Console Help.

    The OAuth 2.0 client ID must have one or more authorized redirect URLs.

    Redirect URLs have the following format:

    • https://<aws-region>.console.aws.amazon.com/gluestudio/oauth

  5. Note the client ID and client secret from the settings for your OAuth 2.0 client ID.