Quickstart

1. Install the add-on from Google Workspace Marketplace:
   Install ActiveData →
2. In Google Sheets: Extensions → ActiveData → Launch.
3. In ActiveCampaign (AC): Settings → Developer → copy your API URL and API Key.
   Paste into ActiveData’s connection screen and click Connect.
4. Select the **campaigns/lists** and **fields/metrics** you want (e.g., sends, opens, clicks, revenue).
5. Choose a destination Sheet and click **Run Sync** to test. Confirm columns populate.
6. Optional: enable **Schedule** (Hourly / Daily / Weekly). You can pause or delete at any time.

Tip: Create a dedicated read-only API key in ActiveCampaign for extra safety.

Permissions & Scopes

• https://www.googleapis.com/auth/spreadsheets — write metrics to the Sheet(s) you select.
• script.container.ui — render sidebar and menus inside Sheets.

ActiveCampaign: API Key or Personal Access Token with read-only access to reporting endpoints we use. We never write to AC.

We don’t store your Sheet contents or full AC payloads—only configuration and minimal job metadata to run the service.

Troubleshooting

• 401/403 from ActiveCampaign: Ensure the API URL and Key belong to the same AC account; confirm the key has read access. If rotating keys, update ActiveData.
• No columns created / no data: Confirm you selected a writable Sheet and have edit access. Try a small date range first.
• Rate limits: Large accounts can hit AC limits. Reduce frequency, narrow the scope, or schedule during off-hours. ActiveData backs off and retries automatically.
• Time zone mismatches: Check your Sheet’s timezone (File → Settings) and any date filters in the add-on.
• Scheduled job didn’t run: Ensure the schedule is enabled, credentials are valid, and your billing is active.

Billing & Licensing (Paystack)

• Plans: Monthly (R199) or Annual (R1,990, ~2 months free). Same features; Annual is best value.
• Checkout: Pay securely via Paystack. We never store card data.
• Manage subscription: Use your Paystack customer portal (open portal) to update card details, download invoices, or cancel.
• Licensing: Access is tied to your Google account email used at checkout.
• Invoices/receipts: Sent by Paystack to your billing email.
• Refunds: As outlined in our Terms (case-by-case unless required by law).

Data & Privacy

We store configuration (AC API URL & token, selected fields, schedules, destination Sheet) and operational metadata (job status, error codes). Tokens are encrypted and loaded only for the duration of a sync. See our Privacy Policy and Security for retention, deletion, and sub-processors.

Support

Email support@yourdomain.com. Include:

• Screenshot of the error (and any error code)
• Link to the affected Google Sheet (optional)
• Approximate time you ran the sync

Typical response time: 24–48 hours.