Import UPS Data to Google Sheets

In this guide, we’ll walk through how to import UPS shipping data directly into Google Sheets, using the API Connector add-on for Sheets.


Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Part 1: Get Your UPS OAuth Credentials

  1. Navigate to and click Get Started. You'll be prompted to log in or sign up if you haven't already.
  2. Once you're logged in to the developer dashboard, click My Apps (or navigate directly to
  3. Click Add Apps
  4. You'll be prompted to select your use case and shipper account. You can link to an existing account or create a new one.
  5. Fill in your contact details
  6. Choose APIs to add to your application.
  7. Save the application, and you should now see your client ID and secret.

Part 2: Connect UPS to API Connector

  1. Open up Google Sheets and click Extensions > API Connector > Manage Connections
  2. Scroll to the bottom of the sidebar and click Add Custom OAuth
  3. Fill in the Custom OAuth modal as follows:
    • OAuth Grant TypeClient Credentials
    • NameCustom UPS
    • Token URL
    • Client IDprovided by UPS
    • Client Secretprovided by UPS
  4. Click Save

Part 3: Get UPS Data in Sheets

You can create a request using any of the endpoints and parameters described in UPS's documentation. Here's an example to their tracking API. Substitute in your own tracking number (if you need more than 1, you can cycle through a list of request URLs using a multi-query request).

  • Application: Custom
  • Method: GET
  • Request URL:
  • OAuth: Custom UPS
  • Headers:
    • transId:transId
    • transactionSrc:testing

Part 4: API Documentation

Official Tracking API documentation:

Leave a Comment

Jump To