{"product_id":"n8n-workflow-score-journalist-requests-with-apify-openai-telegram","title":"n8n Workflow: Score Journalist Requests with Apify, OpenAI \u0026 Telegram","description":"\u003ch3\u003eTurn daily journalist requests into targeted pitch drafts—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs every morning to pull open journalist requests from \u003cstrong\u003eApify\u003c\/strong\u003e, \u003cstrong\u003escore\u003c\/strong\u003e each one with \u003cstrong\u003eOpenAI\u003c\/strong\u003e (0–100) based on your expertise, log results in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and send only the best draft replies to you in \u003cstrong\u003eTelegram\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules automatically\u003c\/strong\u003e to run every morning at \u003cstrong\u003e8:00am\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches open-deadline journalist requests\u003c\/strong\u003e using the \u003cstrong\u003eApify\u003c\/strong\u003e actor “Journalist Request Finder” with your configured sources and keywords.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSkips previously shown requests\u003c\/strong\u003e so you don’t get duplicates across runs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScores each request with OpenAI\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eRates fit on a \u003cstrong\u003e0–100\u003c\/strong\u003e scale\u003c\/li\u003e\n      \u003cli\u003eGenerates a \u003cstrong\u003eshort reason\u003c\/strong\u003e and a \u003cstrong\u003esuggested angle\u003c\/strong\u003e aligned with your profile\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs every scored request\u003c\/strong\u003e (including low scores) to a specified \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e tab for tracking and tuning.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters and limits\u003c\/strong\u003e results below your minimum score threshold, and caps the number of drafted pitches per run.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDrafts a concise reply\u003c\/strong\u003e using OpenAI “in your voice” based on the suggested angle.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends drafts via Telegram\u003c\/strong\u003e with request details and a link for you to respond.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003ePR and growth teams who want a \u003cstrong\u003edaily pipeline of relevant journalist pitches\u003c\/strong\u003e without manual searching.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators using n8n to \u003cstrong\u003eautomate outbound media outreach\u003c\/strong\u003e and prioritize high-fit opportunities.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers who want an end-to-end workflow combining \u003cstrong\u003eApify + OpenAI + Google Sheets + Telegram\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/tools:\u003c\/strong\u003e set, limit, filter, Telegram, sticky note, Google Sheets\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Apify (Journalist Request Finder), OpenAI (scoring + drafting), Google Sheets (logging), Telegram (delivery)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore logic:\u003c\/strong\u003e schedule, deduplication of shown requests, score 0–100, store all results, filter by threshold, draft limited pitch replies\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eSet up Apify credentials, an OpenAI API credential (choose the model), a Google Sheet URL, and a Telegram bot\/chat ID—then let the workflow handle your daily journalist outreach.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46157940818099,"sku":"N8N-20338","price":6.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/W3Isy5ZbFmFxJ6zECJe05_E6QG7puI.png?v=1791019088","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-score-journalist-requests-with-apify-openai-telegram","provider":"N8N Commerce","version":"1.0","type":"link"}