Automated Google Maps Lead Extraction to Google Sheets

This n8n workflow automates the process of scraping local business data from Google Maps using an Apify actor and storing the results in Google Sheets, making lead generation efficient and hands-free. The workflow begins with a manual trigger, which starts the Apify actor tasked with collecting Google Maps data based on your specified search terms. Once the actor completes the scraping, the workflow waits briefly to ensure data is ready, then retrieves the dataset from Apify. The data, including business name, address, website, and phone number, is then dynamically mapped and appended as a new row in a designated Google Sheet. This setup is ideal for marketers, sales teams, or entrepreneurs aiming to gather local business leads systematically, such as locating restaurants or service providers in specific regions. By automating data collection and organization, users can save time and focus on outreach or analysis.