Import Pinterest Ads Data to Google Sheets

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

Contents

• Before You Begin
• Part 1: Connect to the Pinterest Ads API
• Part 2: Get your Pinterest Ads Account ID
• Part 3: Fetch Data from Pinterest Ads into Sheets
• Part 4: Create a Custom Request
• Part 5: API Documentation

Before You Begin

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

Part 1: Connect to the Pinterest Ads API

The easiest way to get started with the Pinterest Ads API is through API Connector’s built-in integration.

1. Select Pinterest Ads from the drop-down listof applications
   
2. Under Authorization, click Connect to Pinterest Ads
   
3. You’ll be sent to Pinterest and prompted to authorize the connection.
   
4. You’ll then be returned to your Google Sheet, and can verify that your Pinterest Ads connection is now active.

Part 2: Get your Pinterest Ads Account ID

We’ll need your Pinterest account ID for subsequent requests, so let’s get it now. To get your account ID, login to your Pinterest Ads account and grab it from the main menu.

Alternatively, you can get your account ID via the API, using the /ad_accounts endpoint.

Part 3: Fetch Data from Pinterest Ads into Sheets

Now that we’re connected, let’s pull some data into Sheets.

1. Select the /ad_accounts/{ad_account_id}/analytics endpoint to retrieve account-level ad analytics
   
2. Fill in all required parameters: ad_account_id, start_date, end_date, columns, and granularity.
   
3. Choose a destination sheet, name your request, and hit Run. A moment later you’ll see the response data in your sheet.
   
4. In some cases, Pinterest changes the order in which they send back fields, which results in columns switching around. To address this, open API Connector’s visual field editor by clicking Edit Fields.
   
5. Here you can map fields to specific columns so that they stay “locked” in place even when Pinterest sends back the data in a different order.
   

Part 4: Create a Custom Request

Alternatively, you can run your own custom requests instead of using API Connector’s pre-built integration. To create a custom request, add your complete URL into the Request URL field, and choose Pinterest Ads from the OAuth menu.

To convert from a preset request to a custom API URL, tick the Add request URL box before running your preset request (under Output options). This will print out your complete API URL, which you can then copy/paste into the request URL field.

Part 5: API Documentation

Official API documentation: https://developers.pinterest.com/docs/api/v5/#tag/ad_accounts