This template receives LINE messages on a webhook, loads that user's prior turns from Google Sheets, asks Gemini for a reply, logs the new turn, and sends the reply through the LINE Messaging API.
Connect Google Sheets and Google AI. Put the Google AI API key on the Google AI connection. Put the LINE channel access token in the JavaScript node. Paste the Latenode webhook URL into the LINE Official Account webhook.
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
A webhook receives the payload when a LINE user sends a message.
Google Sheets returns prior messages for that user id so Gemini has context.
Gemini reads the current message plus history and returns a reply. Put the Google AI API key on the Google AI connection.
Google Sheets appends the new turn. JavaScript posts the reply to LINE. Put the LINE channel access token in that JavaScript node.
Add a webhook trigger and copy its URL. In the LINE Official Account developer console, set that URL as the webhook.
Add a Google Sheets connection. Use columns for user id, timestamp, role, and message so each conversation can be looked up.
Add a Google AI connection and paste your Google AI API key there. Send Gemini the current LINE message plus the rows you loaded from Sheets.
In JavaScript, read reply token and user id from the webhook, post the Gemini text to the LINE Messaging API, and append both turns to Sheets. Put the LINE channel access token in that JavaScript node. Send a test LINE message and confirm the 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.
