Scrape SERP Headlines → Compare with Originals → Build Report
Automatically collect and compare how Google displays your headlines versus your actual page titles to build comprehensive reports for stakeholders.
Workflow Steps
Screaming Frog
Crawl website and extract all page titles
Use Screaming Frog SEO Spider to crawl your website and export a complete list of all page titles, URLs, and meta descriptions. Filter to focus on your most important content pages.
SERPApi
Fetch Google search results for target pages
Use SERPApi to programmatically search Google for your target pages using relevant keywords. Extract the actual headlines as they appear in search results, not just the page titles.
Google Sheets
Create comparison analysis with formulas
Import both datasets into Google Sheets. Use formulas to compare original titles with displayed headlines, flag discrepancies, and calculate percentage of pages affected by AI rewrites.
Google Apps Script
Automate weekly reporting and alerts
Set up a Google Apps Script to run this comparison weekly, automatically updating the spreadsheet and sending email alerts when new discrepancies are detected or when the percentage of rewritten headlines changes significantly.
Workflow Flow
Step 1
Screaming Frog
Crawl website and extract all page titles
Step 2
SERPApi
Fetch Google search results for target pages
Step 3
Google Sheets
Create comparison analysis with formulas
Step 4
Google Apps Script
Automate weekly reporting and alerts
Why This Works
Provides scalable, automated monitoring that would be impossible to do manually, giving teams hard data about the scope and impact of Google's AI headline changes.
Best For
SEO agencies and large content teams need systematic tracking of headline changes across hundreds or thousands of pages
Explore More Recipes by Tool
Comments
No comments yet. Be the first to share your thoughts!