Generate Local Business Pages
Find local businesses via Google Places, filter by ratings and digital presence, enrich with AI-generated descriptions, and publish structured HTML pages to your website.
Introduction
This workflow automates the process of discovering local businesses, filtering them by quality signals, and generating ready-to-publish HTML pages for each one. It queries Google Places based on your search criteria, keeps only the best matches, enriches each listing with AI-generated descriptions, and outputs complete webpages you can deploy to a static hosting platform.
What It Does
- Triggers on a schedule — Runs automatically on a recurring basis (e.g., every Monday morning).
- Defines search parameters — Sets the business type, location, minimum rating, minimum review count, language, and region.
- Queries Google Places — Sends a search request to the Google Places API and retrieves matching business listings.
- Filters results — Keeps only operational, highly-rated businesses that lack a website, prioritizing those with limited online presence.
- Generates AI descriptions — Uses an AI model to produce a short summary and a detailed professional description for each business.
- Builds HTML pages — Constructs complete, well-structured HTML pages with business details, hours, reviews, ratings, and metadata.
- Publishes to GitHub — Pushes the generated pages to a GitHub repository for static site deployment.
What You Need
- A Needle platform account with access to workflow automation
- A Google Places API key with sufficient quota and permissions
- A GitHub repository configured for static site deployment (e.g., via Vercel or Netlify)
How the Flow Works
| Node | Description |
|---|---|
| Scheduled Trigger | Activates the workflow on a recurring schedule in your configured timezone. |
| Code Node (Setup Query) | Defines the search query, target location, and filtering thresholds (minimum rating, review count, language, region). |
| HTTP Request (Google Places) | Sends a POST request to the Google Places API to retrieve businesses matching your criteria. |
| Code Node (Filter & Format) | Filters results to keep only operational, highly-rated businesses without websites. Formats data including slugs, reviews, and operating hours. |
| AI Node | Generates a concise summary and a longer professional description for each business based on its data and reviews. |
| Merge Node | Combines the original business data with the AI-generated text. |
| Code Node (Build HTML) | Constructs a complete HTML page for each business, including name, category, contact info, hours, Google Maps link, star ratings, reviews, and AI-generated descriptions. |
| HTTP Request (GitHub) | Pushes the generated HTML files to a GitHub repository for deployment. |
| Code Node (Output Link) | Returns the published URL for each business page. |
Output
Each run produces up to 5 fully structured HTML pages, one per qualifying business. Every page includes:
- Business name and category
- Address and phone number
- Google Maps link
- Star rating and review count
- Recent customer reviews
- AI-generated summary and detailed description
- Operating hours table
- SEO-friendly meta tags
Customization Tips
- Change the search query — Edit the setup code node to target any business type or location (e.g., dental clinics in Brooklyn, restaurants in Lisbon).
- Adjust filtering thresholds — Modify the minimum rating, minimum review count, or toggle the "no website" filter to match your needs.
- Tune the AI prompt — Update the system prompt in the AI node to change the tone, language, or length of generated descriptions.
- Change the output limit — The workflow defaults to 5 results per run, but you can increase or decrease this in the filter code node.
- Deploy anywhere — The generated HTML is designed for static hosting. Point it at any platform (Vercel, Netlify, GitHub Pages, etc.).
Notes
- Businesses without websites are prioritized by default, making this workflow ideal for promoting underserved local businesses.
- Make sure your Google API key has the Places API enabled and has enough quota for your usage.
- The schedule, timezone, and all search parameters are fully configurable to suit your market and workflow cadence.
Want to showcase your own workflows?
Become a Needle workflow partner and turn your expertise into recurring revenue.
