Generate and rank landing page headlines with GPT-4o-mini, Google Sheets and Gmail

Description Submit your landing page URL, current headline, conversion goal, and target audience using a simple form and the workflow does the rest. It scrapes your page, cleans the content, and sends everything to GPT-4o-mini which generates 10 headline variations — each using a different psychological framework such as benefit-led, pain-led, curiosity, urgency, and social proof. Every headline is scored on four dimensions and ranked by test priority. All 10 are logged to Google Sheets and a Gmail report groups them by priority with specific testing tips, ready to hand straight to your developer. Built for marketers, growth teams, and conversion specialists who want data-driven headline options without spending hours writing them manually. --- What This Workflow Does - Scrapes the landing page for real context — Fetches the actual page content so GPT generates headlines grounded in your real copy and offer — not generic variations - Generates 10 headlines across 10 frameworks — Each variation uses a different psychological approach: benefit-led, pain-led, curiosity, social proof, specificity, urgency, before and after, question, bold claim, and FOMO - Scores every headline on four dimensions — Clarity, emotional pull, specificity, and SEO fit are each rated 1–10 and averaged into an overall score - Assigns test priority automatically — The two strongest headlines are marked "Test First", the next three "Test Second", the next three "Test Third", and the remaining two "Lower Priority" - Logs all 10 headlines to Google Sheets — Each headline gets its own row with framework, copy, all four scores, priority label, and submission details - Sends a Gmail report grouped by priority — The email organises all 10 headlines into priority sections with a testing tip per headline and step-by-step instructions for running the A/B test --- Setup Requirements Tools Needed - n8n instance (self-hosted or cloud) - OpenAI account with GPT-4o-mini API access - Google Sheets (one sheet with a tab named Headline Tests) - Gmail account (the account you want to receive the report) Credentials Required - OpenAI API key - Google Sheets OAuth2 - Gmail OAuth2 Estimated Setup Time: 10–15 minutes --- Step-by-Step Setup 1. Import the workflow — Open n8n → Workflows → Import from JSON → paste the workflow JSON → click Import 2. Fill in Config Values — Open node 2. Set — Config Values → replace all three placeholders: | Field | What to enter | |---|---| | PASTEYOURGOOGLESHEETIDHERE | The ID from your Google Sheet URL (the string between /d/ and /edit) | | PASTEYOUREMAILHERE | The email address where the headline report should be sent | | PASTEYOURNAMEHERE | Your name for the email greeting and sign-off | 3. Connect OpenAI — Open node 6. OpenAI — GPT-4o-mini Model → click the credential dropdown → add your OpenAI API key → test the connection 4. Create your Google Sheet tab — Open your Google Sheet → add a tab named exactly Headline Tests → add these 13 column headers in row 1: Date, Page URL, Page Name, Headline , Framework, Headline Copy, Clarity Score, Emotional Pull, Specificity, SEO Fit, Overall Score, Test Priority, Submitted By 5. Connect Google Sheets — Open node 9. Google Sheets — Log Headline Tests → click the credential dropdown → add Google Sheets OAuth2 → sign in with your Google account → authorize access 6. Connect Gmail — Open node 12. Gmail — Send Headline Report → click the credential dropdown → add Gmail OAuth2 → sign in with the Gmail account that matches your email address → authorize access 7. Activate the workflow — Toggle the workflow to Active → copy the Form URL from node 1. Form — Landing Page Headline Generator → open it in a browser to submit your first page --- How It Works (Step by Step) Step 1 — Form: Landing Page Headline Generator You open the form URL in a browser and fill in six fields: the landing page URL, your current headline, the page name, the conversion goal (e.g. "Book a demo"), the target audience (e.g. "SaaS founde