PR AI Tool

Project Overview & Scope of Work

This proposal outlines the first phase MVP build for NewsJump, a tool designed to help users identify timely media opportunities and generate personalized pitch content using web scraping and GPT-based content generation.

Phase 1 focuses on validating the backend functionality and delivering working outputs to Google Sheets.

Start Date: August 1, 2025
First Draft ETA: October 15, 2025 (on or before)

Phase 1 – Core Functionality (Backend Only)

Goals

Build and test backend workflows: intake → scraping → GPT generation → Google Sheet output
Store user data and topics in a backend database (no user login flow yet)
Set up scheduled scraping and GPT generation
Enforce token usage caps to manage cost during beta
Deliver structured results via Google Sheets for internal and early-user testing

Key Features

Backend user table with a single user and topic tracking
Logic for form-style data intake (~10–15 fields)
Web scraping integration via third-party API (e.g., ContextualWeb, NewsAPI)
GPT-powered generation of 3–5 pitch suggestions and social posts per article
Google Sheet creation and auto-population per topic
Admin-only access to test functionality
Optional: Attempt to enrich reporter profiles with LinkedIn URLs via third-party services, where available.

Note: We can attempt to enrich scraped article data with reporter LinkedIn profiles using a 3rd-party data enrichment or search service (e.g., Clearbit, SerpApi, People Data Labs). This feature is not included and may incur additional API or development costs depending on the implementation method and coverage.

Note: Custom scraping solutions are possible in future phases but would require additional development time and budget.

Note: This phase does not include payment (Stripe) integration for users. This functionality can be added if requested in a future scope.

Deliverables Checklist

Backend data model (single user, topics, articles, content)
Admin input interface (for internal test use)
Topic intake logic (processing ~10–15 fields)
Third-party scraping API integration
GPT generation flow (pitch angles + social copy)
Google Sheet output logic with sheet-per-topic
Token cap handling and workflow control
Backend validation, error handling, and logging
Internal QA testing + bug resolution
Admin documentation or screencast of backend usage
Media Landscape Analysis and Client Talking Points Generator only as outlined in the Newsjump pdf

Costs

Estimated Hours: 90 hours
Estimated Fees: $15,750 based on an hourly rate of $175/hour split between 6 payments of $2,625 each over the course of six months with the first months’ payment in July.
Estimated Timeline: 8-12 weeks, based on 20-hour/week capacity
Additional hours billed at $175/hour

Tech Stack Overview

Layer	Primary Technology	Why This Option?
Backend	N8N	No-code backend ideal for rapid MVP build and scale-ready
Frontend	GoHighLevel OR Typeform	Visual front-end platform
Scraping	SerpApi, Apify	$55 / month total
AI/LLM	OpenAI GPT-4	Trusted for high-quality content generation via API. ~$.15/per run
Output	Google Sheets API	Familiar to users, easily shareable, zero onboarding curve