Using Apps Script and Active Campaign API, pull data into Google sheets

Steps 1: Create a Google Sheet with the following tabs

• Campaigns
• Automations
• Main_Function

2: Click on Tools > Apps Script

3: Rename and add the following .gs files

• Campaigns.gs
• Automations.gs
• Main_Function.gs

4: Copy the code from the .gs files into the relevant directory

5: Head over to Active Campaign, Login and make sure you have access to the Admin account

• Go to Settings > Developer
• Copy the URL and KEY values and replace the values in Main_Function.gs

• Make sure you copy the URL into the URLgi variable, but the URL variable requires the /api/3 after it.

var URL = 'https://XXX.api-us1.com/api/3'; //update this value

var API = 'XXXX'; //update this value

var URLgi = 'https://XXX.api-us1.com'; //update this value