LINE BOT File Lookup with AI Agent & Google Sheets

This workflow integrates LINE BOT webhook with an AI Agent (powered by GPT-4/3.5) to handle user queries like 'Find file 1.pdf for me'. The AI extracts the filename from natural language input, performs a lookup in a specified Google Sheets range (e.g., Filename column A, URL column B), and retrieves the corresponding Google Drive file URL. If found, it sends an automated response back via LINE BOT; otherwise, it handles no-match scenarios gracefully.

Key benefits include hands-free file discovery for teams or customers, reducing manual support time by 90%. It's ideal for marketing contests where participants request assets, customer service bots sharing documents, or internal knowledge bases. Supports real-time processing with no coding required post-setup.

Use cases: Marketing campaigns distributing contest rules/files, support bots for file retrieval, sales teams sharing proposals on demand. Fully automated end-to-end, scalable for high-volume queries. Requires LINE Channel Access Token, Google Sheet ID, and OpenAI credentials.