{"product_id":"apify-journalist-request-finder-google-sheets-telegram-digest","title":"Apify Journalist Request Finder → Google Sheets \u0026 Telegram Digest","description":"\u003ch3\u003eGet a daily Telegram digest of fresh journalist requests—automatically added to Google Sheets\u003c\/h3\u003e\n\u003cp\u003eWith the \u003cstrong\u003eApify Journalist Request Finder → Google Sheets \u0026amp; Telegram Digest\u003c\/strong\u003e n8n workflow, you’ll collect new open journalist requests from \u003cstrong\u003eApify’s Journalist Request Finder\u003c\/strong\u003e, save them in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and send a \u003cstrong\u003efiltered, deadline-sorted\u003c\/strong\u003e shortlist to \u003cstrong\u003eTelegram\u003c\/strong\u003e every morning.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 8am\u003c\/strong\u003e on a schedule.\u003c\/li\u003e\n  \u003cli\u003eUses your configured \u003cstrong\u003etopics\u003c\/strong\u003e, \u003cstrong\u003esources\u003c\/strong\u003e, and \u003cstrong\u003erequest limits\u003c\/strong\u003e to run the Apify actor \u003cstrong\u003eJournalist Request Finder\u003c\/strong\u003e and fetch open journalist requests (including from \u003cstrong\u003eSourceBottle\u003c\/strong\u003e and social sources).\u003c\/li\u003e\n  \u003cli\u003eAutomatically \u003cstrong\u003eremoves requests already sent\u003c\/strong\u003e in previous executions to prevent repeat alerts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFormats and appends results\u003c\/strong\u003e into consistent columns in your selected \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e spreadsheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters\u003c\/strong\u003e stored requests to keep only:\n    \u003cul\u003e\n      \u003cli\u003erequests matching your \u003cstrong\u003etopics\u003c\/strong\u003e (optional), and\u003c\/li\u003e\n      \u003cli\u003erequests with a \u003cstrong\u003eclosing time within your chosen deadline window\u003c\/strong\u003e (when available).\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003eSends a \u003cstrong\u003esingle Telegram digest\u003c\/strong\u003e sorted by \u003cstrong\u003e“days left”\u003c\/strong\u003e, capped at \u003cstrong\u003e20 requests\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePR \u0026amp; media teams\u003c\/strong\u003e tracking journalist leads by topic and urgency.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS operators\u003c\/strong\u003e managing outreach pipelines without manual spreadsheet updates.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation engineers\u003c\/strong\u003e deploying a repeatable “crawl → store → dedupe → notify” workflow in n8n.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify\u003c\/strong\u003e integration using the \u003cstrong\u003eJournalist Request Finder\u003c\/strong\u003e actor (requires Apify connection: API token or OAuth).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: OAuth credentials + workflow parameter \u003cem\u003egoogleSheetUrl\u003c\/em\u003e to append results.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTelegram\u003c\/strong\u003e: bot credentials (via @BotFather) + \u003cem\u003etelegramChatId\u003c\/em\u003e for delivery (use @userinfobot to find your chat ID).\u003c\/li\u003e\n  \u003cli\u003en8n nodes used: \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003efilter\u003c\/strong\u003e, \u003cstrong\u003etelegram\u003c\/strong\u003e, \u003cstrong\u003eaggregate\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e, \u003cstrong\u003egoogle sheets\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46153964126387,"sku":"N8N-20310","price":51.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/rmVvdTv0dBqTVmMdQvMB__uBgdIU25.png?v=1790932117","url":"https:\/\/buyflowscripts.com\/products\/apify-journalist-request-finder-google-sheets-telegram-digest","provider":"N8N Commerce","version":"1.0","type":"link"}