Start with OAuth
Productivity & Collaboration

Google Sheets OAuth Integration

Connect Google Sheets to your application without building and maintaining the OAuth flow.

Google Sheets is Google's online spreadsheet app. Each user connects their own Google Sheets account through your OAuth app. Pathfix manages the authorization flow, stores and refreshes their tokens, and authenticates the requests your application makes to the Google Sheets API. What your integration does with that access is up to your code.

Start building with Pathfix Read the setup guide

How Pathfix helps

  • 01

    OAuth authorization

    Pathfix runs the authorization flow with your Google Sheets OAuth app, so users approve access on Google’s own consent screen.

  • 02

    Token management

    Each user’s access and refresh tokens are stored by Pathfix rather than in your application.

  • 03

    Token refresh

    Where Google Sheets issues refresh tokens, Pathfix refreshes them as they expire, so connections keep working after the first authorization.

  • 04

    Authenticated API passthrough

    Your application sends Google Sheets API requests through Pathfix, which adds the connected user’s credentials before passing them on to Google Sheets.

You own the Google Sheets OAuth application and its credentials, and your code implements the API logic.

Passthrough endpoint for Google SheetsPOST https://labs.pathfix.com/oauth/method/googlesheets/call

How to get started

  1. 1

    Register your app with Google

    Create an app in Google’s developer settings to get a Client ID and Client Secret. When asked for a redirect URI, enter https://labs.pathfix.com/integrate/command.

  2. 2

    Add the credentials in Pathfix

    In your Pathfix account, add an application, select Google Sheets from the providers and enter the Client ID and Client Secret.

  3. 3

    Choose your scopes

    Add only the scopes your integration needs. Google’s developer documentation lists what each scope allows.

  4. 4

    Test the connection

    Use Test Connection to connect an account in the API Playground and run a sample call.

  5. 5

    Let your users authorize

    Add the connect step to your app. Each user signs in to Google Sheets and approves the scopes you requested.

  6. 6

    Call the Google Sheets API

    Send requests through the Pathfix passthrough API using the provider reference googlesheets.

Documentation

More Productivity & Collaboration integrations

Your Google Sheets OAuth app. Your users.

Start building with Pathfix Browse all integrations