Freelance Writing Pitch & Submission Tracker in Google Sheets

The Freelance Writing Pitch and Submission Tracker keeps 15 data columns, 1 live pipeline card and 4 linked charts on a single Google Sheets page. It ships with 15 sample pitches you overwrite, 8 status stages from Drafting Pitch through to Published, and dropdown lists that stretch to 500 entries. Setup takes under 10 minutes: open the copy link in the PDF, replace the sample rows with your own pitches, and every card and chart refreshes as you type.

🌍 Join 8,400+ teams in 40+ countries using NextGenTemplates to replace paid SaaS tools with one-time-purchase Excel, Google Sheets, Power BI and HTML templates.

✅ Instant download · One-time payment · No subscription · No per-user fees · Lifetime access

🔑 Key Features of the Freelance Writing Pitch and Submission Tracker

📝 One log for every pitch – The data table carries 15 columns: Sub. ID, Pitch / Article Title, Publication / Client, Category, Pitch Date, Word Count, Fee Quoted, $ / Word, Status, Days Waiting, Payment, Amount Paid, Outstanding, Next Follow-Up and Notes. Ideas, live submissions and unpaid invoices sit in one place instead of three.

💰 Total Pipeline Value card – A single oversized card adds up the fees quoted across your logged pitches and shows the figure in thousands, so you know what the pipeline is worth before you decide whether to send another cold pitch this week.

📈 Four charts wired straight to the table – Pitch Count by Status, Pitch Count by Category, Fee Quoted by Pitch and Fee Quoted vs Amount Paid all read the data rows directly using the built-in Aggregate option. There are no hidden helper tables to maintain, so a new pitch appears in all four charts the moment you type it.

⏱️ Follow-up flags that chase for you – The Days Waiting column counts days since the pitch date, flags Follow Up after 14 days and Overdue after 21. A silent editor is the most expensive thing in freelance writing, and this column makes that silence visible.

🧮 Four formula columns you never type – Sub. ID, $ / Word (fee divided by word count), Days Waiting and Outstanding (fee minus amount paid) calculate themselves. Set Payment to Paid, enter the Amount Paid, and the Outstanding figure drops to zero on its own.

🔽 Dropdowns that grow with you – Publication / Client, Category, Status and Payment pull from the List tab, which is wired for 500 entries. Add a new market or a new beat on the List tab and it appears in the dropdown immediately, with no re-setup.

🎨 Colour-coded status and money columns – Category, Status and Payment render as coloured chips and the rate column shades by value, so a low-paying market or an overdue invoice is obvious at a glance.

💱 Currency you control – Amounts show in $ by default. Select the money columns and switch to ₹, € or £ through Format → Number whenever you work with overseas publications.

📦 What’s Inside the Freelance Writing Pitch & Submission Tracker

Page 1: Pitch and Submission Tracker

The working page. The Total Pipeline Value card sits top-left beside Pitch Count by Status, Pitch Count by Category, Fee Quoted by Pitch and Fee Quoted vs Amount Paid. Underneath, the 15-column entry table holds your pitches with coloured Category, Status and Payment chips, overdue flags in Days Waiting and a free-text Notes column for editor feedback.

Page 2: How to Use

A plain-English instructions tab written for this exact file. It covers replacing the sample rows, which columns calculate themselves, how the status flow runs from Pitched to Under Review, Accepted, Submitted and Published, how the List tab feeds the dropdowns, and the one-time ten-second step that turns those dropdowns into coloured chips.

Page 3: Explore More Templates

A reference tab listing recommended NextGenTemplates files by category and format, the popular template categories, and a WELCOME15 coupon code for 15% off your next purchase. A List tab behind these three pages stores the dropdown values for Publication / Client, Category, Status and Payment.

📊 Freelance Writing Pitch Tracker vs. Microsoft Excel vs. Paid Submission SaaS — Where This Fits

For writers who want a pitch pipeline and an unpaid-invoice list in the same view without paying a monthly subscription, this tracker sits in the sweet spot.

👥 Who This Template Is For — and Who It’s Not For

✅ Built for:

• Freelance journalists and feature writers juggling 10–60 live pitches across several publications
• Content writers and copywriters who bill per word and need the $ / Word column to compare markets
• Bloggers and newsletter writers pitching guest posts, sponsored articles and columns
• Writers chasing net-30 invoices who want the outstanding money visible next to the pitch that earned it

❌ Not for:

• Editorial teams that need per-user permissions, approval workflows and an audit trail
• Agencies wanting automatic invoicing, contracts or payment collection — this tracks money, it does not move it
• Anyone who cannot use a Google account, because the download is a copy link rather than a desktop file
• Writers looking for a market database; it records the publications you already pitch, it does not find new ones

⚙️ How to Use the Freelance Writing Pitch & Submission Tracker

1. Open the PDF in your download and click the “Make a copy” link. The file lands in your own Google Drive.
2. On the List tab, replace the sample publications and categories with the markets and beats you actually pitch.
3. Overwrite the 15 sample rows on the tracker page: title, publication, category, pitch date, word count, fee quoted, status, payment and next follow-up.
4. Leave Sub. ID, $ / Word, Days Waiting and Outstanding alone — they are formulas and fill themselves in.
5. Move the Status chip along as editors reply: Pitched, Under Review, Accepted, Submitted, Published.
6. When an invoice clears, set Payment to Paid and enter Amount Paid. Outstanding drops to zero and the charts redraw.
7. Follow the ten-second chip step on the How to Use tab if you want the coloured pills shown in the screenshots.

💼 Real-World Use Cases

Maya is a freelance technology journalist with four regular markets. She logs every cold pitch on Monday morning, sorts by Days Waiting and follows up on anything flagged Overdue. Her Pitch Count by Status chart tells her in one glance whether enough work sits in Under Review to cover next month.

Daniel writes long-form health features and bills per word. He uses the $ / Word column to compare what each publication really pays once the word count is counted, and quietly stopped pitching the two markets that sat at the bottom of that column for six months running.

Priya runs a one-person content studio for SaaS clients. She keeps commissioned articles and speculative pitches in the same tracker and uses the Outstanding column as her chase list — anything above zero with a Payment of Invoiced gets an email on the first of the month.

❓ Frequently Asked Questions

What does the Freelance Writing Pitch and Submission Tracker actually track?

It records the title, publication, category, pitch date, word count, quoted fee, rate per word, status, days waiting, payment state, amount paid, outstanding balance and next follow-up date for every pitch you send. One page holds the pipeline card, the four charts and the full entry table.

How long does setup take?

Under 10 minutes. Click the copy link in the PDF, swap the sample publications and categories on the List tab, then overwrite the 15 sample pitch rows. Every formula column, the pipeline card and all four charts update themselves from that point on.

Do I need Excel or any software to use it?

No. This is a Google Sheets template and it runs in any browser with a free Google account. There are no macros and nothing to install. If you prefer to work in a desktop workbook, browse the Google Sheets templates on NextGenTemplates.

Can I add my own publications, categories and statuses?

Yes. The Publication / Client, Category, Status and Payment dropdowns read from the List tab, which is wired for 500 entries per column. Type a new market or beat on that tab and it appears in the dropdown straight away, with no re-setup needed.

How does this compare to Duotrope or Submittable?

Those services are subscription submission databases aimed mainly at literary markets. This tracker is a one-time purchase that you own and edit, and it follows the money as well as the status — quoted fee, amount paid and outstanding balance sit in the same row as the pitch.

Can I share it with an editor or an assistant?

Yes. Because the file lives in your Google Drive you share it like any other Sheet, and collaborators see changes live. There are no per-user fees, and you decide whether each person can view, comment or edit.

👤 About the Author

Built by PK — Microsoft Certified Professional with 15+ years of Excel, Google Sheets and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels (@PKAnExcelExpert, @NextGenTemplates, @NeoTechNavigators). Every template is hand-built and tested before release.

🔗 Explore Related Templates

• Freelance Gig & Deadline Tracker in Google Sheets – the delivery side: once a pitch is accepted, this one tracks the deadline.
• Freelance Income & Expense Tracker in Google Sheets – where the paid fees land once they leave the Outstanding column.
• Blog Content & SEO Tracker in Google Sheets – for the articles you publish on your own site rather than pitch out.
• Proposal & Quote Tracker in Google Sheets – the same pipeline idea for client proposals instead of article pitches.
• Billable Hours & Time Tracker in Google Sheets – pairs with the $ / Word column when you want an hourly view too.

💎 Save more: the Tracker Toolkit – 12 Premium Templates bundles a dozen Excel and Google Sheets trackers in one purchase. Browse every tracker in the Google Sheets Trackers category.

New to Google Sheets dropdowns? Google’s own data validation guide explains how the List tab feeds each column.

📖 Click here to read the Detailed Blog Post

🎥 Visit our YouTube channel for step-by-step video tutorials

👉 YouTube.com/@NextGenTemplates

Watch the step-by-step video Demo:

📅 Last updated: September 2026