Ads Data Sheets Add-on

Cross‑platform ad performance in Google Sheets

Connect Google Ads, Meta Ads, and TikTok Ads. Preview, insert, and refresh unified metrics directly in Sheets.

Learn more
Fast setup Unified schema Export‑ready tables

Product vision & value

Aggregate cross‑platform ad performance into Google Sheets where marketers already work. Reliable refreshes and export‑ready dashboards.

  • Unified metrics: impressions, clicks, spend, conversions, CTR, CPC, CPA, ROAS
  • Dimensions: date, account, campaign, ad set/ad group, ad
  • Granularity: daily and campaign‑level (MVP)

Target users

  • Agencies and in‑house marketers managing multiple ad platforms
  • Initial geo: Japan; language: JA + EN (TBD)

MVP connectors

  • Google Ads
  • Meta
  • TikTok

Sidebar workflow in Sheets

  1. Connect accounts via OAuth; accounts appear automatically
  2. Select platform and account
  3. Choose scope: Campaigns / Ad sets (Ad groups) / Ads
  4. Filter entities; set date range and daily granularity
  5. Pick metrics with sensible defaults
  6. Preview rows; warnings for large pulls
  7. Insert/refresh with overwrite or append; remembers last selections

Licensing & scheduling

  • Stripe Checkout with monthly/annual plans and free trial
  • License verified on each run (cache for speed)
  • On‑demand refresh; optional scheduled triggers

Templates

  • Summary by platform
  • Daily performance
  • Campaign performance

Architecture (MVP)

  • Apps Script Editor Add‑on with Sidebar UI
  • Direct API calls (UrlFetchApp) to Google Ads, Meta, TikTok
  • OAuth tokens stored securely (encrypted)
  • Sheets writes with progressive batching and checkpoints

Migration path

Move API calls and token storage to Cloud Run backend when quotas/timeouts are hit. Keep the same sidebar UI; switch endpoints behind the scenes.

Interested? Let’s talk.

We’re shaping the MVP now. Reach out to discuss access and launch.