Free PPC

Toolkit

What this tool does

CRO Sally audits a landing page from inside a Google Sheet and produces a four-tab report: a Dashboard with the bottom-line verdict, a Findings tab with conversion killers and copy opportunities, a Scenarios tab with three AI-generated visitor reactions (Decision Maker, Researcher, Skeptic), and an Actions tab with checkbox-tracked fixes ranked by priority. It separates objective performance data from AI-generated hypotheticals so you know which insights to trust at face value and which to validate with real user data.

How it works

The script runs as a Google Apps Script bound to a Google Sheet. When you trigger an audit, it captures desktop (1440px) and mobile (390px) screenshots of the target URL via a screenshot provider (Thum.io by default, no signup), then pulls real Core Web Vitals, performance, and accessibility scores from the Google PageSpeed Insights API. The screenshots and page context are sent to your chosen vision-capable LLM, OpenAI (GPT-4o, GPT-4o Mini, GPT-4 Turbo), Google Gemini (2.5 Pro, 2.5 Flash, 2.0 Flash), or Anthropic Claude (Sonnet 4.5, Opus 4.5, 3.5 Haiku), which generates the visitor scenarios, copy rewrites, and itemised findings. Results are written into formatted tabs in the same sheet.

What you’ll need

• A Google account with access to Google Sheets and Apps Script
• A new or existing Google Sheet to host the script
• An API key for at least one AI provider, OpenAI (sk-), Google Gemini (AIza), or Anthropic Claude (sk-ant-)
• A target landing page URL to audit
• Optional: a screenshot provider key (Thum.io is the zero-signup default; ScreenshotOne or ApiFlash work if you want a specific provider)

API costs are typically $0.03–$0.35 per audit depending on provider and model.

How to install

1. Go to script.google.com and create a new Apps Script project.
2. Copy the entire contents of Code.gs from the CRO Sally source into the script editor and save the project.
3. Bind the script to a Google Sheet, either create the project from inside a Sheet via Extensions → Apps Script, or attach the existing standalone script to a Sheet.
4. Get an API key from your chosen provider:
   • OpenAI: platform.openai.com/api-keys
   • Google Gemini: aistudio.google.com/apikey
   • Anthropic: console.anthropic.com/settings/keys
5. Open the bound Google Sheet and refresh the page. A Landing Page Analyzer menu appears in the toolbar.

How to use

1. Click Landing Page Analyzer → Setup to open the configuration sidebar.
2. Select your AI provider and model, then paste in the matching API key.
3. Enter the URL of the landing page you want to audit.
4. Click Test API to confirm the key works before spending tokens.
5. Click Save & Run. The script captures screenshots, pulls PageSpeed metrics, runs the AI analysis, and writes the Dashboard, Findings, Scenarios, and Actions tabs into your Sheet. Review the Dashboard first for the bottom line, then work the Quick Wins in the Actions tab.

The Apps Script (Code.gs)

The script is too large to inline here. Open the source file, copy it all, then paste into the Apps Script editor.

Open Code.gs (raw source) →

In the Apps Script editor, use Cmd/Ctrl + A to select everything, Cmd/Ctrl + V to paste, then save the project. Save the project, reload your Google Sheet, and the CRO Sally menu will appear in the toolbar.