Automated Local Business Outreach and Tracking Workflow

somdn_product_page

This n8n workflow automates the process of lead generation, outreach, and follow-up for local businesses. It begins with a manual trigger that pulls search queries from a Google Sheet, such as ‘best plumbers in Chicago.’ These queries are sent to Dumpling AI to scrape Google Maps for matching businesses. The results are split into individual entries where the business name and phone number are extracted.

The workflow then filters out entries without valid phone numbers and formats the remaining numbers for international dialing. It uses Vapi AI to initiate automated voice calls to these businesses, leveraging the business name in the call script. After each call, the details—including business name, number, and call status—are logged back into a Google Sheet for tracking and follow-up.

This automation is practical for sales teams or marketers looking to cold call local leads efficiently, ensuring they target valid numbers and maintain records of outreach efforts. The workflow combines web scraping, data processing, AI-powered calling, and data logging to streamline the outreach process.

Node Count

11 – 20 Nodes

Nodes Used

filter, googleSheets, httpRequest, manualTrigger, set, splitOut, stickyNote

Reviews

There are no reviews yet.

Be the first to review “Automated Local Business Outreach and Tracking Workflow”

Your email address will not be published. Required fields are marked *