How to Scrape 1,000+ Leads and Send an Automated Offer Using Make.com and AI

Learn to build a fully automated lead generation system that scrapes over 1,000 business leads from Yellow Pages and automatically sends them personalized social media content calendar proposals. Walk through the complete workflow construction using Make.com automation platform, starting with setting up Apify web scrapers to extract business information and contact details from Yellow Pages listings. Master the process of parsing JSON data, aggregating results across multiple pages, and using Perplexity AI to gather contextual information about each business. Discover how to create compelling social media calendars by generating JSON structures for posts, leveraging AI for content creation, and producing accompanying images. Explore Google Sheets template creation and sharing functionality, AI audio file generation for enhanced proposals, and automated Gmail delivery of the complete content calendar package. Gain hands-on experience with essential automation tools including Make.com scenarios, Apify scrapers, array aggregators, AI content generation, and email automation to create a scalable lead generation system that operates without manual intervention.

Syllabus

0:00 Intro
0:21 Concept overview
2:37 Begin building workflow
4:37 Create scenario in Make.com
6:30 Apify Yellow Pages web scraper
13:30 Get dataset items
16:40 Start workflow with parse JSON
19:45 Grabbing email from Yellow Pages listings
21:57 Apify email scraper
29:04 Array aggregator on multiple pages
32:20 Using Perplexity AI to find context on businesses
39:20 Create social media calendar
40:11 Create JSON for social media posts
50:42 AI content creation
56:28 Generate AI image
59:25 Social media post array aggregator
1:00:50 Google sheets template
1:21:05 Find and share Google sheets template
1:25:30 Generate an AI audio file
1:29:45 Send gmail AI content calendar proposal
1:33:40 Conclusion