This template starts when you post a question to a Latenode webhook, reads the connected Google Sheet, and asks ChatGPT to answer from that data.
It then appends the question and answer as a new row. Connect Google Sheets and point Get Values at the worksheet you want to query. ChatGPT is a Latenode AI step.
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 you post a natural-language question to the Latenode webhook.
Google Sheets returns the rows ChatGPT should use as context.
ChatGPT reads the sheet data plus your question and returns the insight.
Google Sheets appends the question, answer, and timestamp to the log worksheet you choose.
Add a webhook trigger and copy the URL. Post the question text to that URL when you want an analysis.
Add a Google Sheets connection. Get values from the worksheet that holds the data, and keep a second worksheet or columns for question, answer, and timestamp.
Send the sheet rows and the question to ChatGPT. ChatGPT is a Latenode AI step. Append a Google Sheets row with the question and answer. Post a test question and confirm the new row.
FAQ
More templates
This template watches a Notion database for new pages, reads the title and properties, and creates a Google Doc from that text. Use it when a database row should become a shareable document. Connect Notion and Google Docs, then point the trigger at the database you want to watch.
This template starts on a new Google Form response, then creates a Google Doc from the template you pick and replaces placeholders with the answers. Use it for intake letters, briefs, or certificates that should match each submission. Connect Google Forms and Google Docs, then point the trigger at the form and the Docs step at the template.
This template receives Kartra calendar bookings on a Latenode webhook, maps name, email, and slot time in JavaScript, and appends a row in Google Sheets. Paste the webhook URL into Kartra. If the payload is only an id, use that JavaScript node to call the Kartra API and put the Kartra API key in that node. Connect Google Sheets and point add-row at the spreadsheet that stores leads.
