{"product_id":"n8n-workflow-serpapi-gemini-product-ideas-to-postgres","title":"n8n Workflow: SerpApi + Gemini Product Ideas to Postgres","description":"\u003ch3\u003eTurn weekly product trend research into ready-to-review ideas—plus social proof and instant failure alerts\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automates weekly digital product ideation using \u003cstrong\u003eSerpApi\u003c\/strong\u003e (Google Trends) and \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e, saves the extracted product ideas into \u003cstrong\u003ePostgres\u003c\/strong\u003e, generates \u003cstrong\u003eThreads\u003c\/strong\u003e social-proof drafts from buyer testimonials via webhook, and notifies you on \u003cstrong\u003eTelegram\u003c\/strong\u003e if any execution fails.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns weekly on a schedule\u003c\/strong\u003e to keep your pipeline fresh.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches Google Trends data through SerpApi\u003c\/strong\u003e using a predefined AI digital product trends query.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses Google Gemini\u003c\/strong\u003e to extract \u003cstrong\u003ethree potential digital product ideas\u003c\/strong\u003e and the \u003cstrong\u003eproblems they solve\u003c\/strong\u003e from the trends results.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eInserts the ideas into Postgres\u003c\/strong\u003e (e.g., a \u003ccode\u003eproduct_ideas\u003c\/code\u003e table) for later review.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAccepts buyer testimonials via an incoming webhook\u003c\/strong\u003e and sends the review text to Gemini for sentiment analysis.\u003c\/li\u003e\n  \u003cli\u003eIf sentiment is positive, it \u003cstrong\u003egenerates a JSON-formatted social-proof draft for Threads\u003c\/strong\u003e and \u003cstrong\u003estores it in a Postgres content queue\u003c\/strong\u003e scheduled for \u003cstrong\u003eone day later\u003c\/strong\u003e (e.g., \u003ccode\u003econtent_queue\u003c\/code\u003e with \u003ccode\u003escheduled_at\u003c\/code\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends Telegram alerts on errors\u003c\/strong\u003e, including the workflow, node, and error details whenever an n8n execution fails.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators who want an automated \u003cstrong\u003eproduct ideation\u003c\/strong\u003e loop informed by real search trends.\u003c\/li\u003e\n  \u003cli\u003en8n users building a repeatable pipeline to turn \u003cstrong\u003etestimonials\u003c\/strong\u003e into \u003cstrong\u003esocial proof\u003c\/strong\u003e drafts for \u003cstrong\u003eThreads\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers who want robust operations with \u003cstrong\u003eTelegram failure notifications\u003c\/strong\u003e for reliability.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/Integrations:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003ewebhook\u003c\/code\u003e, \u003ccode\u003epostgres\u003c\/code\u003e, \u003ccode\u003etelegram\u003c\/code\u003e, \u003ccode\u003ehttp request\u003c\/code\u003e (plus a \u003cstrong\u003eSticky Note\u003c\/strong\u003e for workflow clarity).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCredentials required:\u003c\/strong\u003e Google Gemini API, Postgres, and a Telegram Bot.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSerpApi setup:\u003c\/strong\u003e add the SerpApi API key to the \u003ccode\u003ehttp request\u003c\/code\u003e (e.g., as \u003ccode\u003eapi_key=...\u003c\/code\u003e) and tune the trends query\/engine parameters if needed.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46132723351731,"sku":"N8N-20196","price":49.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/7Wu6IY21VA0HhSgNDYYhr_QVGrtctP.png?v=1790758845","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-serpapi-gemini-product-ideas-to-postgres","provider":"N8N Commerce","version":"1.0","type":"link"}