Automate lead discovery, analysis, and outreach drafting with a single AI agent.
The AI agent scrapes Google Maps for target businesses based on your query, collects business data, and visits each website to extract relevant content. It uses OpenAI to craft personalized sales emails tailored to each business's needs and value proposition. All data—including business details, scraped content, and email drafts—is saved to Google Sheets for seamless outreach tracking.
End-to-end actions the agent performs to automate outreach.
Scrape Google Maps results based on your query.
Visit each business website to extract content.
Analyze scraped text to tailor messages.
Generate a personalized email subject and body with OpenAI.
Append data and drafts to Google Sheets.
Log progress and handle retries.
Before you start using this AI agent, teams spend hours manually researching leads and drafting emails. After implementing it, lead data is scraped, content is analyzed, emails are drafted, and results are stored automatically in Sheets.
A simple 3-step flow anyone can use.
Set searchQuery, maxPlaces, serviceName, and serviceStrength to shape results.
Run the APIFY Google Maps Scraper to fetch leads, then fetch each website HTML and extract relevant content.
OpenAI generates subject and body, then the agent appends all data to Google Sheets.
A realistic scenario showing the end-to-end use.
Scenario: Target 20 cafes in Shibuya, Tokyo. Set searchQuery to 'Cafes in Shibuya' and maxPlaces to 20, serviceName to 'Web design', and serviceStrength to 'local small business focus'. In about 60 minutes, the AI agent scrapes 20 leads, extracts site content, generates personalized emails in Japanese, and saves results to the Google Sheet configured in step 2.
Roles that gain practical value from this AI agent.
Need scalable lead sourcing and outreach drafting.
Manage multi-client outreach across cities with consistency.
Expand local service offerings with reliable templates.
Track outreach pipeline with integrated data.
Accelerate local growth with automated outreach.
Provide clients with repeatable outreach workflows.
Tools used inside the AI agent workflow.
Fetches lead data from Google Maps based on the defined query.
Generates personalized email subject and body content.
Stores leads, scraped content, and generated drafts.
Orchestrates the workflow between scraper, AI, and Sheets.
Appends data to the designated sheet.
Scenarios where this AI agent provides concrete value.
Common questions and practical answers.
The agent collects business name, address, phone, and website. It may also extract visible content from the site to inform email drafting. Data is stored in the Google Sheet alongside the generated draft. Scraping is performed using the Apify Google Maps Scraper under your configured queries and limits. You can filter or disable certain domains if needed.
Yes. You can adjust the OpenAI prompt to specify the desired language and tone. The agent will generate subject lines and bodies in the chosen language when provided with the appropriate model and prompts. Keep in mind that some languages may require custom prompts to ensure natural phrasing. You can test a few samples and refine prompts as needed.
Absolutely. The OpenAI prompt can be adjusted to set tone, formality, and structure. You can adjust the system message to emphasize shortness, a call-to-action, or value-focused language. After changes, run a test batch to validate consistency across drafts. Reapply changes anytime to adapt to new campaigns.
The limit is determined by your configured maxPlaces value and the performance of the scraping actor. Larger batches may require more API credits and may take longer to complete. You can start with a smaller batch to validate data quality and email drafts before scaling up. The workflow is designed to be incremental and restartable.
You need accounts and API keys for Apify, OpenAI, and Google Sheets. The workflow configuration node expects valid credentials for Apify and Google Sheets, while the OpenAI node requires your API key. Access should be scoped to only the sheets and data you authorize. Ensure credentials are stored securely and rotated as needed.
Yes. All scraped data, business details, and email drafts are stored in your Google Sheets you control. Access to the sheet can be restricted to your team. The workflow handles data in transit via API calls, and you can audit changes through Google Sheets revision history. You retain ownership of the data and drafts.
Yes. The design supports exporting or syncing data with other systems through Sheets or API integrations. You can extend the workflow to push finalized email drafts or lead records into a CRM via its API. For complex CRM workflows, you may add an intermediate step in n8n to transform data before transfer. This keeps outreach consistent while enabling broader automation.
Automate lead discovery, analysis, and outreach drafting with a single AI agent.
