PR Contacts Spreadsheet Template

Your PR Contacts database at a glance

This template gives communications teams a dedicated system to manage journalist relationships, track media outlets, and log pitch history across campaigns.

Native relationships connect each journalist in the Contacts table directly to their publication in Outlets, while tying every communication in Interactions to the right pitch campaign.

Built-in intelligence automatically enriches journalist backgrounds, generates compelling pitch email drafts, and analyzes interaction sentiment directly inside your tables.

When pitch history gets trapped across monthly tabs and inbox threads

Managing media relations in a spreadsheet quickly breaks down as new campaign tabs multiply, contact emails go stale, and team members accidentally overwrite journalist interaction notes.

What a structured database changes

A structured database enforces clean field types so press release attachments, LinkedIn URLs, and follow-up dates never turn into corrupt text.

Instead of copy-pasting outlet details or relying on brittle sheet lookups, linked records keep every journalist tied to their publication and logged interactions.

This is exactly what Softr Databases are designed for, giving your PR team a central hub that stays organized as your media list scales.

What you can do with this template

Run your entire outreach workflow from drafting campaign angles in Pitches to logging outreach notes and follow-up flags in Interactions.

Use Database AI agents to research outlet overviews via live web search, suggest subject lines, and gauge sentiment on journalist responses automatically.

The system is ready to use immediately, keeping your entire media relations strategy clean, accessible, and structured.

Who is this PR Contacts database for

This template helps public relations and marketing teams maintain structured media lists and consistent outreach.

• PR Agencies: Manage multiple media campaigns, outlet directories, and journalist relationships across diverse client accounts.
• In-House Comms Teams: Centralize journalist interactions, maintain accurate contact histories, and coordinate pitches without stepping on teammates' toes.
• Startup Founders: Track early press outreach, organize media coverage, and ensure timely follow-ups with key tech reporters.
• Event Marketers: Build targeted press invite lists, log RSVPs, and manage media accreditation seamlessly.

How to take it further

Customize this database by adding custom outlet categories, tailored coverage beats, or unique pitch status stages to match your agency's exact outreach methodology in seconds.

Import your existing media lists via CSV or connect directly through an API to instantly populate your journalist directory and communication history.

When your team is ready, build an app on top of your database using Softr's AI Co-Builder to create custom journalist portals, campaign submission forms, and team dashboards.

Configure granular users and permissions so PR managers oversee all campaigns while external contributors or associates only view their assigned contacts and logged pitches.