N8N workflow : for dashboard automations

Help me Build my Workflow
1

I am studying a Data Analytics course and I’m new to building dashboard automations in n8n.
using Kaggle data- Telecom churn data - 7000 rows

Workflow

  1. I need python script collect the data from google sheet and clean the data and feature eng script then upload data rename and back to google drive.
  2. Tested the Pipeline working . whenever click the fetch button on loveable dashboard updating the dashboard .
    3.Third process is Chatbot tested getting err . not sure err due to tokens .. currently deactivated - any suggestions ???
2

Hello @kofianand

Welcome to the n8n community.

So that the community can identify the exact cause of the issue, could you please provide the exact error message that appears when executing the workflow when the chatbot fails?

If possible, also share the complete JSON of your workflow (making sure to remove your API keys or sensitive data) to help us better understand its structure.

3

Nice project setup! For the chatbot error, it’s most likely one of these three things:

If you’re using OpenAI or any LLM, 7000 rows of telecom data is way too much to send directly into the context window. You’ll hit token limits fast. Instead of passing the raw data to the chatbot, pass only a summary or aggregated version,things like churn rate by category, averages, totals. Let your Python script do the heavy lifting first and only send the processed insights to the chatbot.

If you’re querying Google Sheets directly from the chatbot node, the same problem applies. Pre-process the data and store a clean summary somewhere the chatbot can read efficiently.

Also check your API key is active and has enough credits sometimes the error is as simple as that.

To help narrow it down, can you share the exact error message you’re seeing? Even a partial message would help figure out if it’s a token issue, an API key issue, or something else in the workflow connection.