January 22, 2026

WhatsApp + Google Docs: consistent support replies

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Support replies go off the rails fast. One teammate answers from memory, another copies an old message, and suddenly customers get three different versions of the same policy.

Support leads feel it in the queue. Small business owners notice it in reviews. And agency teams get stuck “babysitting” client inboxes. This WhatsApp reply automation turns a Google Doc into your single source of truth so every answer stays consistent.

You’ll see how the workflow pulls live info from Google Docs, generates a helpful answer with AI, sends it back on WhatsApp, and logs the conversation in Google Sheets for visibility.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: WhatsApp + Google Docs: consistent support replies

Click to explore

flowchart LR

    subgraph sg0["when message received Flow"]
        direction LR
        n0@{ icon: "mdi:robot", form: "rounded", label: "AI Agent", pos: "b", h: 48 }
        n1["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>cleanAnswer"]
        n2["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>24-hour window check"]
        n3@{ icon: "mdi:swap-horizontal", form: "rounded", label: "If", pos: "b", h: 48 }
        n4["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/whatsapp.svg' width='40' height='40' /></div><br/>Send Pre-approved Template M.."]
        n5["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/whatsapp.svg' width='40' height='40' /></div><br/>Send AI Agent's Answer"]
        n6@{ icon: "mdi:brain", form: "rounded", label: "Google Gemini Chat Model", pos: "b", h: 48 }
        n7["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/whatsapp.svg' width='40' height='40' /></div><br/>when message received"]
        n8["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/aitransform.svg' width='40' height='40' /></div><br/>Prepare Prompt"]
        n9@{ icon: "mdi:database", form: "rounded", label: "Google Sheets", pos: "b", h: 48 }
        n10@{ icon: "mdi:cog", form: "rounded", label: "Date & Time", pos: "b", h: 48 }
        n11@{ icon: "mdi:cog", form: "rounded", label: "company's knowledge", pos: "b", h: 48 }
        n12@{ icon: "mdi:memory", form: "rounded", label: "Simple Memory", pos: "b", h: 48 }
        n3 --> n1
        n3 --> n4
        n0 --> n10
        n10 --> n9
        n1 --> n5
        n9 --> n2
        n12 -.-> n0
        n8 --> n0
        n11 --> n8
        n2 --> n3
        n7 --> n11
        n6 -.-> n0
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n7 trigger
    class n0 ai
    class n6 aiModel
    class n12 ai
    class n3 decision
    class n9 database
    class n1,n2 code
    classDef customIcon fill:none,stroke:none
    class n1,n2,n4,n5,n7,n8 customIcon

The Problem: Support Answers Drift (and Customers Notice)

When your “truth” lives in someone’s head or a messy chat history, support becomes a game of telephone. A customer asks, “Are you open today?” and the reply depends on who’s holding the phone. Then policies change (refunds, class schedules, delivery zones), but the old answers keep getting reused because they’re already written and easy to copy. It’s not just time. It’s trust, and it’s the constant mental load of double-checking what’s current before you hit send. Honestly, that’s exhausting.

It adds up fast. Here’s where it breaks down in real life.

Support agents waste about 1–2 hours a day hunting for the “latest” policy or FAQ answer.
Copy-paste replies slowly mutate, so your refund policy can sound different every week.
Customers ask date-based questions, and humans miss context like closures or limited-time rules.
Without conversation logs, you can’t audit what was promised when a dispute pops up.

The Solution: WhatsApp Replies Powered by a Live Google Doc

This workflow turns your Google Doc into the brain of your WhatsApp support line. A customer sends a free-form question to your WhatsApp Business number, and n8n immediately pulls the latest content from your chosen Google Doc (your policies, FAQ, service list, schedule, anything). It also adds today’s date and the customer’s message, then hands that combined context to an AI “support agent” so the response is specific and timely, not generic. Once the reply is generated, the workflow cleans up the text, checks a WhatsApp timing rule (the 24-hour support window), and sends the right message back. Every interaction gets logged to Google Sheets so you can review conversations, track common questions, and keep a simple audit trail.

The workflow starts with an incoming WhatsApp message. Then it retrieves your knowledge doc, assembles a prompt with the doc plus today’s date, and generates a helpful answer using an AI model (OpenAI ChatGPT or Google Gemini). Finally, it sends the reply on WhatsApp and writes the details to Google Sheets.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

Pulls the latest answers directly from a Google Doc every time.
Builds a date-aware prompt from the doc plus the customer’s question.
Generates a natural-language reply using an AI agent (OpenAI Chat Model or Gemini).
Logs every chat with timestamps to Google Sheets for reporting.

Save about 1–2 hours per day for a busy WhatsApp inbox.
Customers get one consistent answer, even across multiple staff members.
Policy updates take seconds because you only edit the Google Doc.
Fewer “let me check and get back to you” messages during peak times.
Clear chat history in Sheets, which helps with training and disputes.

Example: What This Looks Like

Say you get about 30 WhatsApp questions a day, and each one takes roughly 4 minutes to find the right info, copy it, and rewrite it politely. That’s about 2 hours daily. With this workflow, the “work” becomes: the customer asks, n8n pulls the Google Doc, the AI drafts the reply, and you only intervene when something needs a human. The hands-on time drops to a quick review for edge cases, which for many teams is closer to 10–15 minutes total.

What You’ll Need

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
WhatsApp Cloud API (Meta) to receive and send messages
Google Docs (via Google account) to store your support knowledge
OpenAI API key or Google Gemini access (get it from your OpenAI or Google AI Studio account)

Skill level: Intermediate. You’ll connect accounts, paste a Doc ID, and configure the WhatsApp webhook without writing an app.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

A WhatsApp message arrives. The Incoming WhatsApp Trigger catches the customer’s question as soon as it hits your WhatsApp Business number.

Your Google Doc is fetched live. The workflow pulls the current contents of your selected support document, so updates go live the moment you change the doc.

The AI creates the best answer for today. n8n assembles prompt text using the document, the customer’s message, and today’s date/time, then the Support AI Orchestrator uses an AI model (OpenAI Chat Model or Gemini) to draft the reply with session memory for continuity.

The reply is sent and everything is tracked. The text is sanitized, the 24-hour WhatsApp window is validated, the right WhatsApp message is dispatched (or a reopen template is sent), and the details are written to Google Sheets with a timestamp.

You can easily modify the Google Doc structure to match your brand, then adjust the prompt to enforce tone, disclaimers, or escalation rules. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the WhatsApp Trigger

Set up the workflow entry point so incoming WhatsApp messages start the automation.

Add and open Incoming WhatsApp Trigger.
Credential Required: Connect your whatsAppTriggerApi credentials.
Ensure Updates includes messages so the workflow receives incoming texts.

Step 2: Connect Knowledge Source and Build the Prompt

Retrieve your knowledge base document and assemble a prompt for the AI assistant.

Configure Retrieve Knowledge Doc with Operation set to get and Document URL set to =[YOUR_ID].
Credential Required: Connect your Google Docs credentials in Retrieve Knowledge Doc.
Open Assemble Prompt Text and keep the provided jsCode that builds finalPrompt using the Google Doc and incoming WhatsApp message.
Confirm the prompt structure returns only finalPrompt as shown in the node.

Step 3: Set Up the AI Orchestration and Memory

Connect the Gemini model and memory so the AI can respond consistently and contextually.

Open Support AI Orchestrator and verify the Text field is ={{ $json.finalPrompt }}.
In Gemini Chat Engine, confirm the Model Name is models/gemini-2.5-flash-preview-04-17-thinking.
Credential Required: Connect your Google Gemini credentials in Gemini Chat Engine.
Configure Session Memory Buffer with Session Key set to ={{ $('Incoming WhatsApp Trigger').item.json.contacts[0].wa_id }} and Session ID Type set to customKey.
Ensure Session Memory Buffer is connected to Support AI Orchestrator as an AI memory tool (credentials, if required, must be added to the parent node).

Step 4: Log Responses with Timestamps

Generate a timestamp and write user questions and AI answers to Google Sheets.

Configure Generate Timestamp with default settings to create a timestamp field.
In Update Response Log, set Operation to appendOrUpdate.
Set Document ID to [YOUR_ID] and Sheet Name to Sheet1.
Map columns exactly as shown: User → ={{ $('Incoming WhatsApp Trigger').item.json.messages[0].from }}, Message → ={{ $('Incoming WhatsApp Trigger').item.json.messages[0].text.body }}, Response → ={{ $('Support AI Orchestrator').item.json.output }}, Timestamp → ={{ $json.currentDate }}.
Credential Required: Connect your Google Sheets credentials in Update Response Log.

Step 5: Validate the 24-Hour Window and Send Replies

Check WhatsApp’s 24-hour window and route replies accordingly, then sanitize and dispatch the AI response.

In Validate 24h Window, keep the provided JavaScript that calculates withinWindow from the incoming message timestamp.
Configure Window Decision with the condition ={{ $json.withinWindow }} set to true.
When the condition is true, the flow continues to Sanitize Reply Text and then to Dispatch AI Reply with Text Body set to ={{ $json.answer }}.
When the condition is false, Window Decision routes to Send Reopen Template using Template hello_world|en_US.
In both WhatsApp send nodes, set Phone Number ID to your value ([YOUR_ID]) and Recipient Phone Number to ={{ $('Incoming WhatsApp Trigger').item.json.contacts[0].wa_id }}.
Credential Required: Add WhatsApp credentials to both Dispatch AI Reply and Send Reopen Template.

⚠️ Common Pitfall: If [YOUR_ID] isn’t replaced in Dispatch AI Reply or Send Reopen Template, WhatsApp messages will fail to send.

Step 6: Test and Activate Your Workflow

Validate the end-to-end flow and then enable the workflow for production use.

Click Execute Workflow and send a test WhatsApp message to your connected number.
Confirm the flow follows Incoming WhatsApp Trigger → Retrieve Knowledge Doc → Assemble Prompt Text → Support AI Orchestrator → Generate Timestamp → Update Response Log → Validate 24h Window → Window Decision.
Verify successful execution: a reply is sent via Dispatch AI Reply or the template is sent via Send Reopen Template, and a row appears in Google Sheets.
Toggle the workflow to Active to start handling live WhatsApp messages.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

WhatsApp Cloud API credentials and webhook settings are fragile. If replies suddenly stop, check your Meta app webhook subscriptions and token validity first.
If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
Google Docs access often fails due to missing permissions on the Doc itself. Confirm the connected Google account can open the Doc in a normal browser session, then re-check the Doc ID in the Google Docs node.

Frequently Asked Questions

How long does it take to set up this WhatsApp reply automation automation?

About 30–60 minutes if your WhatsApp Cloud API and Google access are ready.

Do I need coding skills to automate WhatsApp reply automation?

No. You’ll mostly paste IDs, connect accounts, and test a few sample questions.

Is n8n free to use for this WhatsApp reply automation workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in AI usage (often a few cents per day for small inboxes) and WhatsApp Cloud API messaging costs depending on your volume.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I customize this WhatsApp reply automation workflow for human handoff?

Yes, but plan it intentionally. You can route “can’t answer” cases by adding a branch after the Support AI Orchestrator and before Dispatch AI Reply, then send an internal alert in Telegram and reply to the customer with a short handoff message. Common customizations include adding business-hour rules, forcing the AI to cite sections from the Google Doc, and tagging conversations in Google Sheets for follow-up.

Why is my WhatsApp connection failing in this workflow?

Usually it’s an expired token or a webhook mismatch in your Meta WhatsApp Cloud API setup. Re-check the callback URL, verify token, and that your app is subscribed to the right WhatsApp events. If messages arrive but replies fail, look for missing permissions or template issues on the Send Reopen Template node. Rate limits can also bite if you test with lots of messages in a short burst.

How many conversations can this WhatsApp reply automation automation handle?

A few hundred per day is realistic for most small setups, and more if you self-host and size your server appropriately.

Is this WhatsApp reply automation automation better than using Zapier or Make?

Often, yes, because this isn’t a simple “send message” Zap. You’re pulling a live Google Doc, assembling a prompt, running an AI agent with memory, validating the WhatsApp 24-hour window, and logging everything to Sheets. n8n handles branching and more complex logic without turning your bill into a surprise. Zapier or Make can still work if you keep it very basic, but they get awkward once you add “if this, then that” rules and context assembly. If you want help choosing, Talk to an automation expert.

Once this is running, your Google Doc becomes the only place to update support truth. The workflow handles the repetitive replies and logging, so you can focus on the tricky conversations that actually need a person.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": "",
"meta": {
"instanceId": "2ac56ce871c1c43479da3b33e2e3d8945b5b1485cac7804c68790d9f5b6b2bfd"
},
"name": "Automated WhatsApp Support Workflow",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-4966",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
20
],
"parameters": {
"color": 7,
"width": 1210,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "02f761e2-83c4-488b-91f4-f4ae11b15c00",
"name": "Support AI Orchestrator",
"type": "@n8n/n8n-nodes-langchain.agent",
"maxTries": 5,
"position": [
230,
215
],
"parameters": {
"text": "={{ $json.finalPrompt }}\n\n\n",
"options": {
"systemMessage": "You are [Company]\u2019s support assistant for Black Ball Sporting Club.\n\u2022 Do NOT include any preamble such as \u201cBased on the document you provided\u201d or \u201cOkay, [Name].\u201d Just jump straight to the answer.\n* don't ever start your response with\"based on the document you provided\" , or \"According to the document\", don't mention any documents at all , also don't mention today's date unless you asked\n"
},
"promptType": "define",
"hasOutputParser": true
},
"retryOnFail": false,
"typeVersion": 1.7,
"alwaysOutputData": true,
"waitBetweenTries": null
},
{
"id": "57ecb397-5772-4db3-8a5a-ce28a4e01e63",
"name": "Sanitize Reply Text",
"type": "n8n-nodes-base.code",
"position": [
1095,
570
],
"parameters": {
"jsCode": "// cleanAnswer \u2013 run once per item\nlet txt = $('Support AI Orchestrator').first().json.output || '';\n\n// 1. Remove bold / italic / strike markers\ntxt = txt.replace(/[*_~]+/g, '');\n\n// 2. Convert [Texto](https://url) \u2192 Texto https://url\ntxt = txt.replace(/\\[([^\\]]+)\\]\\((https?:\\/\\/[^\\s)]+)\\)/g, '$1 $2');\n\n// 3. Collapse 3+ blank lines\ntxt = txt.replace(/\\n{3,}/g, '\\n\\n').trim();\n\n// 4. Remove the unwanted source-reference preamble\ntxt = txt.replace(/^.*?based on the document you provided[,:]?\\s*/i, '');\n\nreturn [{ json: { answer: txt } }];\n"
},
"typeVersion": 2
},
{
"id": "d70cf8b1-8c24-44f2-9b37-5205b130cff2",
"name": "Validate 24h Window",
"type": "n8n-nodes-base.code",
"position": [
855,
390
],
"parameters": {
"jsCode": "// within24h?  \u2013 run once per item\n// Meta (WhatsApp) timestamp arrives as seconds since epoch\nconst lastTs = Number($('Incoming WhatsApp Trigger').first().json.messages[0].timestamp) * 1000;   // \u2192 ms\nconst withinWindow = Date.now() - lastTs < 24 * 60 * 60 * 1000;\n\nreturn [{ json: { withinWindow, answer: $json.answer, userId: $json.userId } }];"
},
"typeVersion": 2
},
{
"id": "66c83de5-413a-440f-804e-15b137beb873",
"name": "Window Decision",
"type": "n8n-nodes-base.if",
"position": [
1090,
405
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "d33e218e-a49a-49ed-9c6b-55b9ea0b0dbb",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $json.withinWindow }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "80fc3049-8474-4392-9e04-f5686eb82687",
"name": "Send Reopen Template",
"type": "n8n-nodes-base.whatsApp",
"position": [
520,
640
],
"webhookId": "ef6de86f-66df-4586-bd75-2056626d5474",
"parameters": {
"template": "hello_world|en_US",
"phoneNumberId": "[YOUR_ID]",
"recipientPhoneNumber": "={{ $('Incoming WhatsApp Trigger').item.json.contacts[0].wa_id }}"
},
"typeVersion": 1
},
{
"id": "d77ae0ae-c332-4030-8c77-8ea44c56c9a8",
"name": "Dispatch AI Reply",
"type": "n8n-nodes-base.whatsApp",
"position": [
860,
610
],
"webhookId": "8da6eeda-31ec-448a-9d75-2d5dbc5f10f9",
"parameters": {
"textBody": "={{ $json.answer }}",
"operation": "send",
"phoneNumberId": "=[YOUR_ID]",
"additionalFields": [],
"recipientPhoneNumber": "={{ $('Incoming WhatsApp Trigger').item.json.contacts[0].wa_id }}"
},
"typeVersion": 1
},
{
"id": "c9d931c3-d88c-4d15-b8fe-787327c0200a",
"name": "Gemini Chat Engine",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
0,
120
],
"parameters": {
"options": [],
"modelName": "models/gemini-2.5-flash-preview-04-17-thinking"
},
"typeVersion": 1
},
{
"id": "630ac52d-1d65-408e-b614-17a97bddab10",
"name": "Incoming WhatsApp Trigger",
"type": "n8n-nodes-base.whatsAppTrigger",
"position": [
1110,
190
],
"webhookId": "6b645b70-61db-4d4d-af47-2f39295cf196",
"parameters": {
"options": [],
"updates": [
"messages"
]
},
"credentials": {
"whatsAppTriggerApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "df46b528-cbbd-49c2-9b83-4402ef0c8ac7",
"name": "Assemble Prompt Text",
"type": "n8n-nodes-base.aiTransform",
"position": [
525,
140
],
"parameters": {
"jsCode": "const googleDocs = $input.all().map((item) => item.json);\nconst whatsappMessages = $(\"Incoming WhatsApp Trigger\")\n  .all()\n  .map((item) => item.json);\n\nconst date = new Date();\nconst formattedDate = `${date.getMonth() + 1} ${date.getDate()}, ${date.getFullYear()}`;\n\nconst docText = googleDocs[0].content.split(\"\\n\").join(\" \");\n\nconst body = whatsappMessages[0].messages[0].text.body;\n\nconst finalPrompt = `Today's date is: ${formattedDate}\\n\\n${docText}\\n\\nUser's question:\\n${body}`;\n\nreturn { finalPrompt };\n",
"instructions": "Write code to:\n\u2022 Get today\u2019s date formatted \u201cMonth Day, Year\u201d\n\u2022 Extract the Google Doc\u2019s plain text by joining its body.content textRuns\n\u2022 Extract the WhatsApp message from messages[0].text.body\n\u2022 Build a field finalPrompt exactly as:\n\nvbnet\nCopy\nEdit\nToday's date is: [date]\n\n[doc text]\n\nUser's question:\n[body]\n\u2022 Return finalPrompt only.",
"codeGeneratedForPrompt": "Write code to:\n\u2022 Get today\u2019s date formatted \u201cMonth Day, Year\u201d\n\u2022 Extract the Google Doc\u2019s plain text by joining its body.content textRuns\n\u2022 Extract the WhatsApp message from messages[0].text.body\n\u2022 Build a field finalPrompt exactly as:\n\nvbnet\nCopy\nEdit\nToday's date is: [date]\n\n[doc text]\n\nUser's question:\n[body]\n\u2022 Return finalPrompt only."
},
"typeVersion": 1
},
{
"id": "19de46dc-add8-4cad-81a9-6e5b341f1f33",
"name": "Update Response Log",
"type": "n8n-nodes-base.googleSheets",
"position": [
540,
410
],
"parameters": {
"columns": {
"value": {
"User": "={{ $('Incoming WhatsApp Trigger').item.json.messages[0].from }}",
"Message": "={{ $('Incoming WhatsApp Trigger').item.json.messages[0].text.body }}",
"Response": "={{ $('Support AI Orchestrator').item.json.output }}",
"Timestamp": "={{ $json.currentDate }}"
},
"schema": [
{
"id": "Timestamp",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Timestamp",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "User",
"type": "string",
"display": true,
"required": false,
"displayName": "User",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Message",
"type": "string",
"display": true,
"required": false,
"displayName": "Message",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Response",
"type": "string",
"display": true,
"required": false,
"displayName": "Response",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Column 5",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Column 5",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Column 6",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Column 6",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Column 7",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Column 7",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Column 8",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Column 8",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Column 9",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Column 9",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Column 10",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Column 10",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Column 11",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Column 11",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Column 12",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Column 12",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Column 13",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Column 13",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Column 14",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Column 14",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Column 15",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Column 15",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Column 16",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Column 16",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Column 17",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Column 17",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Column 18",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Column 18",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Column 19",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Column 19",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Column 20",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Column 20",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Column 21",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Column 21",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Column 22",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Column 22",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Column 23",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Column 23",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Column 24",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Column 24",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Column 25",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Column 25",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Column 26",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Column 26",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Timestamp"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Chat Logs"
}
},
"typeVersion": 4.6
},
{
"id": "b622392e-65dc-4d27-a5f9-d27ea57aae61",
"name": "Generate Timestamp",
"type": "n8n-nodes-base.dateTime",
"position": [
280,
375
],
"parameters": {
"options": []
},
"typeVersion": 2
},
{
"id": "8f4a786b-fc6d-4e2f-b8df-c605475afc81",
"name": "Retrieve Knowledge Doc",
"type": "n8n-nodes-base.googleDocs",
"position": [
710,
210
],
"parameters": {
"operation": "get",
"documentURL": "=[YOUR_ID]"
},
"typeVersion": 2
},
{
"id": "a6de89dd-ada0-432c-9f8e-ece38264ad81",
"name": "Session Memory Buffer",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"position": [
30,
320
],
"parameters": {
"sessionKey": "={{ $('Incoming WhatsApp Trigger').item.json.contacts[0].wa_id }}",
"sessionIdType": "customKey"
},
"typeVersion": 1.3
}
],
"active": false,
"pinData": [],
"settings": {
"executionOrder": "v1"
},
"versionId": "",
"connections": {
"Window Decision": {
"main": [
[
{
"node": "Sanitize Reply Text",
"type": "main",
"index": 0
}
],
[
{
"node": "Send Reopen Template",
"type": "main",
"index": 0
}
]
]
},
"Support AI Orchestrator": {
"main": [
[
{
"node": "Generate Timestamp",
"type": "main",
"index": 0
}
]
]
},
"Generate Timestamp": {
"main": [
[
{
"node": "Update Response Log",
"type": "main",
"index": 0
}
]
]
},
"Sanitize Reply Text": {
"main": [
[
{
"node": "Dispatch AI Reply",
"type": "main",
"index": 0
}
]
]
},
"Update Response Log": {
"main": [
[
{
"node": "Validate 24h Window",
"type": "main",
"index": 0
}
]
]
},
"Session Memory Buffer": {
"ai_memory": [
[
{
"node": "Support AI Orchestrator",
"type": "ai_memory",
"index": 0
}
]
]
},
"Assemble Prompt Text": {
"main": [
[
{
"node": "Support AI Orchestrator",
"type": "main",
"index": 0
}
]
]
},
"Retrieve Knowledge Doc": {
"main": [
[
{
"node": "Assemble Prompt Text",
"type": "main",
"index": 0
}
]
]
},
"Validate 24h Window": {
"main": [
[
{
"node": "Window Decision",
"type": "main",
"index": 0
}
]
]
},
"Incoming WhatsApp Trigger": {
"main": [
[
{
"node": "Retrieve Knowledge Doc",
"type": "main",
"index": 0
}
]
]
},
"Gemini Chat Engine": {
"ai_languageModel": [
[
{
"node": "Support AI Orchestrator",
"type": "ai_languageModel",
"index": 0
}
]
]
}
}
}