Hello Constant Contact Community,
Last year, I created an add-on called API Connector for Sheets that pulls data from Constant Contact and other platforms to Google Sheets. There are now nearly 100K users, many of whom use it for Constant Contact, so I created a step-by-step tutorial for how to use API Connector with the Constant Contact API: https://mixedanalytics.com/knowledge-base/import-constant-contact-data-to-google-sheets/
The tutorial walks through how to register an application, get an access token, create an API request URL, and pull data into Google Sheets.
Creator, API Connector