Search API Connector Documentation

Print

Import Sendinblue Data to Google Sheets

In this guide, we’ll walk through how to pull data from the Sendinblue API 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 Sendinblue API Key

  1. Log in to Sendinblue and click SMTP&API in the drop-down account menu
  2. Your API key will be listed on the page. Keep it handy as you'll need it in a moment. That's it, you're now ready to use the Sendinblue API.

Part 2: Pull Sendinblue API Data into Sheets

For this example, we'll get a list of contacts. Enter in your own API key where it says your_api_key.

  1. Open up Google Sheets and click Extensions > API Connector > Open > Create request.
  2. In the request form enter the following:
    • ApplicationCustom
    • MethodGET
    • Request URLhttps://api.sendinblue.com/v3/contacts?limit=1000
    • Headers
      • api-key: your_api_key
      • accept: application/json
  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 data populate your sheet.

Part 3: Handle Pagination

By default, Sendinblue will return 50 records at a time. To get more, set the limit parameter to 1000.

To fetch more than 1000 records, use pagination handling (paid feature):

  • Pagination type: offset-limit
  • Offset parameter: offset
  • Limit parameter: limit
  • Limit value: 1000
  • Run until: choose when to stop fetching data
    sendinblue-pagination

Part 4: API Documentation

Official API documentation: https://developers.sendinblue.com/reference/

Leave a Comment

Jump To...