Print

Import RD Station Data to Google Sheets

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.

Contents

Before You Begin

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

Part 1: Get your RD Station OAuth Credentials

  1. Log in to RD Station's App Store platform at https://appstore.rdstation.com/en/publisher
  2. On the main page, click I want to create an app
    rdstation-createapp
  3. Enter the app name and type and click Create App
    rdstation-appdetails
  4. You'll be prompted to fill out additional app details, including the callback URL provided in this article. Click Save and advance.
    rdstation-appdetails2
  5. You'll now see your client ID and secret. Copy these down, we'll need them shortly.
    rdstation-credentials

Part 2: Connect RD Station 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: Authorization Code
    • Name: Custom RD Station
    • Authorization Base URL: https://api.rd.services/auth/dialog
    • Token URL: https://api.rd.services/auth/token
    • Client IDprovided by RD Station
    • Client Secretprovided by RD Station
  4. Click Save
    rdstation-customoauth
  5. Click Manage Connections to return to the list of connections
  6. Scroll down until you find your new custom connection. Click Connect
    rdstation-connect
  7. You'll be prompted to give access to the new app you created above. Click Connect
    rdstation-approve

  8. 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:

  • Application: Custom
  • Method: GET
  • Request URL: https://api.rd.services/marketing/tracking_code
  • OAuth: Custom RD Station

Part 4: API Documentation

Official API documentation: https://developers.rdstation.com/reference/introducao-rdsm?lang=en&lng=en

Leave a Comment

Jump To