{"product_id":"daily-youtube-trending-digest-google-sheets-gmail","title":"Daily YouTube Trending Digest: Google Sheets + Gmail","description":"\u003ch3\u003eGet a daily “what’s trending” email—automatically—by ranking YouTube videos stored in Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow scans your YouTube channel data in Google Sheets every day, selects only above-average videos per channel, and sends a formatted HTML trending digest via Gmail with thumbnails, titles, views, and duration.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns daily at 10:00\u003c\/b\u003e using a Schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eReads the list of channels\u003c\/b\u003e from your Google Sheets spreadsheet (via your “Channels” sheet).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eFor each channel\u003c\/b\u003e, loads that channel’s video rows from a Google Sheets tab named after the \u003cb\u003echannel ID\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCalculates an average views baseline\u003c\/b\u003e per channel.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eFilters for above-average performers\u003c\/b\u003e: keeps videos where \u003cb\u003eviews \u0026gt;= channel average views\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAggregates results\u003c\/b\u003e across channels into a single dataset for the email.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends an HTML email via Gmail\u003c\/b\u003e including: thumbnails, titles, channel name, views, duration, and a views-to-average multiplier for each selected video.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eCreator analytics\u003c\/b\u003e: send yourself (or your team) a daily roundup of which videos are outperforming the channel’s usual average.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eMedia ops \/ SaaS dashboards\u003c\/b\u003e: use Google Sheets as your data layer, then deliver digest-style insights to stakeholders by email.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAutomation engineers\u003c\/b\u003e: deploy a repeatable n8n workflow pattern for “read → filter → aggregate → email” using YouTube metrics.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eTriggers:\u003c\/b\u003e Schedule (daily at 10:00)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations:\u003c\/b\u003e Google Sheets (OAuth), Gmail (OAuth)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eWorkflow logic:\u003c\/b\u003e set, filter, aggregate, google sheets access, split in batches\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSetup requirements:\u003c\/b\u003e update the spreadsheet ID and ensure your “Channels” sheet and per-channel tabs are named correctly; each per-channel sheet must include the expected columns so the digest can render (including channel\/tab reference, video ID, title, channel title, views, and duration).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45865765634227,"sku":"N8N-18356","price":28.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/safQa6QtYUTrZCnewVREC_EJbM543w.png?v=1787044670","url":"https:\/\/buyflowscripts.com\/products\/daily-youtube-trending-digest-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}