Programmatic SEO for Local Service Businesses

#seo #automation #smallbusiness

Programmatic SEO for Local Service Businesses

Local service businesses live and die by search rankings. A sign shop in Boca Raton needs to show up when someone searches "custom signs boca raton". But creating landing pages for every service + location combination manually? That's hundreds of pages.

I built an automated pipeline that mines keywords from Google Autocomplete, stores them in a database, and generates SEO-optimized Next.js pages.

The Strategy

Mine keywords from Google Autocomplete for service + location combinations
Store and dedupe in PostgreSQL
Group keywords by service type and location
Generate pages when a group has enough keywords
Auto-deploy via Git push to Vercel

Mining Keywords from Google Autocomplete

Google Autocomplete is a goldmine. Each query returns 8-10 suggestions. Run 25 queries and get ~200 keywords per batch.

async function getAutocompleteSuggestions(query) {
  const url = `http://suggestqueries.google.com/complete/search?client=firefox&q=${encodeURIComponent(query)}`;
  const response = await fetch(url);
  const data = await response.json();
  return data[1] || [];
}