👉 n8n No Limits Access :

https://www.hostg.xyz/SHHAd

Hébergement VPS n8n | Automatisation sécurisée et évolutive

coupon -15% : DRFIRAS15

👉 Formation n8n en Français

Formation n8n en Français : Automatisation & Agents IA

coupon -20% : LANCEMENT : HERE

What you will build

A workflow that searches YouTube by keyword, scrapes each creator's channel, uses OpenAI to pull business emails out of the channel description, and appends clean leads to Google Sheets. Perfect for creator outreach, UGC sourcing and partnership lead-gen.

Flow:

Manual trigger → Configuration → Search YouTube (Apify) → Remove Duplicate Channels → Scrape Channel About (Apify) → Extract Emails with OpenAI → Prepare Row → Keep Channels With Email → Save to Google Sheets

<aside> 🎯

Goal of this doc: let you rebuild the workflow node by node, live, without opening the original. Every value is copy-paste ready.

</aside>

Prerequisites & credentials

You need three credentials in n8n before you start.

1. OpenAI — credential name OpenAi account (type OpenAI API)