Home / Courses
Free course · English

Build a Local SEO Audit Dashboard with Google Sheets & Python

Create a live SEO audit tool in a week using Sheets and Python

9 lessons about 6 hours beginner
Build a Local SEO Audit Dashboard with Google Sheets & Python

This beginner‑friendly course is for Indian students and career switchers who want a practical, job‑ready skill in local SEO and automation. You’ll learn to pull Google My Business and Google Search data, clean it in Python, and visualise key metrics in a Google Sheet dashboard.

By the end of the course you will have built a fully functional SEO audit dashboard that updates automatically, and you’ll understand how to extend it for other clients.

You’ll be able to write Python scripts that call Google APIs, transform data with pandas, and publish results to Google Sheets – a combination that many small agencies and startups look for.

What you will work through

1 Course Overview & Setting Up the Environment CodeWithHarry · 22 min 2 Google Cloud Console: Creating API Keys Learn With Ravindra · 9 min 3 Fetching Local Search Results with Python NeuralNine · 17 min 4 Hands‑On Project 1: Build the Search Scraper Corey Schafer · 21 min 5 Introducing pandas for Data Cleaning Keith Galli · 60 min 6 Calculating Local SEO KPIs Steven Bradburn · 13 min 7 Google Sheets API: Writing Data from Python Tech With Tim · 32 min 8 Hands‑On Project 2: Build the Live Dashboard Endless Knowledge · 24 min 9 Automation & Next Steps Corey Schafer · 22 min
Final project Local SEO Audit Dashboard Unlocks after all 9 lessons 0 of 9 lessons passed Locked
Final project

Local SEO Audit Dashboard

Submit a public GitHub repo Checked by a reviewer Unlimited attempts

Build a live dashboard that:

  • Retrieves the top 10 local search results for a given keyword using the Google Custom Search API.
  • Pulls Google My Business metrics (reviews, rating) for a chosen business.
  • Calculates key SEO KPIs (NAP consistency score, citation count, average rating).
  • Writes all data to a Google Sheet with conditional formatting and charts.
  • Updates automatically when the script is re‑run.

Submit: a public GitHub repo link containing the Python code, a screenshot of the Google Sheet dashboard, and a short README.

Reviewer checklist:

  • Correct use of Google Custom Search and My Business APIs.
  • Data cleaning and KPI calculations are accurate.
  • Google Sheet receives data via the Sheets API.
  • Dashboard includes at least two charts and conditional formatting.
  • Code is well‑commented and includes a requirements.txt.
  • README explains setup and usage clearly.
Sign in to take partYour progress and project are saved to your account.
Sign in
The teaching videos are made by independent creators and play from YouTube, with the creator credited on every lesson. Nexgino builds the path, the notes, the project and the certificate.
9 lessons · free Start free