Import Omnisend Data to Google Sheets

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

We'll first get an API key from Omnisend, and then set up a request to pull in data to your spreadsheet.

Before You Begin

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

Part 1: Get Your Omnisend API Key

  1. Sign in to Omnisend and navigate to the API key section by clicking or follw the steps in a & b below.

    a. Navigate to the Store Settings by clicking on the dropdown at the top right corner, then click on the Store Settings option that appears in the drop down.

    Navigate to Omnisend store settings

    b. Navigate to the API keys section by clicking on the API keys option from the menu on the left pane of the Store settings page.
    Navigate to the Omnisend API keys page
  2. In the API keys page click on the Create API key button.
    omnisend create api key
  3. On the interface that opens up, type in a name for your application and click on the Create API key button at the bottom right corner of the page
    Omnisend Application name
  4. Copy and keep seurely the API key that is generated.
    omisend copy and save api key
  5. Once you have your API token, you're all set! You can now connect to Omnisend's API

Part 2: Pull Omnisend API Data into Sheets

For this example, we'll get a list of Orders

  1. Open up Google Sheets and click Extensions > API Connector > Open > Create request.
  2. In the request form enter the following:
    • ApplicationCustom
    • MethodGET
    • Request URL
    • Headers
      • X-API-KEY: your_api_key
      • accept: application/json
        omnisend configure api request
  3. Create a new tab and click Set current to use that tab as your data destination.
  4. Name your request and click Run. A moment later you’ll see Omnisend order details populate your sheet.
    omnisend data response

Part 3: More Example API URLS


Part 5: API Documentation

Official API documentation

Leave a Comment

Jump To