{"product_id":"automate-youtube-summaries-in-google-sheets-with-apify-gemini","title":"Automate YouTube Summaries in Google Sheets with Apify \u0026 Gemini","description":"\u003ch3\u003eStreamline YouTube Content Summaries in Google Sheets with Apify \u0026amp; Google Gemini\u003c\/h3\u003e\n\u003cp\u003eTransform your YouTube video analysis process by seamlessly integrating subtitle scraping and summarization into Google Sheets with this powerful \u003cstrong\u003en8n workflow\u003c\/strong\u003e. Say goodbye to manual data entry and endless video watching—automate your YouTube content summaries in just a few simple steps using \u003cstrong\u003eApify\u003c\/strong\u003e and \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this Workflow Does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonitoring new or updated YouTube video URLs in a specified Google Sheets worksheet every minute.\u003c\/li\u003e\n  \u003cli\u003eSending the video link to \u003cstrong\u003eApify’s YouTube Scraper\u003c\/strong\u003e to fetch and clean subtitles into a plain-text transcript.\u003c\/li\u003e\n  \u003cli\u003eUtilizing \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to transform the transcript into a concise, 5-bullet-point summary.\u003c\/li\u003e\n  \u003cli\u003eUpdating the original Google Sheets with the summary and marking the task as “Done”.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse Cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eContent Creators\u003c\/strong\u003e: Quickly summarize and analyze competitor videos to enhance your own strategy.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDigital Marketing Teams\u003c\/strong\u003e: Efficiently track and summarize video content for seamless integration into marketing reports.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eResearch Analysts\u003c\/strong\u003e: Automate the process of extracting insights from educational YouTube content without manual subtitling.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical Details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTech Stack\/Nodes: Google Sheets, Apify (YouTube Scraper - streamers\/youtube-scraper), Google Gemini (PaLM), n8n automation nodes.\u003c\/li\u003e\n  \u003cli\u003eEnsure unique \"Video URL\" values in Google Sheets for accurate row matching.\u003c\/li\u003e\n  \u003cli\u003eRequires Google Sheets OAuth2 connection, Apify API token, and Google Gemini API key\/credentials.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eWith this expertly crafted automation workflow, \u003cstrong\u003en8n users\u003c\/strong\u003e, \u003cstrong\u003eautomation engineers\u003c\/strong\u003e, and \u003cstrong\u003eSaaS operators\u003c\/strong\u003e can easily manage large volumes of YouTube content, automatically updating their records and accelerating their content strategy processes.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45591792943283,"sku":"N8N-16562","price":32.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/1-bjcmGCA5oREozXxh-nB_e28bf56fdf7646459ecca4cffbc584e0.jpg?v=1782205341","url":"https:\/\/buyflowscripts.com\/products\/automate-youtube-summaries-in-google-sheets-with-apify-gemini","provider":"N8N Commerce","version":"1.0","type":"link"}