Automate YouTube Email Extraction with n8n & Google Sheets

Automate YouTube Email Extraction with n8n & Google Sheets

Unleash the power of automation with our "Automate YouTube Email Extraction with n8n & Google Sheets" workflow. Seamlessly extract contact email addresses from YouTube channels using cutting-edge tools like Apify and OpenAI, and systematically organize them in Google Sheets. Perfect for marketers and automation enthusiasts aiming to streamline their outreach processes effortlessly.

What this workflow does

This workflow meticulously extracts valuable contact information from YouTube channels by executing the following steps:

• Manual Trigger Initiation: Begin your search by manually executing this n8n workflow.
• YouTube Search via Apify: Input your keyword to send a search request using the Apify YouTube Scraper, retrieving relevant video results and channel URLs.
• Channel Deduplication: Automatically filter out duplicate channels to ensure unique processing of each YouTube channel URL.
• About Page Scraping: Extract comprehensive channel description data through Apify requests.
• OpenAI Email Extraction: Utilize OpenAI to identify and de-obfuscate email addresses found in channel descriptions.
• Data Appending to Google Sheets: Document details such as channel name, URL, and extracted emails alongside your search query and date in a specified Google Sheets tab.

Use cases

Implement this workflow for scenarios such as:

• Marketers: Enhance outreach campaigns by collecting email contacts of YouTube creators in your niche.
• SaaS Operators: Discover potential collaborations and partnerships by identifying channels that discuss relevant software services.
• Content Creators: Connect with peers by gathering potential communication leads from other YouTube channels.

Technical details

Seamlessly integrate the following tools and nodes within n8n:

• Trigger: Manual Execution
• API Integration: Apify with HTTP Request, utilizing Apify API token
• AI Processing: OpenAI API for email address extraction
• Data Storage: Google Sheets integration via OAuth credentials
• Management Nodes: Set, Filter, Sticky Note, and HTTP Request for streamlined automation

Empower your automation journey by leveraging this comprehensive workflow, designed to maximize results with minimal manual effort. Start collecting YouTube creator emails today!