OpenAI + Google Sheets, instant product answers

You get the same product question again and again, and it still steals time. Someone asks for a size, a color, a price, and you end up digging through a sheet (or guessing) while the customer drifts away.

Support leads feel it first. But store owners and marketing teams running DMs deal with the same mess. This Sheets product answers automation replies fast, using the inventory you already keep in Google Sheets, so you stop losing sales to slow or wrong answers.

This workflow turns a plain customer message into a clean, accurate reply with stock and pricing. You’ll see how it works, what you need, and where teams usually trip up.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: OpenAI + Google Sheets, instant product answers

Click to explore

flowchart LR

    subgraph sg0["Parse Request AI Flow"]
        direction LR
        n0@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model", pos: "b", h: 48 }
        n1@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model1", pos: "b", h: 48 }
        n2["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/webhook.dark.svg' width='40' height='40' /></div><br/>Receive Request"]
        n3@{ icon: "mdi:robot", form: "rounded", label: "Parse Request AI", pos: "b", h: 48 }
        n4["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Extract Data"]
        n5@{ icon: "mdi:database", form: "rounded", label: "Product Database", pos: "b", h: 48 }
        n6["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Filter Products"]
        n7@{ icon: "mdi:robot", form: "rounded", label: "AI Manager", pos: "b", h: 48 }
        n8["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/webhook.dark.svg' width='40' height='40' /></div><br/>Send Response"]
        n7 --> n8
        n4 --> n5
        n6 --> n7
        n2 --> n3
        n3 --> n4
        n5 --> n6
        n0 -.-> n3
        n1 -.-> n7
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n3,n7 ai
    class n0,n1 aiModel
    class n5 database
    class n2,n8 api
    class n4,n6 code
    classDef customIcon fill:none,stroke:none
    class n2,n4,n6,n8 customIcon

The Problem: Fast product questions, slow manual answers

Product questions arrive in bursts. A customer messages “Do you have Nike Air Max in size 40?” and expects a real answer right now, not “Let me check.” Manually, you read the message, interpret what they meant (model vs. style name, size format, color wording), search your inventory sheet, then write a reply that sounds human. Do that 30 times a day and you are stuck in a loop. Worse, one wrong “in stock” message creates refunds, awkward follow-ups, and churn you never see on a dashboard.

None of these alone is the problem. Together, they are.

Copy-pasting from Google Sheets turns into about 1–2 hours a day once messages stack up.
People describe products differently, so “Air Max 40” might be size 40, model 40, or both.
A rushed reply leads to wrong pricing or quantity, and you spend extra time walking it back.
When you are busy, messages sit unanswered, which means the customer keeps shopping elsewhere.

The Solution: AI answers powered by your live inventory sheet

This n8n workflow acts like a product assistant that reads customer language, turns it into structured product details, checks your Google Sheets inventory, then replies with a friendly, accurate response. It starts with a webhook message from wherever you receive inquiries (website chat, Instagram DM via your connector, Telegram, or another messaging tool). OpenAI extracts key fields like brand, model, size, and color from the text. Then the workflow searches your inventory sheet, filters for the best match, and generates a response that includes stock count and price. Finally, it sends the reply back through the webhook response so the customer gets an answer without you touching anything.

The workflow starts when an inquiry hits your webhook endpoint. AI parses the message, then your Google Sheets becomes the “source of truth” for availability and pricing. After a quick match-and-filter step, OpenAI drafts the final reply and n8n sends it back instantly.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

It turns messy customer messages into clean product fields (brand, model, size, color).
It queries your Google Sheets inventory for likely matches.
It filters results so the reply uses the best product row, not a random partial match.
It drafts and sends a ready-to-use response back through the webhook.

Most stores get replies out in under a minute instead of waiting hours.
You stop “double handling” the same DM because the first answer is usually correct.
Fewer wrong stock replies, which means fewer awkward apologies and cancellations.
Support load drops, even when your catalog grows past 1,000 items.
Customers feel taken care of, so they are more likely to buy now.

Example: What This Looks Like

Say you get about 25 product questions a day across chat and DMs. Manually, even a quick “read → search sheet → reply” takes maybe 4 minutes each, so that’s roughly 100 minutes daily. With this workflow, you spend about 10 minutes setting up the sheet and prompt style, then each question is handled automatically: a few seconds to receive the webhook, some processing time, and the customer gets the answer. That’s about 1.5 hours back every day, and the replies stay consistent.

What You’ll Need

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Google Sheets for your product inventory table.
OpenAI to parse questions and draft replies.
OpenAI API key (get it from your OpenAI dashboard).

Skill level: Intermediate. You’ll connect accounts, edit a few fields, and confirm your sheet columns match the workflow.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

A customer message triggers the workflow. Your messaging source hits an n8n webhook with the customer’s text (for example, “Do you have Nike Air Max 90 size 40?”).

The request gets translated into usable data. OpenAI parses the message and a mapping step reshapes it into the fields your inventory search can use without guessing.

Your inventory sheet is searched and filtered. n8n reads the Google Sheet, then applies match logic to find the most relevant product row (and avoids replying with the wrong model just because it shares a keyword).

A response is generated and sent back instantly. OpenAI writes a short, friendly reply with price and quantity, and n8n returns it via “Respond to Webhook” so the customer sees it in the same conversation.

You can easily modify the reply style to match your brand voice based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Webhook Trigger

Set up the inbound request endpoint that receives client inquiries and starts the workflow.

Add and open Incoming Webhook Trigger.
Set Path to /shoe-orders.
Set HTTP Method to POST.
Set Response Mode to responseNode so replies are handled by Webhook Reply Sender.

Tip: After saving the workflow once, copy the generated webhook URL from Incoming Webhook Trigger and use it in your client app or form.

Step 2: Connect Google Sheets

Connect the inventory sheet so the workflow can search available products.

Add and open Inventory Sheet Reader.
Credential Required: Connect your googleSheetsOAuth2Api credentials.
Set Document to the spreadsheet containing inventory (replace [YOUR_ID] with your file ID).
Set Sheet Name to gid=0 (cached as Лист1 in the workflow).

⚠️ Common Pitfall: Ensure your sheet has columns named Brand, Model, Size, and Color, as Product Match Filter uses these exact field names.

Step 3: Set Up Parsing and Matching Logic

Parse the incoming message into structured data and filter inventory to matched products.

Open AI Request Parser and set Text to {{ $('Incoming Webhook Trigger').first().json.body.message }}.
Confirm AI Request Parser has Has Output Parser enabled and the system prompt returns valid JSON.
Open Parsed Data Mapper and keep the JavaScript that maps brand, model, size, and color from parsed JSON.
Open Product Match Filter and keep the JavaScript filter that matches against Parsed Data Mapper fields.

Tip: If your inventory uses different column names, update the matching fields in Product Match Filter to avoid empty results.

Step 4: Configure AI Response Generation

Use OpenAI to generate a friendly reply based on matched inventory data.

Open OpenAI Chat Engine and set the Model to gpt-3.5-turbo.
Credential Required: Connect your openAiApi credentials in OpenAI Chat Engine (this is the language model for AI Request Parser).
Open OpenAI Chat Engine 2 and set the Model to gpt-4.
Credential Required: Connect your openAiApi credentials in OpenAI Chat Engine 2 (this is the language model for Response Generator AI).
Open Response Generator AI and set Text to {{ $('Incoming Webhook Trigger').first().json.body.message }}.

⚠️ Common Pitfall: Do not add credentials directly inside AI Request Parser or Response Generator AI. They inherit credentials from OpenAI Chat Engine and OpenAI Chat Engine 2.

Step 5: Configure the Webhook Reply

Return the AI-generated response to the webhook caller.

Add and open Webhook Reply Sender.
Set Respond With to text.
Set Response Body to {{ $json.text }}.

Step 6: Test and Activate Your Workflow

Validate the full execution chain and enable it for production use.

Click Execute Workflow and send a POST request to the webhook URL with a body containing {"message":"Do you have Nike Air Max size 40 in black?"}.
Verify AI Request Parser outputs JSON and Parsed Data Mapper produces the expected fields.
Confirm Inventory Sheet Reader loads rows and Product Match Filter outputs matching items.
Check that Webhook Reply Sender returns a friendly response in the webhook call.
Toggle the workflow to Active to enable live processing.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

Google Sheets access can fail if the connected Google account loses permission to the file. If results suddenly come back empty, check the sheet sharing settings and the Google credential in n8n first.
If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
OpenAI prompts ship generic by default. Add your brand voice (and rules like “always include price and quantity”) early or you will keep rewriting replies by hand.

Frequently Asked Questions

How long does it take to set up this Sheets product answers automation?

About 30–45 minutes if your sheet is ready.

Do I need coding skills to automate product answers?

No coding required. You’ll mostly connect accounts and make sure your Google Sheet columns match what the workflow expects.

Is n8n free to use for this Sheets product answers workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI API usage, which is usually a few cents for lots of short chats.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I customize this Sheets product answers workflow for a different catalog format?

Yes, but you’ll want to align the “Parsed Data Mapper” mapping and the “Inventory Sheet Reader” columns. Common customizations include adding SKU, adding gender or category fields, changing size formats (EU/US/UK), and rewriting the “Response Generator AI” prompt so it matches your tone and policies.

Why is my Google Sheets connection failing in this workflow?

Usually it’s permissions or an expired credential. Reconnect the Google Sheets credential in n8n, confirm the file is shared with the connected account, and make sure the sheet/tab name hasn’t changed since you first configured it.

How many product questions can this Sheets product answers automation handle?

For most small stores, hundreds of inquiries a day is fine, and catalogs of 1,000+ items work well. On n8n Cloud, your limit is mostly your plan’s monthly executions; if you self-host, it depends on your server. The practical bottleneck is usually your Google Sheets read speed and OpenAI rate limits, so if you see slowdowns, cache popular items or reduce how much of the sheet you fetch per request.

Is this Sheets product answers automation better than using Zapier or Make?

Often, yes, if you care about reliable parsing, match logic, and controlling costs at higher volume. n8n makes it easier to add branching rules (like “if no exact match, suggest alternatives”), and self-hosting is a big deal when inquiries spike. Zapier or Make can be simpler for a basic “lookup row, send reply” flow, but the moment you need smarter matching, it gets messy. The other honest point: you’ll get better results when you tune the AI prompt, and n8n encourages that kind of iteration. Talk to an automation expert if you’re not sure which fits.

Set this up once and your catalog starts answering for you. Honestly, it’s a relief when “Do you have this in size 40?” stops being an interruption and becomes an automated win.

OpenAI + Google Sheets, instant product answers

How This Automation Works

n8n Workflow Template: OpenAI + Google Sheets, instant product answers

The Problem: Fast product questions, slow manual answers