AutomationMart
Home/Browse/Hardware store product assistant with PostgreSQL & Google Gemini AI
n8n

Hardware store product assistant with PostgreSQL & Google Gemini AI

n8nn8n12 modulesv1.0
Gemini

AI-Powered Hardware Store Assistant with PostgreSQL & MCP Supercharge your customer service with this conversational AI agent! This n8n workflow provides a complete solution for a hardware store chatbot that connects to a PostgreSQL database in real-time. It uses Google Gemini for natural language understanding and the powerful MCP (My Credential Provider) nodes to securely expose database operations as tools for the AI agent. ✨ Key Features πŸ’¬ Conversational Product Queries: Allow users to ask

At a glance

Hardware store product assistant with PostgreSQL & Google Gemini AI is a ready-made n8n workflow you import as a workflow JSON file β€” no build required. It connects Gemini. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Gemini
Modules
12
Price
Free
Version
v1.0
Hardware store product assistant with PostgreSQL & Google Gemini AI workflow diagram

About this workflow

AI-Powered Hardware Store Assistant with PostgreSQL & MCP Supercharge your customer service with this conversational AI agent! This n8n workflow provides a complete solution for a hardware store chatbot that connects to a PostgreSQL database in real-time. It uses Google Gemini for natural language understanding and the powerful MCP (My Credential Provider) nodes to securely expose database operations as tools for the AI agent. ✨ Key Features πŸ’¬ Conversational Product Queries: Allow users to ask for products by name, category, description, or even technical notes. πŸ“¦ Real-time Inventory & Pricing: The agent fetches live data directly from your PostgreSQL database, ensuring accurate stock and price information. πŸ’° Automatic Quote Generation: Ask the agent to create a detailed quote for a list of materials, and it will calculate quantities and totals. 🧠 Smart Project Advice: The agent is primed with a system message to act as an expert, helping users calculate materials for projects (e.g., "How much drywall do I need for a 10x12 foot room?"). πŸ› οΈ Tech Stack & Core Components Technologies Used πŸ—„οΈ PostgreSQL: For storing and managing product data. ✨ Google Gemini API: The large language model that powers the agent's conversational abilities. πŸ”— MCP (My Credential Provider): Securely exposes database queries as callable tools without exposing credentials directly to the agent. n8n Nodes Used @n8n/n8n-nodes-langchain.agent: The core AI agent that orchestrates the workflow. @n8n/n8n-nodes-langchain.chatTrigger: To start a conversation. @n8n/n8n-nodes-langchain.lmChatGoogleGemini: The connection to the Google Gemini model. n8n-nodes-base.postgresTool: Individual nodes for querying products by ID, name, category, etc. @n8n/n8n-nodes-langchain.mcpTrigger: Exposes the PostgresTools. @n8n/n8n-nodes-langchain.mcpClientTool: Allows the AI agent to consume the tools exposed by the MCP Trigger. πŸš€ How to Get Started: Setup & Configuration Follow these steps to get your AI assistant up and running: Configure your Database: This template assumes a PostgreSQL database named bdferreteria with a productos table. You can adapt the PostgresTool nodes to match your own schema. Set up Credentials: Create and assign your PostgreSQL credentials to each of the six PostgresTool nodes. Create and assign your Google Gemini API credentials in the Language Model (Google Gemini) node. Review the System Prompt: The main AI Agent node has a detailed system prompt that defines its persona and capabilities. Feel free to customize it to better fit your business's tone and product line. Activate the Workflow: Save and activate the workflow. You can now start interacting with your new AI sales assistant through the chat interface! πŸ’‘ Use Cases & Customization While designed for a hardware store, this template is highly adaptable. You can use it for: Any e-commerce store with a product database (e.g., electronics, clothing, books). An internal IT support bot that queries a database of company assets. A booking assistant that checks availability in a database of appointments or reservations.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n β†’ click the menu β†’ Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Automated Discord chatbot for chat interaction in channel using Gemini 2.0 Flash

A Discord bot that responds to mentions by sending messages to n8n workflows and returning the responses. Connects Discord conversations with custom automations, APIs, and AI services through n8n. Full guide on: Discord Bot Summary Overview The Discord bot listens for mentions, forwards questions to an n8n workflow, processes responses, and replies in Discord. This workflow is intended for all Discord users who want to offer AI interactions with their respective channels. What do you need? - Yo

Free

Uploading Fliki videos to YouTube

This Make.com scenario automates the end-to-end process of uploading Fliki-generated videos to YouTube. When a video render is completed in Fliki, the scenario triggers automatically. It then uses Google Gemini AI to generate a compelling, SEO-friendly video title based on the content. After that, it downloads the MP4 video file via an HTTP module, converting the URL into a binary buffer format suitable for YouTube. Finally, the video is uploaded directly to your YouTube channel, complete with t

Free

Automate meeting notes summaries with Gemini AI & Slack notifications

Meeting Notes Summarizer & Slack Notifier Easily keep your team aligned by summarizing meeting notes, extracting action items, and delivering them directly to Slack. πŸš€ What This Workflow Does - ⏰ Triggers on a schedule to fetch meeting data from your note-taking tool - πŸ“„ Retrieves meeting summaries and action items using the MeetGeek API - πŸ€– Uses Google Gemini AI to generate concise summaries and action points - 🎨 Restructures the output into Slack Block Kit format - πŸ“’ Sends daily Slack noti

Free

Copy viral reels with Gemini AI

Video Guide I prepared a detailed guide that shows the whole process of building an AI tool to analyze Instagram Reels using n8n. []( Youtube Link Who is this for? This workflow is ideal for social media analysts, digital marketers, and content creators who want to leverage data-driven insights from their Instagram Reels. It's particularly useful for those looking to automate the analysis of video performance to inform strategy and content creation. What problem does this workflow solve? Analyzi

Free

Process multiple media files in Telegram with Gemini AI & PostgreSQL database

Telegram AI Assistant with Multi-File Media Group Handling, Smart File Processing & PostgreSQL Integration > AI-powered Telegram bot for text, voice, video, documents & media β€” with database-driven grouping and Telegram-safe formatting. --- πŸ“‹ Description This n8n template creates a next-generation Telegram AI assistant πŸ§ πŸ’¬ capable of handling text messages, media files, and documents with advanced processing, PostgreSQL integration, and AI-powered responses. It is desi

Free

Document Q&A chatbot with Gemini AI and Supabase vector search for Telegram

This template creates a Telegram AI Assistant that answers questions based on your documents, powered by Google Gemini and Supabase. Key features include Intelligent HTML Post-processing for rich formatting in Telegram and Adaptive Message Chunking to handle long text responses. πŸ“Ή Watch the Bot in Action [](

Free

Jotform automated commerce sync: Telegram confirmation & Zoho invoice

This workflow is designed to automate your e-commerce order processing by instantly syncing new Jotform submissions with your internal systems and immediately notifying the customer on Telegram. 🧩 What Problem Does It Solve? Businesses manually processing orders face delays in: Sending order confirmations to customers. Updating internal sales logs (CRM/Google Sheets). Creating necessary financial documents (Invoices). This workflow solves these by: Instant Confirmation: Automatically sending

Free

Generate viral Bigfoot vlog videos with Veo 3

Transform simple ideas into viral-ready Bigfoot vlogs! This automated workflow creates charming 8-scene video content featuring "Sam" the Bigfoot - a lovable, outdoorsy character inspired by popular YouTube adventure channels. How It Works The workflow transforms your creative concept into professional video content through three automated stages: 1. Story Generation - AI creates an 8-scene narrative arc featuring Sam the Bigfoot, complete with character-consistent dialogue and engaging pl

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint β€” instant download
  • Setup guide PDF included
  • 5 downloads Β· valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

β‚Ή2,499/ session
3 hrs Β· video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free