{"product_id":"chatgpt-style-ai-for-production-plans-with-anthropic-google-sheets","title":"ChatGPT-Style AI for Production Plans with Anthropic + Google Sheets","description":"\u003ch3\u003eTurn your Google Sheets production plan into a ChatGPT-style status assistant—powered by Anthropic\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow gives you a chat-based AI assistant that reads your production plan from Google Sheets and answers questions like \u003cstrong\u003ewhat’s late, what’s due, and what’s in the backlog\u003c\/strong\u003e. If you want, it can also \u003cstrong\u003epropose and confirm edits\u003c\/strong\u003e before updating order rows in your sheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives chat messages\u003c\/strong\u003e via an \u003cem\u003en8n Chat trigger\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003eUses an \u003cstrong\u003eAnthropic chat model\u003c\/strong\u003e with short-term \u003cstrong\u003econversation memory\u003c\/strong\u003e and a system prompt that injects \u003cstrong\u003etoday’s date\u003c\/strong\u003e plus your production-plan column definitions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads the latest rows\u003c\/strong\u003e from a specified \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e production-plan spreadsheet before answering any question.\u003c\/li\u003e\n  \u003cli\u003eInterprets requests to:\n    \u003cul\u003e\n      \u003cli\u003eReport \u003cstrong\u003estatus\u003c\/strong\u003e (based on current sheet values)\u003c\/li\u003e\n      \u003cli\u003eCompute \u003cstrong\u003ewhat’s late\u003c\/strong\u003e and \u003cstrong\u003eby how many days\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eSum quantities\u003c\/strong\u003e across matching products using the sheet’s current data\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003eFor order changes, it requires \u003cstrong\u003econfirmation\u003c\/strong\u003e by stating the exact proposed edit (order, field, old value, new value).\u003c\/li\u003e\n  \u003cli\u003eAfter you confirm in a later message, it \u003cstrong\u003eupdates the matching order row\u003c\/strong\u003e in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAsk, “Which production orders are late today, and by how many days?”\u003c\/li\u003e\n  \u003cli\u003eGet quick backlog summaries: “Total quantity for Product X with Priority Y.”\u003c\/li\u003e\n  \u003cli\u003eSupport day-to-day planning: propose a due-date change, confirm it, then auto-update Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8nnodes-langchainchat trigger\u003c\/strong\u003e (chat-based interface)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAnthropic chat model\u003c\/strong\u003e via \u003cem\u003en8nnodes-langchainlm chat anthropic\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConversation memory\u003c\/strong\u003e using \u003cem\u003en8nnodes-langchainmemory buffer window\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets integration\u003c\/strong\u003e with read and (optionally) update using Google Sheets tool nodes\u003c\/li\u003e\n  \u003cli\u003eRequires your sheet to include: \u003cstrong\u003eOrder, Product, Quantity, Due date, Station, Priority, Status\u003c\/strong\u003e (or adjust the system prompt to match your headers)\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45785650692275,"sku":"N8N-17915","price":49.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/5RQRNll6uH1c0_GV2zqs5_iiP4FJED.png?v=1786180094","url":"https:\/\/buyflowscripts.com\/products\/chatgpt-style-ai-for-production-plans-with-anthropic-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}