LINE BOT - Google Sheets file lookup with AI agent
Needs changesWhat this workflow does
This AI workflow has 8 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets and OpenAI Chat Model. It also calls api.line.me over HTTP.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Edit Fields (Edit Fields (Set)): sets 1 field: textinput
- AI Agent: runs an AI agent, with model: OpenAI Chat Model
- Google Sheets: lookup
- If: checks a condition and branches into true / false
- HTTP Request: calls api.line.me (POST)
- HTTP Request: calls api.line.me (POST)
Services it uses
HTTP calls to: api.line.me
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in AI Agent (v1.7): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI Agent (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (7)
- Webhook
n8n-nodes-base.webhook - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest
From the author
This workflow integrates LINE BOT, AI Agent (GPT), Google Sheets, and Google Drive to enable users to search for file URLs using natural language. The AI Agent extracts the filename from the message, searches for the file in Google Sheets, and returns the…