Saving Chat History to Supabase

🎁  Download Part 1 Here: https://go.n8n.io/app-creation-workflow
🎁  Download Part 2 Here: https://go.n8n.io/app-creation-workflow-prompts

Doc Williams shows you how to build a complete SaaS application that scrapes app store reviews, analyzes them with AI, and helps you identify million-dollar opportunities in underserved markets.

The System:
This workflow automatically scrapes app reviews, lets users chat with the data using Pine Cone's new assistant node, and even generates Product Requirement Documents (PRDs) to help you build better apps. The entire system uses Fire Crawl for scraping, n8n for automation, Pine Cone for AI chat, Lovable for the front-end, and Stripe for payments.

Tech Stack:

n8n (automation & workflows)
Pine Cone Assistant (AI chat with your data)
Lovable (front-end development)
Supabase (database)
Fire Crawl (review scraping)
Stripe (payments)
OpenAI (language model)

What You'll Learn:
• How to scrape and analyze app store reviews to find profitable gaps in the market
• Setting up Pine Cone's Assistant Node with n8n (no complicated vectorization needed!)
• Embedding AI chat directly into your SaaS application
• Saving chat history to a database with Supabase
• Building the entire front-end with Lovable AI
• Adding Stripe payments to monetize your app
• Real example: Oil Field Calendar app making $50k+/month

0:00 - Introduction & Overview
0:22 - What You'll Learn Today
1:00 - The App Review System Demo
2:16 - How to Find Profitable App Opportunities
3:52 - Live Demo: Oil Field Calendar Example
5:30 - Using AI Chat with Pine Cone
9:30 - Embedding the Chat Feature in Your SaaS
10:17 - Tech Stack Overview
11:57 - Inside the n8n Workflow
15:00 - Understanding Pine Cone Assistant Node
17:30 - Top K and Snippet Size Explained
19:47 - Data Shape and Configuration Tips
22:09 - Metadata Filters Setup
22:56 - Saving Chat History to Database
24:26 - Generating Product Requirements (PRDs)
26:40 - Full Tech Stack Breakdown
29:52 - Setting Up with Lovable & Stripe
30:30 - Template & Prompt Availability
31:14 - Future Opportunities & Market Ideas
33:26 - Closing Thoughts & Where to Connect

Get 30% Off n8n Cloud Starter or Pro Plans!
Want to get started with n8n? Visit n8n.io/pricing and use code 2025-N8N-PODCAST-729C416E at checkout for 30% off your first month or year.