This template answers data questions from a chat UI. A webhook receives the message. Google Sheets loads the table you analyze. JavaScript filters and totals the rows that match.
ChatGPT writes a short answer from that slice. Supabase stores the question and answer, then the webhook returns the reply. Connect Google Sheets and Supabase. ChatGPT is a Latenode AI step. You do not add an OpenAI key.
Latenode bills workflow runtime in CPU seconds. The first 10,000 CPU seconds are free each month, then usage follows pay-as-you-go CPU-second pricing. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.
Full pricing — how CPU seconds work →Workflow preview
The scenario starts when your chat UI posts a message to the Latenode webhook.
Google Sheets returns the table you use for analysis.
JavaScript keeps the rows that match the question and shapes totals ChatGPT can read.
ChatGPT returns a short reply from that slice. ChatGPT is a Latenode AI step.
Supabase stores question and answer. The webhook sends the reply back to the chat UI.
Add a webhook trigger and copy its URL into your chat UI. Return the answer with a webhook response at the end.
Add a Google Sheets connection. Point Get Values at the tab that holds the numbers people will ask about.
Send the question plus the filtered rows to ChatGPT and ask for a short answer. ChatGPT is a Latenode AI step.
Add a Supabase connection. Create a table for question, answer, and time, then insert a row after each reply.
FAQ
More templates
This template starts when someone mentions your Slack bot, sends the message text to ChatGPT, and posts the reply in that channel. Use it for status updates or a channel assistant. Put the Slack bot token on the Slack connection. ChatGPT is Latenode AI, so you do not paste an OpenAI key.
This template starts when you add a row in Google Sheets with product, keywords, and landing page. ChatGPT writes headlines and descriptions. JavaScript sends that copy to the Google Ads API, then Sheets stores the copy on the same row. Connect Google Sheets. ChatGPT is a Latenode AI step, so you do not paste an OpenAI key. Put the Google Ads developer token in the JavaScript node.
This template receives an incoming WhatsApp Business Cloud message on a Latenode webhook, pulls the text and sender phone in JavaScript, detects intent with Google Dialogflow ES, and sends the reply with WhatsApp Business Cloud. Connect WhatsApp Business Cloud and Dialogflow. Put the Cloud API token on the WhatsApp connection and the Google key on the Dialogflow connection.
