Google Sheets Setup

Connect your Google Ads data exports to power the Adalysis dashboard with live data.

Connection Status

Click 'Check Status' to test connections

How to Connect Your Sheets

Export from Google Ads

In Google Ads, go to Campaigns, Search Terms, or Keywords report. Click Download → Google Sheets to export the data.

Note the Sheet IDs

The sheet ID is in the URL: docs.google.com/spreadsheets/d/[SHEET_ID]/edit. Copy the IDs for each of your three sheets.

Publish Each Sheet as CSV

In each Google Sheet: File → Share → Publish to web → choose "Entire Document" and "CSV" format, then click Publish.

Set Environment Variables (Optional)

Create a .env.local file with your custom sheet IDs. The defaults are pre-configured for Skylar's accounts.

Verify Connection

Click "Check Status" above. Green badges indicate the sheet is accessible. The dashboard will automatically use live data.

Environment Variables

Create a .env.local file in the project root with your Sheet IDs:

# .env.local
SHEETS_CAMPAIGNS_ID=your_campaigns_sheet_id
SHEETS_SEARCH_TERMS_ID=your_search_terms_sheet_id
SHEETS_KEYWORDS_ID=your_keywords_sheet_id

If these are not set, the app falls back to the default Sheet IDs which are already configured. Mock data is used if the sheets are not published or accessible.

Expected Sheet Columns

The importer auto-maps Google Ads standard column names. Standard Google Ads CSV exports work out of the box.

Campaigns Sheet

CampaignCampaign StatusBudgetCostClicksImpressionsConversionsConv. valueCTRSearch Impr. shareBid Strategy TypeTarget CPA

Search Terms Sheet

Search termCampaignAd groupMatch typeCostClicksImpressionsConversions

Keywords Sheet

KeywordCampaignAd groupMatch typeStatusCostClicksImpressionsConversionsQuality ScoreAvg. CPCMax CPC