In this guide, we’ll walk through how to import RD Station data directly into Google Sheets, using the API Connector add-on for Sheets. We'll set up a custom OAuth connection and connect to their API.
You'll be prompted to fill out additional app details, including the callback URL provided in this article. Click Save and advance.
You'll now see your client ID and secret. Copy these down, we'll need them shortly.
Part 2: Connect RD Station to API Connector
Open up Google Sheets and click Extensions > API Connector > Manage Connections
Scroll to the bottom of the sidebar and click Add Custom OAuth
Fill in the Custom OAuth modal as follows:
Name: Custom RD Station
Authorization Base URL: https://api.rd.services/auth/dialog
Token URL: https://api.rd.services/auth/token
Client ID: provided by RD Station
Client Secret: provided by RD Station
Click Save
Click Manage Connections to return to the list of connections
Scroll down until you find your new custom connection. Click Connect
You'll be prompted to give access to the new app you created above. Click Connect
You'll be returned to your sheet and can verify that the new connection is now active.
Part 3: Get RD Station Data in Sheets
To create a request, include your full request URL in the request URL field, and select your custom RD Station connection from the dropdown OAuth menu.
You can see the full list of available endpoint and parameters in the API documentation. For example, to get your tracking code, run the following request: