Turn your chat into a helpful store assistant for phone case orders. Shoppers can ask about stock, pick a case, and share their address in one conversation. Orders and inventory updates go straight into Google Sheets so your team stays in sync.

The flow listens for a new chat message, routes it to an AI support agent, and keeps short term memory to follow the conversation. The agent uses OpenAI to understand intent and extract details like phone model, case ID, and address. It calls Google Sheets to check stock, adds a new order row when the buyer confirms, and updates the sold count to keep inventory accurate. Replies come back to the customer in the same chat thread.

Setup is simple. Connect your Google Sheets and OpenAI accounts, point the nodes to your sheet and tabs, and confirm column names like Phone Model, Case ID, Address, and Sold. Expect faster replies, less typing, and cleaner data. Great for small online stores, marketplace sellers, and pop up shops that track stock in Google Sheets.

• Chat trigger starts a conversation when a customer sends a message and greets them automatically.
• OpenAI Chat Model understands questions and extracts details like phone model, case ID, and address.
• Simple Memory keeps short context so follow up questions make sense.
• Google Sheets GetStock filters by Phone Model to show available cases and quantities.
• Place order appends a new row in your Orders tab with customer details and selected case.
• Update Stock writes the sold count using Case ID so inventory stays correct.
• Agent selects the right tool at each step and replies in the same chat.

• Reduce manual order entry from 15 minutes to 1 minute
• Automate up to 90 percent of routine stock checks
• Improve data accuracy by removing copy paste errors
• Handle 3 to 5 times more chat requests with the same team
• Connect chat replies and Google Sheets updates in one place

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets and OpenAI. See the Tools Required section above for links to create accounts with these services.
3. Open the OpenAI Chat Model node. In the Credential to connect with dropdown, click Create new credential. Add your OpenAI API key from your OpenAI account API page and save.
4. Open each Google Sheets node GetStock, Place order, and Update Stock. In the Credential to connect with dropdown, click Create new credential and sign in with the Google account that owns or can access the target spreadsheet.
5. In every Google Sheets node, choose the correct Document and Sheet tab from the dropdowns. Confirm the sheet has header columns for Phone Model, Case ID, Address, Quantity and Sold as used by the nodes.
6. Open the Support Agent node and review the system message. If your column names differ, update the tool descriptions so the agent requests and writes the right fields.
7. In the When chat message received node, keep response mode as lastNode so the AI reply is sent back to the chat. Save the workflow.
8. Test inventory lookup: open the chat URL from the trigger node, type your phone model, and check that the agent lists matching cases. If nothing returns, verify the Phone Model values in your Inventory tab.
9. Test order creation: ask to buy a case, provide address details, and confirm. Check the Orders tab for a new row and confirm the Inventory tab shows an updated Sold value for the Case ID.
10. Troubleshoot common issues: if rows do not update, make sure your Google account has edit access to the sheet. If the wrong row updates, confirm the Case ID is unique and spelled the same in both tabs. If details are missing, add a short example in the system message showing the fields the agent should capture.