Export Google Maps Leads to Google Sheets via n8n + Apify

Export Google Maps business leads to Google Sheets with n8n + Apify

This n8n workflow automatically runs on a weekly schedule, pulls cleaned business lead data from Google Maps via Apify, and appends the results into your Google Sheets worksheet—so your sales and outreach pipeline stays updated without manual exporting.

What this workflow does

• Runs weekly using a schedule trigger.
• Starts the Apify actor captainhandsome/google-maps-business-search with your configured search_terms and max_items.
• Waits 45 seconds to give the Apify scraping job time to generate a dataset.
• Fetches the cleaned JSON items from the Apify dataset produced by the run.
• Appends the lead records into the Google Sheets tab named “Leads”, including business details such as name, phone, address, rating, and website.

Use cases

• Maintain a local lead list (e.g., contractors, clinics, agencies) by refreshing Google Maps leads on a recurring basis.
• Support SaaS sales ops by continuously updating prospect data in a centralized Google Sheet.
• Streamline automation engineering workflows where Google Sheets is your lightweight CRM or sourcing log.

Technical details

• n8n nodes used: schedule trigger, wait, HTTP Request, Google Sheets.
• Apify integration: uses an Apify token added as an HTTP Header Auth credential for Apify API requests.
• Configuration: replace YOUR_GOOGLE_SHEET_ID; confirm the sheet name is “Leads” (or update it).
• Input controls: set search_terms and max_items in the Apify actor input to match your target locations and desired lead volume.

Ideal if you want a practical Google Maps lead generation workflow that turns Apify results into actionable rows in Google Sheets—fully automated with n8n.