Importing Constant Contact Data
This guide will walk through how to pull data from the Constant Contact API and put it directly into Google Sheets.
Begin by acquiring an API key and personal access token from Constant Contact. Then you can set up a request using Phlorin’s built-in integration in Google Sheets.
Getting Started
Install the API solution add-on from Google Marketplace.
Begin by getting your Constant Contact API Key
To request data from Constant Contact you must first have an account with Mashery. After this you can obtain an API key.
1. If you don’t have one already, create a Mashery account: https://constantcontact.mashery.com/member/register
2. After you are logged in, you will register a new application. Go to: https://constantcontact.mashery.com/apps/register
For the registration form, give it a name (you may leave the other fields blank). In this example we used the name “Phlorin.”
Agree to terms of service and click Register Application.
3. Your API Key will now be shown, save this for later.
4. Next, you will need a personal access token. This will allow Phlorin authorization to pull data from Constant Contact.
Click on the API Tester tab and click Get Access Token.
5. From here you can log into your existing account with Constant Contact or create a new one.
6. After logging in, it will prompt you to “allow access” to your created application. Click Allow.
7. Here you will be presented with your personal access token. Copy this and you can start using Phlorin’s built-in functionality.
Pull Constant Contact data into Sheets
To get the most out of ConstantContact, use Phlorin to pull data seamlessly into Google Sheets.
1. In your desired Sheets document, open Phlorin and create a new request:
Extensions > Phlorin > Open > Create a request
2. In the Application dropdown select or search for ConstantContact.
3. From here we will need to select an endpoint, enter your API Key, and enter your access token.
4. Make sure your desired sheet is selected and click Run.
Creating Custom Request
With Phlorin and Constant Contact’s API documentation you can create URLs to run custom requests. Search their documentation for the desired request and adapt the URL to suit your needs.
With ConstantContact you can also use their built in API Tester to build a URL for you:
1. Start on https://constantcontact.mashery.com/io-docs
2. Make sure your API key is selected and your personal access token is entered.
3. Select the desired method and click Try It.
- This custom example uses the Get method:
- Copy the Requested URL and the Requested Headers:
- This custom example uses the Get method:
- Input as shown in the example and below:
- Using Phlorin, fill out the following fields:
- Application: Custom
- Method: GET
- Request URL: https://api.constantcontact.com/v2/account/info?api_key=API-KEY-HERE
- Headers:
- Key: Authorization
- Value: Bearer API-TOKEN-HERE
- Key: X-Originating-IP
- Value: YOUR-IP-ADDRESS-HERE
- Key: Authorization
Documentation
Constant Contact’s official API documentation: https://v2.developer.constantcontact.com/docs/developer-guides/api-documentation-index.html