# AI-powered customer email support for e-commerce with Pinecone: n8n workflow

> Started by a clock, and works across Gmail. It puts OpenRouter behind a retrieval step, so answers are drawn from documents you supply rather than from the...

Source: https://millionrounds.com/workflow/ai-powered-customer-email-support-for-e-commerce-with-pineco (Millionrounds; every figure on the page links to its filing or article)

[Automation library](https://millionrounds.com/workflows) · [E-commerce](https://millionrounds.com/workflows?category=E-commerce#library)

# AI-powered customer email support for e-commerce with Pinecone

Started by a clock, and works across Gmail. It puts OpenRouter behind a retrieval step, so answers are drawn from documents you supply rather than from the model alone. 21 steps, 3 branches, 1 loop or waits: large, and worth reading before you trust it with anything live.

Large Calls a model: OpenRouter Retrieval

[Download free](https://millionrounds.com/login?next=%2Fapp%2Fworkflow%2Fai-powered-customer-email-support-for-e-commerce-with-pineco)

**21 steps** Large: read it before trusting it with anything live

**3** Branches: places the flow splits

**1** Loop or waits

**1** Service it connects to

## The flow

Starts it 2 Model 7 Logic 5 Service 7

The steps in the order they run, from what starts it.

- 1 **OpenRouter Chat Model2** Lm Chat Open Router *Model*
- 2 **OpenRouter Chat Model3** Lm Chat Open Router *Model*
- 3 **Gmail Trigger** Gmail trigger *Starts it*
- 4 **Knowledge base** Http Request Tool *Service*
- 5 **Schedule Trigger** Schedule trigger *Starts it*
- 6 **Postgres Chat Memory** Memory Postgres Chat *Model*
- 7 **OpenRouter Chat Model** Lm Chat Open Router *Model*
- 8 **Historical customer emails** Http Request Tool *Service*
- 9 **Product SKU** Http Request Tool *Service*
- 10 **AI Agent1** Agent *Model*
- 11 **Structured Output Parser1** Output Parser Structured *Model*
- 12 **Loop Over Items** Split In Batches *Logic*
- 13 **Get many messages** Gmail *Service*
- 14 **Text Classifier** Text Classifier *Model*
- 15 **Send a message** Gmail *Service*
- 16 **blacklist** If *Logic*
- 17 **blacklist1** If *Logic*
- 18 **Transform to Q&A** Code *Logic*
- 19 **If** If *Logic*
- 20 **Convert to File** Convert To File *Service*
- 21 **Upload files to Pinecone1** Http Request *Service*

## How it's built

- **Starts on:** A clock
- **Steps:** 21, with 3 branches, 1 loop or waits
- **Size:** Large: read it before trusting it with anything live
- **Connects to:** Gmail
- **Model:** OpenRouter
- **Retrieval:** Answers are drawn from documents you supply, not from the model alone

## Questions

What does it need to run?

An n8n account, plus your own Gmail account, and a key for OpenRouter. You connect your own accounts after importing it; none are included.

What starts it?

It starts on a clock.

Does it use AI?

Yes. It calls OpenRouter. Its answers draw on documents you give it, not on the model alone. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Take your time. At 21 steps it is large: read it before trusting it with anything live.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

**Before you run it**

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 21 steps before you point it at anything that matters.

## Run it in n8n

- **Create your n8n account** Free to start. n8n is where the workflow runs. [Create an n8n account ↗](https://millionrounds.com/n8n)
- **Download the workflow** Free with a Millionrounds account. [Download free](https://millionrounds.com/login?next=%2Fapp%2Fworkflow%2Fai-powered-customer-email-support-for-e-commerce-with-pineco)
- **Paste it into n8n** Open a new workflow in n8n and paste. Then connect your own accounts.

Stored with the author's traces removed: canvas notes, instance identifiers, saved credential names and any live document they had left behind.

## Connects to

Each opens the other workflows that use it.

[Gmail](https://millionrounds.com/workflows?service=Gmail#library)

## Workflows like it

Also e-commerce, with the same services where possible, closest in size first.

- [**AI agent for transportation orders management with OpenAI** 21 steps · calls a model · Gmail, Google Sheets](https://millionrounds.com/workflow/ai-agent-for-transportation-orders-management-with-openai)
- [**Monitor e-commerce price changes with Decodo Scraper** 21 steps · calls a model · Gmail, Google Sheets](https://millionrounds.com/workflow/monitor-e-commerce-price-changes-with-decodo-scraper)
- [**E-commerce bestseller video generator with Algolia** 21 steps · Gmail](https://millionrounds.com/workflow/e-commerce-bestseller-video-generator-with-algolia)
- [**3D Product Video Generator from 2D Image for E-Commerce Stores** 20 steps · Gmail, Google Drive](https://millionrounds.com/workflow/3d-product-video-generator-from-2d-image-for-e-commerce-stor)
- [**Automate inventory reordering and vendor bill approvals** 20 steps · Gmail, Slack](https://millionrounds.com/workflow/automate-inventory-reordering-and-vendor-bill-approvals)
- [**Manage inventory reorders with Google Sheets and Slack** 22 steps · Gmail, Google Sheets](https://millionrounds.com/workflow/manage-inventory-reorders-with-google-sheets-and-slack)