Skip to content
Storing chat respon...
 
Notifications
Clear all

Storing chat responses in Google Sheets

5 Posts
4 Users
0 Reactions
3 Views
aryanbt
(@aryanbt)
Posts: 2
New Member
Topic starter
 

Hi team,

I’m using callin.io self-hosted (v1.89.2) to build an AI chatbot workflow. The flow is working perfectly until I add the Google Sheets node to log the conversation. Here’s the setup and the issue:


Working Setup (no Google Sheets):

  1. Webhook node (receives user message from HTML chat UI)
  2. LangChain Q&A node (calls Ollama, returns response)
  3. Respond to Webhook node — sends AI response back to chat UI

When I run this, everything works. The chat UI receives the AI response without issue.

Failing Setup (with Google Sheets):

Same as above, but after Q&A node I added:

  1. Code node (formats User Question, AI Response, Timestamp)
  2. Google Sheets node (logs the values to a sheet)
  3. Respond to Webhook node

Now the frontend chat UI shows:

"I apologize, but I'm having trouble connecting to the server. Please try again in a few moments."

However, I verified that the Google Sheet does get updated, and the workflow succeeds without any error in the callin.io UI.

Observations:

  1. Disabling the Google Sheets node makes the chat UI response work again.
  2. So it seems like the webhook is not responding fast enough when Sheets is in the path.
  3. Tried using Respond to Webhook with “First incoming item” and correct field — no difference.

I want to:

  1. Return the AI response quickly to the chat UI
  2. Log the full conversation (User question, AI response, Timestamp) in Google Sheets
  3. Avoid timeouts/errors on the chat UI

My Question:

  1. What is the best practice for this setup in callin.io?
  2. Should I split the workflow into two — one for fast webhook response, another for async logging to Google Sheets? Or is there a way to ensure the webhook responds quickly even with Sheets in the same flow?

If possible, please guide with a proper structure or share example JSON workflows.

Thanks in advance!

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your callin.io setup

      • n * n8n version:1.89.2 Self Hosted
    • Database (default: SQLite):Qdrant Vector Store
    • n8n EXECUTIONSPROCESS setting (default: own, main):_
    • Running n8n via (Docker, npm, n8n cloud, desktop app):npm
    • Operating system:Ubuntu 24.04

Please provide the rewritten markdown content *it should be in the markdown format.

 
Posted : 04/05/2025 6:13 am
rbreen
(@rbreen)
Posts: 15
Active Member
 

Instead of an image, could you please share the actual workflow within a code block?

pasteworkflow

 
Posted : 21/05/2025 10:56 pm
King_Samuel_David
(@king_samuel_david)
Posts: 55
Trusted Member
 

You could likely utilize an AI agent for this purpose, and linking storage is the most effective method as it preserves chat session history.

Alternatively, you could place the sheet update after the webhook if a rapid response is required. Test this to see if any issues arise. You could also employ the AI agent mentioned above, integrating tools to call webhooks and Google Sheets. When describing this in the AI agent's system message, instruct it to always process the webhook first.

Furthermore, positioning the webhook before the sheet node might also result in it executing first.

 
Posted : 22/05/2025 6:17 am
aryanbt
(@aryanbt)
Posts: 2
New Member
Topic starter
 

Here is my final setup. It works perfectly with no issues. The conversation is flowing very smoothly, and responses are being generated solely from FAQs.

 
Posted : 30/05/2025 6:35 am
system
(@system)
Posts: 332
Reputable Member
 

This thread was automatically closed 7 days following the last response. New replies are no longer permitted.

 
Posted : 06/06/2025 6:36 am
Share: