GPT for Google Sheets, Docs AI, Slides, Forms

PR Pitch Mail Merge from Google Sheets and Gmail

Send personalized PR pitches from Google Sheets through Gmail. Organize media contacts, story angles, custom notes, follow-ups, and responsible outreach with Mail Merge.

PR Pitch Mail Merge from Google Sheets and Gmail

PR outreach depends on relevance. A journalist, creator, analyst, or newsletter editor should not receive a generic blast that ignores their beat. If your media list lives in Google Sheets, Mail Merge for Gmail and Google Sheets helps you keep each contact’s outlet, beat, recent article, story angle, and follow-up status visible before sending personalized Gmail pitches.

Send personalized PR pitches from Sheets →

Use this workflow for focused announcements, founder stories, product launches, research reports, event invites, and expert-source pitches where each recipient deserves context.

Why use Google Sheets for PR outreach

A spreadsheet-based PR workflow is helpful when:

  • your media list includes beats, outlets, notes, and custom angles;
  • you want to review personalization before sending;
  • outreach should come from Gmail as a human note, not a newsletter blast;
  • your team needs one place for status, replies, follow-up dates, and exclusions;
  • you are sending a focused campaign to relevant contacts.

Mail merge does not make irrelevant pitches acceptable. It simply helps you manage accurate personalization at a practical scale.

Build a media outreach Sheet

Create columns that make relevance visible.

Column Example Why it matters
email editor@example.com Recipient address
first_name Alex Greeting
outlet SaaS Weekly Publication context
beat startup productivity Relevance filter
recent_article AI tools roundup Personal opening
story_angle Sheets-based outreach workflow Pitch focus
asset_link https://... Press kit or report
follow_up_date 2026-06-12 Respectful cadence
status ready Review state

Remove contacts that are not relevant, suppress people who asked not to be contacted, and keep internal notes separate from the email copy if they are not meant for recipients.

Write PR pitch templates with specific context

Product launch pitch

Subject: Story idea for :

Hi ,

I saw your recent piece on and thought this might fit your coverage.

We are announcing . The angle that may be most relevant for is .

Here is a short background link: .

If it is useful, I can send more details or connect you with .

Best,

Research or data pitch

Subject: Data point for your coverage

Hi ,

Given your coverage of , I wanted to share a concise data point: .

The full context is here: . Happy to help if it fits a future story.

Thanks,

Send PR outreach responsibly

  1. Start with a relevant list. Do not send to unrelated beats just because an email address is available.
  2. Write one clear story angle. Avoid stuffing the pitch with every feature, quote, and claim.
  3. Preview rows carefully. Bad outlet names or wrong article references damage credibility.
  4. Send internal tests. Check links, quoted names, subject lines, and signature.
  5. Use respectful follow-ups. One concise follow-up is often enough; honor opt-outs and no-interest replies.
  6. Track outcomes in Sheets. Use status fields for sent, replied, interested, declined, bounced, and do-not-contact.

Use Mail Merge for Gmail and Sheets for media outreach →

PR pitch examples from a Sheet

Founder story

Use founder_name, why_now, personal_context, and story_angle. Keep the pitch factual and avoid inflated claims.

Product announcement

Use launch_date, category, customer_use_case, and asset_link. Link to a concise press page or background document.

Expert source pitch

Use expert_name, credential, topic, and availability. Make the source relevant to the journalist’s beat.

Event or webinar invitation

Use event_topic, speaker, date, and registration_link. Send only to contacts who cover the topic.

Compliance and deliverability cautions

Use relevant, permission-aware contact lists, avoid scraped or purchased lists when they are not appropriate, respect opt-outs, keep claims factual, test every send, respect Gmail and Google Workspace limits, and monitor bounces and replies. Personalization should reflect genuine relevance, not fake familiarity.

PR pitch mail merge FAQ

Can I use mail merge for PR pitches?

Yes, for focused and relevant outreach. Use Google Sheets to manage beats, outlets, custom angles, and status, then send personalized Gmail pitches after review.

What should I personalize in a PR pitch?

Personalize the recipient name, outlet, beat, relevant recent work, story angle, and the most useful asset link. Avoid pretending to know the recipient personally if you do not.

How many follow-ups should I send?

Use a respectful cadence and avoid repeated pressure. Track replies and opt-outs in the Sheet so people are not over-contacted.

Should I include attachments in PR pitches?

Often a link to a press kit or background page is cleaner than a large attachment. If you use attachments, test the workflow and confirm each file is correct.

How do I avoid generic PR blasts?

Segment by beat, remove poor-fit contacts, write a specific angle for each segment, and preview several personalized rows before sending.

Send better PR outreach from the Sheet you already use

If your media list and pitch notes live in Google Sheets, Mail Merge for Gmail and Sheets can help you send focused, personalized Gmail pitches with clearer review and follow-up tracking.

Start a PR pitch mail merge →