This n8n workflow automates the process of finding and collecting contact information for local businesses using Google Sheets, Google Maps, web scraping, and AI-powered email extraction. It starts with a manual trigger, allowing users to initiate the process on demand. The workflow reads search queries and locations from a Google Sheet, conducts local searches via Google Maps API using SerpApi, and formats the results into a structured table.
For each business found, the workflow visits their website using an Apify crawler, scrapes the webpage content, and uses an AI language model (OpenAI GPT-4) to extract email addresses if available. The gathered data—including business name, website, address, phone number, and email—are then saved back into a Google Sheet. The process also marks each search as completed in the sheet, ensuring seamless tracking for repeated runs.
This workflow is particularly useful for local marketing, outreach campaigns, or compiling a database of business contacts in a specific area. It combines web search automation, web scraping, and AI to streamline what would otherwise be a manual and time-consuming task, enabling efficient lead generation and data collection for small business owners, marketers, and researchers.
Reviews
There are no reviews yet.