Capture local business leads from Google Maps and company websites in one place. Ideal for marketers and growth teams that need fresh, structured contact lists fast and ready for outreach. Teams can define a niche and location and receive a clean sheet with enriched details.

A chat entry starts the flow. You type a search, city, state, and country code. An AI agent, powered by GPT-4o and short term memory, turns your message into clean inputs. The Google Maps extractor runs through Apify to pull business names, addresses, phones, and hours. Records are written to Google Sheets and then merged into a single list. A second step crawls each website with Apify to capture readable content such as services and key pages. When data is missing, a Google Search fallback helps enrich the record.

Set up requires accounts for OpenAI, Apify, SerpAPI, and Google Sheets. After connecting credentials, add your spreadsheet ID and sheet names, then test with the sample carpenter search. Expect hours of research reduced to minutes and more complete profiles for outreach. Useful for agencies, local service networks, and B2B teams building territory lists.

• Chat message trigger collects search, city, state, and country from a simple user prompt.
• AI agent with GPT-4o and short memory cleans and structures inputs for tools.
• Google Maps extraction via Apify pulls names, addresses, phones, hours, and more.
• Fallback enrichment with Google Search adds missing details when needed.
• Website crawler gathers readable on site content to enhance each record.
• Google Sheets append stores leads in a live spreadsheet for instant access.
• Aggregation nodes merge many items into clean lists ready for outreach.
• Subworkflow support lets you run the extractor or crawler with example JSON inputs.

• Reduce manual research from 3 hours to 10 minutes per lead list
• Streamline prospecting by about 70 percent through one flow
• Improve data completeness by 40 percent with website content enrichment
• Handle 5 to 10 times more leads per week without extra staff
• Cut copy and paste errors by up to 90 percent with direct sheet writes
• Connect Google Maps results, website content, and Google Sheets in one pipeline

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with OpenAI, Google Sheets, Apify and SerpAPI. See the Tools Required section above for links to create accounts with these services.
3. In the n8n credentials manager, create an OpenAI credential. Double click the GPT-4o node, open the 'Credential to connect with' dropdown, click 'Create new credential', and follow the on screen steps to add your OpenAI API key from the OpenAI API page.
4. Connect Google Sheets. Double click each Google Sheets node, choose 'Create new credential', complete OAuth in n8n Cloud, and grant access to the target Drive and spreadsheet.
5. Add your Apify token. Open each HTTP Request node calling Apify and replace the Authorization header value with 'Bearer YOUR_APIFY_TOKEN' from your Apify account's API page.
6. Connect SerpAPI. Open the enrichment tool node, create a new SerpAPI credential, and paste your SerpAPI key from the SerpAPI dashboard.
7. Set spreadsheet targets. In each Google Sheets node, select the correct Spreadsheet and Sheet Name. Use a dedicated sheet for maps results and another for website content if you want separation.
8. Review the AI agent system message. Ensure the fields you want collected match the sheet columns. Keep the city, search, state, and country code mapping aligned with the subworkflow inputs.
9. Test the Google Maps subworkflow. Run it with the provided JSON example for carpenter in San Francisco and confirm rows appear in your sheet.
10. Test the website crawler subworkflow with a few URLs from the first sheet. Confirm content fields save as expected.
11. Validate aggregation outputs. Check the aggregate nodes produce a single merged list and that column headers match your outreach needs.
12. Troubleshoot common issues. If you see 401 errors, re check API keys and tokens. If you hit rate limits or timeouts from Apify or SerpAPI, reduce batch size or add delays. If Sheets rejects rows, verify column names and data types.