# Shopping Assistant with Long-Term Memory

**Category:** E-commerce  
**Tools:** n8n, OpenAI, Zep Memory  
**Nodes:** 8  
**Built by:** Forgent Systems

A store chatbot that remembers each customer's preferences and past conversations. It recommends products, checks orders and handles returns in a natural way.

![Workflow](preview.webp)

## How it works

1. A customer chats with the assistant.
2. Long-term memory recalls their past interactions.
3. Orders, inventory and the return policy are read from Google Sheets.
4. A personalized answer is generated.

## Use cases

- Fashion and lifestyle stores
- Repeat-purchase brands
- Personal shopping experiences

## Data setup

**Google Sheets** (tab: columns)

- **Shopping Assistant → Order Tracking**: _(columns as used in the nodes)_
- **Shopping Assistant → Product Details**: _(columns as used in the nodes)_
- **Shopping Assistant → Return Policy**: _(columns as used in the nodes)_

## Setup

1. In n8n open **Workflows → Import from File** and choose `workflow.json`.
2. Connect these credentials:
   - Google Sheets account
   - OpenAI account
   - Zep account
3. Point the Sheets / Airtable / Drive / Slack nodes at your own resources (structure above).
4. Replace placeholder emails, phone numbers and `YOUR-FORM-ID` links with your own.
5. Times use the America/New_York timezone and dates use MM/DD/YYYY. Adjust if needed.
6. Run a test execution, then activate.

## Nodes

- **AI Agent** — `@n8n/n8n-nodes-langchain.agent`
- **OpenAI Chat Model** — `@n8n/n8n-nodes-langchain.lmChatOpenAi`
- **When chat message received** — `@n8n/n8n-nodes-langchain.chatTrigger`
- **Sticky Note** — `n8n-nodes-base.stickyNote`
- **Zep** — `@n8n/n8n-nodes-langchain.memoryZep`
- **Get_Orders** — `n8n-nodes-base.googleSheetsTool`
- **Get_Inventory** — `n8n-nodes-base.googleSheetsTool`
- **Get_ReturnPolicy** — `n8n-nodes-base.googleSheetsTool`
