Jun 23, 2026
Build a real-time SEO dashboard in Google Sheets (no plugins)
A step-by-step guide to tracking your keyword rankings and competitor movements using free tools and a spreadsheet.
You don't need expensive software to track rankings. A Google Sheet with IMPORTHTML and a few formulas can do 80% of the job for free.
I built a dashboard that pulls my top 20 keyword positions every morning. It takes 15 minutes to set up and zero maintenance. Here's how: use IMPORTHTML to scrape SERP snippets from Google (just your own URLs), then conditional formatting to flag drops. Add a second sheet for competitor tracking with manual monthly updates.
Craft's SEO audit template complements this by giving you a structured CSV to import. The combo replaced my $99/month tool. For a solo founder, that's a win.