n8n Workflow: SerpApi + Gemini Product Ideas to Postgres

Turn weekly product trend research into ready-to-review ideas—plus social proof and instant failure alerts

This n8n workflow automates weekly digital product ideation using SerpApi (Google Trends) and Google Gemini, saves the extracted product ideas into Postgres, generates Threads social-proof drafts from buyer testimonials via webhook, and notifies you on Telegram if any execution fails.

What this workflow does

• Runs weekly on a schedule to keep your pipeline fresh.
• Fetches Google Trends data through SerpApi using a predefined AI digital product trends query.
• Uses Google Gemini to extract three potential digital product ideas and the problems they solve from the trends results.
• Inserts the ideas into Postgres (e.g., a product_ideas table) for later review.
• Accepts buyer testimonials via an incoming webhook and sends the review text to Gemini for sentiment analysis.
• If sentiment is positive, it generates a JSON-formatted social-proof draft for Threads and stores it in a Postgres content queue scheduled for one day later (e.g., content_queue with scheduled_at).
• Sends Telegram alerts on errors, including the workflow, node, and error details whenever an n8n execution fails.

Use cases

• SaaS operators who want an automated product ideation loop informed by real search trends.
• n8n users building a repeatable pipeline to turn testimonials into social proof drafts for Threads.
• Automation engineers who want robust operations with Telegram failure notifications for reliability.

Technical details

• Nodes/Integrations: if, webhook, postgres, telegram, http request (plus a Sticky Note for workflow clarity).
• Credentials required: Google Gemini API, Postgres, and a Telegram Bot.
• SerpApi setup: add the SerpApi API key to the http request (e.g., as api_key=...) and tune the trends query/engine parameters if needed.