Skip to main content

LINE BOT - Google Sheets file lookup with AI agent

Workflow preview

Workflow preview
100%
LINE BOT - Google Sheets file lookup with AI agent preview
Open on n8n.io
n8n Cloud
$20/month : Unlimited workflows
2500 executions/month
Try free
Bright Data
THE #1 IN WEB SCRAPING
Scrape any website without limits
Try free
HOSTINGER Hostinger Early Deal
DISCOUNT 20%
Self-hosted n8n
Unlimited workflows - from $4.99/mo
Try free
Apify
#1 hub for scraping, AI & automation
6000+ actors - $5 credits/mo
Try free

Important notice

This workflow is provided as-is. Please review and test before using in production.

1. Workflow Overview

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 messag...

Best for

  • AI automation workflows
  • AI Chatbot automation workflows
  • intermediate n8n builders looking for reusable templates

Tools used

n8n-nodes-base.webhook, n8n-nodes-base.googlesheets, n8n-nodes-base.if, @n8n/n8n-nodes-langchain.agent, @n8n/n8n-nodes-langchain.lmchatopenai, n8n-nodes-base.set, n8n-nodes-base.httprequest

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Jaruphat J..

Original n8n.io source

1.1 Workflow description

Title
LINE BOT - Google Sheets file lookup with AI agent
Workflow name
LINE BOT - Google Sheets file lookup with AI agent

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 corresponding Google Drive URL via LINE BOT.

  • Supports natural language queries (e.g., "Find file 1.pdf for me")
  • AI-powered filename extraction
  • Google Sheets Lookup for file URLs
  • Auto-response via LINE BOT

How to Use This Template

1. Download & Import

  • Copy and save the Template Code as a .json file.
  • Go to n8n Editor → Click Import → Upload the file.

2. Update Required Fields

  • Replace YOUR_GOOGLE_SHEET_ID with your actual Google Sheet ID.
  • Replace YOUR_LINE_ACCESS_TOKEN with your LINE BOT Channel Access Token.

3. Activate & Test

  • Click Execute Workflow to test manually.
  • Set Webhook URL in LINE Developer Console.

Features of This Template

  • Supports Natural Language Queries (e.g., “Find file 1.pdf for me”)
  • AI-powered filename extraction using OpenAI (GPT-4/3.5)
  • Real-time file lookup in Google Sheets
  • Automatic LINE BOT Response
  • Fully Automated Workflow

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - Webhook

Type / Role
n8n-nodes-base.webhook - webhook
Config choices
Version 1

Block 2 - Google Sheets Lookup

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 1

Block 3 - IF File Exists

Type / Role
n8n-nodes-base.if - if
Config choices
Version 1

Block 4 - AI Agent

Type / Role
@n8n/n8n-nodes-langchain.agent - agent
Config choices
Version 1.7

Block 5 - OpenAI Chat Model

Type / Role
@n8n/n8n-nodes-langchain.lmChatOpenAi - lmChatOpenAi
Config choices
Version 1

Block 6 - Edit Fields

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 7 - HTTP Request - Found

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 8 - HTTP Request - Not Found

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

3. Summary Table

Workflow LINE BOT - Google Sheets file lookup with AI agent
Complexity intermediate
Nodes 8
Categories AI, AI Chatbot
Author Jaruphat J.
Published 10 Feb 2025

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/2874/2874.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Download workflow JSON Original n8n.io source AI workflows AI Chatbot workflows

Frequently asked questions

What does LINE BOT - Google Sheets file lookup with AI agent do?

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 messag...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your AI, AI Chatbot use case.