Quick overview
Quick overview This workflow receives a webhook request with a target business vertical and location, finds matching companies via Google Places API, scrapes their websites with Firecrawl to extract and validate contact emails, deduplicates against Supabase, stores new prospects, and sends a single digest via Microsoft Outlook plus a notification webhook. How it works Receives a POST webhook request containing a business vertical, location, and optional result limit. Searches Google Places Text Search for matching local businesses and keeps operational results that include a website while filtering out competitor categories. Scrapes each business homepage and a likely contact page with Firecrawl to extract a preferred email address and detect parked or low-content domains. Validates the extracted email domain by checking DNS MX records via Google DNS-over-HTTPS. Collects all processed businesses, fetches existing prospects from Supabase, and removes entries that match existing website URLs or verified emails. Inserts the new, emailable prospects into a Supabase table and sends a single HTML digest email through Microsoft Outlook. Posts a run summary to a separate webhook endpoint (for a Telegram relay) and returns a JSON response to the original webhook caller. Setup Create credentials for Google Places API (HTTP Header Auth with your API key), Firecrawl, Supabase, and Microsoft Outlook OAuth2. Replace the Supabase REST URLs (YOUR-PROJECT.supabase.co) and ensure a pilot_prospects table exists with fields to store website_url, verified_email, and the inserted prospect payload. Update the webhook path and send POST requests like {"vertical":"dentists","location":"Orlando FL","limit":20} to trigger the workflow. Set the digest recipient/sender addresses in the Microsoft Outlook email node. Replace the notification webhook URL used for the Telegram relay with your own endpoint (and configure that endpoint/bot to post to your target chat). Additional info Two details that make this more useful than a plain Places scrape. It validates each extracted email domain with a real DNS MX lookup, so you are not saving addresses that can never receive mail. And it deduplicates against what you already have in Supabase before inserting, matching on both website URL and verified email, so re-running it on the same vertical will not fill your table with the same businesses again. The competitor-category filter and the parked-domain detection are both worth tuning to your own market before you run it at volume. Questions or help getting it running: support@priscgroup.com Built by PRISC Group. Automate. Relentlessly. Ruthlessly. An n8n automation workflow template by Pedro Olavarria.
Pedro Olavarria
web
free
Others in the same category, ranked by how often they are opened.
