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
• Part 1: Get Your Sendinblue API Key
• Part 2: Pull Sendinblue API Data into Sheets
• Part 3: Handle Pagination
• Part 4: API Documentation

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:
   • Application: Custom
   • Method: GET
   • Request URL: https://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
  
  

Part 4: API Documentation

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