Author: Andrew Charlton

Access our latest free scripts, templates and tools. Built by SEOs for SEOs.

Bulk check indexing and coverage reports in Google Sheets

Use the Google Search Console URL Inspection API in sheets to bulk check indexing and coverage reports....

Get template

Get Google Search trends every day in Sheets (no-code)

Get daily trending topics from Google Trends into Google Sheets every day without using code 🚀 Check...

Get template

‘Award-winning’ digital PR headlines with GPT-3

Use GPT-3 to input a website category and generate ‘award winning’ digital PR headlines automatically (this one’s...

Get template

Automatically generate title tags & meta descriptions with GPT-3

Use GPT-3 to input a keyword and automatically generate a page title and meta description 🚀 🤖...

Get template

Get HARO opportunities directly in Google Sheets

Automatically get relevant Help a Reporter Out (HARO) requests from Gmail directly into Google Sheets, filtered by...

Get template

Check how Google is changing the appearance of your title tags

Check your Google page titles for all of your search queries, across different countries and languages. 600...

Get template

Check whether your URLs are Indexed

Get the index status of a list of URLs. 600 requests per month, for free. 🚀 Check...

Get template

Find a valid email address for any person

Find an email address for any person and validate that it exists. Minimum of 25 requests per...

Get template

Get Old Webpages for any Domain

Get saved webpages for a domain from Wayback Machine in Google Sheets. 🚀 Check out the GIF...

Get template

SEO Forecasting in Google Sheets

This is part of my SEO forecasting template from my course, Forecasting for SEO, which includes a...

Get template