{"product_id":"automate-weekly-youtube-reports-openai-slack-gmail-workflow","title":"Automate Weekly YouTube Reports: OpenAI, Slack \u0026 Gmail Workflow","description":"\u003ch3\u003eRevolutionize Your Video Analytics with Our Automated Weekly YouTube Reports Workflow\u003c\/h3\u003e\n\n\u003cp\u003eExperience effortless YouTube analytics with our \"Automate Weekly YouTube Reports\" workflow. Tailored for n8n users, this powerful automation executes an in-depth review of your latest YouTube videos, delivering weekly performance insights directly to your Slack channel and email, while maintaining a comprehensive log in Google Sheets.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does:\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eKick-starts every Monday at 08:00 with a scheduled trigger to keep you updated.\u003c\/li\u003e\n  \u003cli\u003eUtilizes the YouTube Data API to retrieve metadata and statistics for the 20 most recent videos on your channel.\u003c\/li\u003e\n  \u003cli\u003eAnalyzes each video’s performance, ranking them based on a composite performance score, and categorizes them as Top Performer, Average, or Underperformer.\u003c\/li\u003e\n  \u003cli\u003eEmploys OpenAI to create an insightful summary of your weekly video performance, complete with recommendations.\u003c\/li\u003e\n  \u003cli\u003eShares a professional and concise weekly digest to a Slack channel, spotlighting your best and worst videos, along with the top 5 ranked videos and AI-generated insights.\u003c\/li\u003e\n  \u003cli\u003eLogs each video’s metrics into a dedicated Google Sheets tab for seamless historical tracking.\u003c\/li\u003e\n  \u003cli\u003eDelivers a comprehensive HTML report to your email via Gmail, ensuring the content manager stays informed and ahead of the curve.\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 Gain valuable insights into your video performance to tailor future content more effectively.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMarketing Teams:\u003c\/strong\u003e Quickly understand which videos resonate with your audience and why, helping to improve marketing strategies.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS Operators:\u003c\/strong\u003e Monitor and document video metrics for ongoing campaigns effortlessly, ensuring consistent analysis and reporting.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details:\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eIntegrations: YouTube Data API v3, OpenAI, Slack, Google Sheets, Gmail\u003c\/li\u003e\n  \u003cli\u003en8n Nodes Used: Set, Code, Gmail, Slack, Split Out, Aggregate\u003c\/li\u003e\n  \u003cli\u003eSetup Requirements: YouTube API key, OpenAI credentials, Slack channel ID, Google Sheets configuration\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45584052486323,"sku":"N8N-16476","price":16.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/gC-tCpSM-BOJ_T4vodz4V_27c5dcb0087b4e0b8fea60d9378299a9.jpg?v=1781773308","url":"https:\/\/buyflowscripts.com\/products\/automate-weekly-youtube-reports-openai-slack-gmail-workflow","provider":"N8N Commerce","version":"1.0","type":"link"}