Triquetra Health

Creator Portal Setup

Configure your environment variables to connect the portal to Meta and Google Sheets.

Required Environment Variables

META_ACCESS_TOKEN

Long-lived Meta Marketing API access token

META_AD_ACCOUNT_ID

Ad Account ID in format act_XXXXXXXXXX

GOOGLE_SHEET_ID

ID from your Google Sheet URL

GOOGLE_API_KEY

Google Cloud API key with Sheets API enabled

Add these to your .env.local file locally, or to Vercel Environment Variables when deploying.

Getting Your Meta Access Token

  1. 1Go to developers.facebook.com and create a Business app
  2. 2Add the Marketing API product to your app
  3. 3Go to Tools → Graph API Explorer
  4. 4Select your app and request permissions: ads_read, ads_management, business_management
  5. 5Click "Generate Access Token" and copy it
  6. 6To make it long-lived: use the Access Token Debugger → Extend Token

Google Sheet Structure

Create a sheet named Sheet1 with these exact column headers:

creator_slugdisplay_namead_idsactive
adrianna-sAdrianna123,456true

Make the sheet public (Anyone with the link → Viewer) so the API key can read it.

Test Connection

Verify your Meta API token is working correctly.

View a Creator Dashboard

Once configured, visit a creator dashboard using their slug:

/dashboard?creator=firstname-lastname