ChatGPT-Style AI for Production Plans with Anthropic + Google Sheets

Turn your Google Sheets production plan into a ChatGPT-style status assistant—powered by Anthropic

This n8n workflow gives you a chat-based AI assistant that reads your production plan from Google Sheets and answers questions like what’s late, what’s due, and what’s in the backlog. If you want, it can also propose and confirm edits before updating order rows in your sheet.

What this workflow does

• Receives chat messages via an n8n Chat trigger.
• Uses an Anthropic chat model with short-term conversation memory and a system prompt that injects today’s date plus your production-plan column definitions.
• Reads the latest rows from a specified Google Sheets production-plan spreadsheet before answering any question.
• Interprets requests to:
  • Report status (based on current sheet values)
  • Compute what’s late and by how many days
  • Sum quantities across matching products using the sheet’s current data
• For order changes, it requires confirmation by stating the exact proposed edit (order, field, old value, new value).
• After you confirm in a later message, it updates the matching order row in Google Sheets.

Use cases

• Ask, “Which production orders are late today, and by how many days?”
• Get quick backlog summaries: “Total quantity for Product X with Priority Y.”
• Support day-to-day planning: propose a due-date change, confirm it, then auto-update Google Sheets.

Technical details

• n8nnodes-langchainchat trigger (chat-based interface)
• Anthropic chat model via n8nnodes-langchainlm chat anthropic
• Conversation memory using n8nnodes-langchainmemory buffer window
• Google Sheets integration with read and (optionally) update using Google Sheets tool nodes
• Requires your sheet to include: Order, Product, Quantity, Due date, Station, Priority, Status (or adjust the system prompt to match your headers)