{"product_id":"automate-youtube-email-extraction-with-n8n-google-sheets","title":"Automate YouTube Email Extraction with n8n \u0026 Google Sheets","description":"\u003ch3\u003eAutomate YouTube Email Extraction with n8n \u0026amp; Google Sheets\u003c\/h3\u003e\n\n\u003cp\u003eUnleash the power of automation with our \"Automate YouTube Email Extraction with n8n \u0026amp; 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eThis workflow meticulously extracts valuable contact information from YouTube channels by executing the following steps:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManual Trigger Initiation:\u003c\/strong\u003e Begin your search by manually executing this n8n workflow.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eYouTube Search via Apify:\u003c\/strong\u003e Input your keyword to send a search request using the Apify YouTube Scraper, retrieving relevant video results and channel URLs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChannel Deduplication:\u003c\/strong\u003e Automatically filter out duplicate channels to ensure unique processing of each YouTube channel URL.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAbout Page Scraping:\u003c\/strong\u003e Extract comprehensive channel description data through Apify requests.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI Email Extraction:\u003c\/strong\u003e Utilize OpenAI to identify and de-obfuscate email addresses found in channel descriptions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData Appending to Google Sheets:\u003c\/strong\u003e Document details such as channel name, URL, and extracted emails alongside your search query and date in a specified Google Sheets tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cp\u003eImplement this workflow for scenarios such as:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMarketers:\u003c\/strong\u003e Enhance outreach campaigns by collecting email contacts of YouTube creators in your niche.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS Operators:\u003c\/strong\u003e Discover potential collaborations and partnerships by identifying channels that discuss relevant software services.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eContent Creators:\u003c\/strong\u003e Connect with peers by gathering potential communication leads from other YouTube channels.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cp\u003eSeamlessly integrate the following tools and nodes within n8n:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTrigger:\u003c\/strong\u003e Manual Execution\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAPI Integration:\u003c\/strong\u003e Apify with HTTP Request, utilizing Apify API token\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI Processing:\u003c\/strong\u003e OpenAI API for email address extraction\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData Storage:\u003c\/strong\u003e Google Sheets integration via OAuth credentials\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManagement Nodes:\u003c\/strong\u003e Set, Filter, Sticky Note, and HTTP Request for streamlined automation\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eEmpower your automation journey by leveraging this comprehensive workflow, designed to maximize results with minimal manual effort. Start collecting YouTube creator emails today!\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45690880032947,"sku":"N8N-17125","price":5.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/9yKGm-nRKmM66FnfO2PmY_c5563fb6a266495b9d16ae43017680d8.jpg?v=1784106572","url":"https:\/\/buyflowscripts.com\/products\/automate-youtube-email-extraction-with-n8n-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}