Quick overview

This workflow searches YouTube via Apify for videos matching a keyword, deduplicates the resulting channels, scrapes each channel’s About description, uses OpenAI to extract contact email addresses, and appends channels with emails to a Google Sheets tab.

How it works

1. Starts when you manually execute the workflow.
2. Sends a keyword-based search request to the Apify YouTube Scraper to retrieve recent YouTube results and their channel URLs.
3. Deduplicates the results so each channel URL is processed only once.
4. Scrapes each channel’s About/description data using an Apify YouTube Scraper request.
5. Uses OpenAI to extract and de-obfuscate any email addresses found in the channel description.
6. Keeps only channels where at least one email address was extracted.
7. Appends the channel name, channel URL, extracted emails, search query, and the current date to Google Sheets.

Setup

1. Add an Apify API token using an HTTP Header Auth credential (Authorization: Bearer <token>) and connect it to both Apify HTTP Request steps.
2. Add an OpenAI API key credential and choose the model name you want to use in the Configuration values.
3. Connect your Google Sheets OAuth credential, then set the target spreadsheet document ID and sheet/tab (for example, the “creator_emails” sheet).

Additional info

Find YouTube creator emails with OpenAI and save them to Google Sheets

📥 Open full documentation on Notion

Need help customizing?

Contact me for consulting and support : Linkedin

MY NEW YOUTUBE CHANNEL

👉 Subscribe to my new YouTube channel. Here I'll share videos and Shorts with practical tutorials and FREE templates for n8n.