API Connector Documentation

Print

Import UPS Data to Google Sheets

Last Updated On
byAna
< Knowledge Base

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.

Contents

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 https://developer.ups.com/api/reference/oauth/client-credentials and click Get Started. You'll be prompted to log in or sign up if you haven't already.
    ups-getstarted
  2. Once you're logged in to the developer dashboard, click My Apps (or navigate directly to https://developer.ups.com/apps)
  3. Click Add Apps
    ups-addapps
  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.
    ups-appscenarios
  5. Fill in your contact details
    ups-contact
  6. Choose APIs to add to your application.
    ups-editapp
  7. Save the application, and you should now see your client ID and secret.
    ups-credentials

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 Type: Client Credentials
    • Name: Custom UPS
    • Token URL: https://onlinetools.ups.com/security/v1/oauth/token
    • Client ID: provided by UPS
    • Client Secret: provided 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: https://onlinetools.ups.com/api/track/v1/details/tracking_id
  • OAuth: Custom UPS
  • Headers:
    • transId:transId
    • transactionSrc:testing

Part 4: API Documentation

Official Tracking API documentation: https://developer.ups.com/api/reference#tag/Tracking_other

Leave a Comment

Jump To