AdPages Campaign Workbook for Google Sheets

Local-only Google Sheets template pack for agencies that need a practical campaign URL builder, landing-page QA tracker, and lead follow-up sheet before paid traffic goes live.

What It Does

• Generates import-ready CSV sheets for campaign setup, landing pages, ad groups, QA checks, and lead follow-up.
• Builds UTM-tagged final URLs from a local JSON plan.
• Includes a workbook build guide and formula notes for a public Google Sheets template.
• Keeps the free artifact useful without requiring Google API access, OAuth, add-ons, or hosted storage.

It does not call Google APIs, require OAuth, read a user's Google Drive, store lead data remotely, crawl landing pages, or send analytics events.

Folder

templates/google-sheets/adpages-campaign-workbook/
  bin/adpages-sheets-workbook.mjs
  docs/formulas.md
  examples/ad-groups.csv
  examples/campaigns.csv
  examples/landing-pages.csv
  examples/lead-follow-up.csv
  examples/qa-tracker.csv
  examples/sample-workbook-plan.json
  examples/settings.csv
  scripts/check.mjs
  scripts/smoke.mjs
  src/workbook.mjs
  templates/workbook-build-guide.md
  package.json
  PRIVACY.md
  README.md

Local Checks

From the repository root:

npm --prefix templates/google-sheets/adpages-campaign-workbook run check
npm --prefix templates/google-sheets/adpages-campaign-workbook run smoke

Generate the sample CSV bundle:

npm --prefix templates/google-sheets/adpages-campaign-workbook run generate:sample

Or call the CLI directly:

node templates/google-sheets/adpages-campaign-workbook/bin/adpages-sheets-workbook.mjs \
  --input templates/google-sheets/adpages-campaign-workbook/examples/sample-workbook-plan.json \
  --out-dir .tmp/google-sheets-campaign-workbook

Google Sheets Import Flow

1. Create a blank Google Sheet.
2. Import each CSV in examples/ as a separate tab:
   • settings.csv
   • campaigns.csv
   • landing-pages.csv
   • ad-groups.csv
   • qa-tracker.csv
   • lead-follow-up.csv
3. Freeze the header row on each tab.
4. Add filters to each tab.
5. Add data validation lists for status columns.
6. Add the formulas from docs/formulas.md after the CSV import is complete.
7. Duplicate the reviewed workbook as the public template copy.

Publishing Position

This can ship as a public Google Sheets template, Drive resource, Gumroad freebie, agency resource page, or GitHub template artifact. The backlink angle is strong because the workbook solves a repeated operational problem for agencies: proving campaign URLs, launch QA, and lead handoff before ad spend starts.

Later paid paths could include Google Ads import sheets, screenshot audits, call-tracking checks, client-ready report exports, automatic QA scoring, Sheets add-on sync, and agency setup packages.

Publish Blockers

• Final workbook must be imported into Google Sheets and visually reviewed.
• Public duplicate template URL, screenshots, support URL, privacy URL, and listing copy are not included.
• Data validation and formulas need to be applied in the final Sheet after CSV import.
• Real agency examples must be scrubbed before public release.
• Any future Google API, Apps Script, or add-on version needs separate OAuth, scope, and privacy review.

Publisher

Built by AdPages from A1 Local as a free, dependency-light resource for local-service marketers, web designers, and small business site owners.