Contact person: Business Client

Phone:Show

Email:Show

Location: Los Angeles, United States

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"I need a developer to fix, complete, and stabilize a web app hosted on Replit. The app helps users find relevant podcasts, YouTube channels, and Spotify podcasts for guest appearances. It must gather contact info, save everything in a shared database, and manage outreach and follow ups.

Most of the app is already built. It needs testing, repair, and a clean data pipeline.

WHAT THE APP MUST DO

User Accounts
Secure signup and login
Password recovery
Persistent sessions
User roles (user and admin)
Automatic upgrade when a subscription is purchased

Search Input
Users choose niche or topic, language, and platforms
Platforms include YouTube, regular podcasts, and Spotify podcasts

AI Discovery System
Use AI to interpret the niche
Search across YouTube, podcast directories, and Spotify
Return relevant shows
Rank and clean results
Save results to the database
Display them to the user

Show Data Needed
Show title
Platform
URL
Description
Language
Niche
Audience indicators (if available)
Host or creator name

Contact Extraction
Extract emails, websites, submission forms, social links, and host names
Scan descriptions, pages, and social links
Use AI fallback when text is messy or unclear

EMAIL OUTREACH REQUIREMENTS

All outreach emails must appear as coming directly from the user’s own email address.
This requires SMTP or Google or Microsoft OAuth sending.
The system email must never be the sender.

Users must be able to send
individual outreach emails
bulk outreach emails
custom templates

Users must be able to set
limits on how many emails can be sent
follow up timing for no replies (one month, two months, or user choice)

The system must track
first outreach
follow ups
reply status
booked status
notes

If a show is marked booked, it must not be emailed again unless the user manually chooses to.

DATABASE BEHAVIOR

Store all discovered shows and contacts
Store user searches
Store outreach history
Store subscription status
Prevent duplicate shows
Fill missing fields without overwriting better info
Always save results before displaying them

Users must be able to edit show info, update contacts, and mark shows as contacted, booked, no reply, or do not contact.

ADMIN FEATURES

View all users
Change roles
Suspend accounts
Monitor AI usage
Monitor search usage
Edit pricing
View payments
Edit subscription tiers
Manage and clean show and contact data

SUBSCRIPTIONS AND PAYMENTS

Stripe checkout
PayPal checkout
Monthly and yearly plans (yearly is discounted)
Automatic upgrade after payment
Admin can change pricing and plan features

SECURITY REQUIREMENTS

Hashed passwords
Secure session handling
Rate limiting
Input validation
Role-based access

WHAT IS CURRENTLY BROKEN

The AI search pipeline is unstable
Sometimes returns no or irrelevant results
Fails silently on Replit

Contact extraction is unreliable
Emails and links are missed
Data does not save consistently
Duplicates appear

Database pipeline is incomplete
Shows not always saved
Contacts not linked correctly

Authentication and subscription flow need cleanup
Payment process is clunky
Account upgrades inconsistent

WHAT I NEED FROM YOU

Review the entire Replit codebase
Fix or rebuild the AI discovery pipeline
Integrate Spotify podcast discovery properly
Fix contact extraction
Fix database saving and deduplication
Repair authentication and role system
Implement sending emails from the user’s own email address
Finalize Stripe and PayPal subscription flow
Complete admin dashboard
Run a full end to end test with me (signup, search, save data, send outreach, upgrade subscription)" (client-provided description)