The Comms Stack
The Build by The Comms Stack
Media Path  ·  one-time

Paste a URL. Log the clip. Never touch a spreadsheet again.

Build a web app where you paste a news article URL, click one button, and the app fetches the article, analyzes it with Claude, and logs everything to a Google Sheet automatically.

⏱ 5 modules 🛠 Build: A press clip logging tool 💳 one-time
Already purchased? Sign in →

New here? Start with The First Build — it's free.

The Result

A complete press clip logging tool

Not a spreadsheet template. Not a clipping service. A working tool that turns any article URL into a logged, analyzed coverage entry.

What you'll walk away with:

  • ✓ Single-field URL input form
  • ✓ Article fetcher that pulls content from any news URL
  • ✓ Metadata extraction — headline, outlet, author, date
  • ✓ AI-powered analysis — summary, sentiment, share-of-voice tag
  • ✓ Key claims extracted from each article
  • ✓ Google Sheet with structured columns for your coverage log
  • ✓ Automatic logging — every clip goes straight to your Sheet
  • ✓ Runs on your computer
Curriculum

Five modules, start to finish

Each module builds one piece. By Module 5 you have a complete press clip logger running on your computer.

01
Build the URL Input Form
Single-field web app: paste a URL, click Log
02
Build the Article Fetcher
Script that pulls article content and extracts metadata
03
Build the Analysis Prompt
Claude prompt returning summary, sentiment, share-of-voice tag, key claims
04
Set Up the Google Sheet Connection
Google Sheet with correct columns + API connection
05
Wire the Full Pipeline and Publish
Live app: paste URL, get analysis, auto-logged to Sheet
Before You Start

What you need coming in

Ready to build your press clip logger?

One purchase. A tool that turns any article URL into a logged, analyzed coverage entry.

Enroll in this course →

one-time · yours to keep