--- title: "Podcast guest pitches as Gmail drafts, with every show scored in Google Sheets" slug: "podcast-guest-pitches-gmail-drafts-google-sheets" type: "n8n-workflow-template" url: "https://automationbyexperts.com/n8n/podcast-guest-pitches-gmail-drafts-google-sheets" n8n_url: "https://n8n.io/workflows/21118-score-and-pitch-podcast-guest-leads-with-apify-openai-google-sheets-and-gmail/" workflow_json: "https://automationbyexperts.com/static/n8n/podcast-guest-pitches-gmail-drafts-google-sheets.json" actor: "Podcast Guest Finder - Shows & Host Emails" actor_url: "https://automationbyexperts.com/apify/podcast-guest-finder" schedule: "every Monday at 7:00" apps: ["Apify", "OpenAI", "Google Sheets", "Gmail", "Telegram"] published: "2026-10-16" --- # Podcast guest pitches as Gmail drafts, with every show scored in Google Sheets This n8n workflow searches for podcasts that book guests every Monday at 7:00, keeps the shows that are still publishing and have a contact email, has OpenAI score each against your talking points, and saves every show to Google Sheets. For the best fits it writes a pitch email and leaves it as a Gmail draft. **Use it on n8n.io:** [Score and pitch podcast guest leads with Apify, OpenAI, Google Sheets and Gmail](https://n8n.io/workflows/21118-score-and-pitch-podcast-guest-leads-with-apify-openai-google-sheets-and-gmail/) **Workflow JSON:** https://automationbyexperts.com/static/n8n/podcast-guest-pitches-gmail-drafts-google-sheets.json **Actor it runs:** [Podcast Guest Finder - Shows & Host Emails](https://automationbyexperts.com/apify/podcast-guest-finder) ($0.004 per podcast lead delivered) **Runs:** every Monday at 7:00 ## How it works Finding a show worth pitching usually means opening dozens of podcast pages. This workflow does the search for you: it looks for shows in your niches that are still publishing, signal an interview format and list a contact email, and it remembers the shows it has already sent you. OpenAI scores each show against the talking points and proof points you wrote, names the overlap in a phrase and proposes the episode you could deliver. A check in n8n keeps the score honest: a show only scores above 70 when your subject appears in its own title. Every scored show goes to Google Sheets, rejections included. Shows above minFit get a pitch email, capped by maxPitches, which arrives in Telegram and as a Gmail draft addressed to the host. Nothing is ever sent automatically. ## Nodes in the workflow 1. Every Monday at 7am (Schedule Trigger) 2. Set your pitch (Edit Fields) 3. Find podcasts that book guests (Apify) 4. Skip shows already seen (Remove Duplicates) 5. OpenAI model (OpenAI Chat Model) 6. Score the show fit (Basic LLM Chain) 7. Fit format (Structured Output Parser) 8. Format the show row (Edit Fields) 9. Save every show (Google Sheets) 10. Keep the shows worth pitching (Filter) 11. Cap the pitches per run (Limit) 12. Write the pitch email (Basic LLM Chain) 13. Send the pitch to Telegram (Telegram) 14. Create the Gmail draft (Gmail) ## Settings you edit | Setting | Default | What it does | |---|---|---| | `niches` | B2B SaaS, bootstrapped founders, product-led growth | The topics to search for, separated by commas. | | `country` | US | The country whose podcast directory is searched. | | `activeWithinDays` | 90 | Only shows with an episode this recent are kept. | | `maxShows` | 25 | Shows fetched per run, which is also what caps the Apify cost of a run. | | `guestName` | YOUR NAME | The name signed on the pitch. | | `guestTitle` | Founder of a pricing consultancy for B2B SaaS | One line on who you are, used in the pitch. | | `yourExpertise` | How small SaaS companies set and change prices: packaging, seat versus usage pr… | What you know well, in your own words. | | `talkingPoints` | Why seat-based pricing stops working above a certain deal size; how to run a pr… | The subjects you could talk about. The score is measured against these. | | `proofPoints` | Eleven years in B2B SaaS pricing. Ran pricing changes for 40 companies between … | Facts that show you have earned the right to talk about them. | | `audienceValue` | Founders and operators of software companies between roughly 20,000 and 1 milli… | Who in a show's audience gains from hearing you. | | `minFit` | 60 | Shows scoring below this get no pitch. | | `maxPitches` | 5 | Most pitch emails one run writes. | | `googleSheetUrl` | PASTE_YOUR_GOOGLE_SHEET_URL_HERE | The URL of the Google Sheet that holds the shows tab. | | `showsTab` | Shows | The sheet tab every scored show is appended to. | | `telegramChatId` | PASTE_YOUR_TELEGRAM_CHAT_ID_HERE | The Telegram chat each pitch is sent to. | ## Google Sheet columns Show, Host, Email, Fit, Title match, Why it fits, Proposed episode, Episodes, Days since last episode, Genre, Categories, Guest signals, Apple link, Website, Found by keyword, Checked ## How to set it up 1. **Get the workflow into n8n** - Open it on n8n.io and choose "Use for free", or copy the workflow JSON from this page and paste it onto an empty n8n canvas. 2. **Connect your accounts** - Create a free Apify account and connect it in the Find podcasts node, then connect OpenAI, Google Sheets, Gmail and Telegram. 3. **Write your pitch details** - In the Set your pitch node fill in your niches, talking points and proof points, paste your Google Sheet URL and your Telegram chat id. 4. **Run once and read the sheet** - Run the workflow by hand and read the Shows tab before you trust the schedule. Then activate it. ## What it costs The workflow is free. Each run bills the actor on your own Apify account at $0.004 per podcast lead delivered. The Apify free plan covers a few shows per run. OpenAI tokens are billed on your own OpenAI account. ## FAQ ### How do I find podcasts that accept guests? Import this workflow into n8n and put your niches in the Set your pitch node. Every Monday it searches for shows that are still publishing, signal an interview format and list a contact email. ### Does it send the emails for me? No. The pitch is saved as a Gmail draft addressed to the host and sent to you in Telegram. You read it and press send yourself. ### How is a show scored? OpenAI compares the show with your talking points and proof points. n8n then checks the result: a show only scores above 70 when your subject appears in its own title. ### Can I skip Gmail? Yes. Delete the Gmail node and the pitch still reaches you in Telegram. ### What does it cost to run? The workflow is free. Each run bills the Podcast Guest Finder actor on your Apify account per lead, plus a few OpenAI calls on your own OpenAI account. ## More n8n templates - [Whop clipping campaigns scored by payout, with a clip brief in Telegram](https://automationbyexperts.com/n8n/whop-clipping-campaigns-briefs-telegram-google-sheets): This n8n workflow reads the Whop Content Rewards directory every morning at 8:00, applies your payout and budget filters, turns each rate into what one of your posts earns, has OpenAI score the campaign against your niche and saves every campaign to Google Sheets. The best get a clip brief in Telegram. - [Weekly AI search readiness audit with fix tickets in Google Sheets](https://automationbyexperts.com/n8n/site-ai-search-audit-fix-tickets-google-sheets): This n8n workflow audits your site every Monday at 7:00 for classic SEO, AI engine readiness (GEO) and answerability (AEO), compares every page with the previous week, and has OpenAI write a prioritized fix ticket for each page that dropped, sits under your floor or has a critical issue. - [Qualify target accounts from their job postings with OpenAI](https://automationbyexperts.com/n8n/job-postings-account-qualification-openai-google-sheets): This n8n workflow reads your target account list from Google Sheets every Monday at 8:00, pulls each company's open roles from the job board it really uses, has OpenAI score whether that hiring signals a need for what you sell, and sends a ready opener to Telegram for the accounts worth contacting. - [Score journalist requests and draft press pitches with OpenAI](https://automationbyexperts.com/n8n/journalist-request-pitches-openai-telegram): This n8n workflow collects open journalist source requests every morning at 8:00, has OpenAI score each one against your real expertise, saves every request to Google Sheets and sends a drafted pitch to Telegram for the few worth answering. - [Spitogatos.gr listing alerts in Telegram and Google Sheets](https://automationbyexperts.com/n8n/spitogatos-alerts-telegram-google-sheets): This n8n workflow checks Spitogatos.gr every morning at 8:00 for listings first posted in the last 24 hours in the areas you pick, saves each one to Google Sheets with its price per m² and the agent's phone number, and sends a summary to Telegram. - [Wallapop alerts in Telegram and Google Sheets](https://automationbyexperts.com/n8n/wallapop-alerts-telegram-google-sheets): This n8n workflow checks Wallapop every hour for new listings that match your keywords and price range, saves every new item to a Google Sheet, and sends the ones at or under your alert price to Telegram in one message. - [AutoTrader.ca used car alerts in Telegram and Google Sheets](https://automationbyexperts.com/n8n/autotrader-ca-car-alerts-telegram-google-sheets): This n8n workflow searches AutoTrader.ca every morning at 7:00 for cars listed in the last day that match your makes, budget, mileage and location, saves each new car to Google Sheets, and sends the ones priced below AutoTrader's market median to Telegram. - [Reddit buying-intent leads in Google Sheets and Slack](https://automationbyexperts.com/n8n/reddit-leads-google-sheets-slack): This n8n workflow searches Reddit every morning at 8:00 for posts and comments from people looking to buy what you sell, scores each one 0 to 100 for buying intent, saves every new lead to Google Sheets and posts the hottest ones to Slack as one digest. --- Part of [AutomationByExperts](https://automationbyexperts.com) - see [all n8n templates](https://automationbyexperts.com/n8n) or [request a new one](https://automationbyexperts.com/suggest).