Ai agent to chat with files in Supabase Storage and Google Drive

Video Guide

I prepared a detailed guide that illustrates the entire process of building an AI agent using Supabase and Google Drive within N8N workflows.

[](https://youtu.be/NB6LhvObiL4)

[Youtube Link](https://youtu.be/NB6LhvObiL4)

Who is this for? This workflow is designed for developers, data scientists, and business users who wish to automate document management and enable AI-powered interactions over their stored files. It's especially beneficial for scenarios where users need to process, analyze, and retrieve information from uploaded documents rapidly.

What problem does this workflow solve? Managing files across multiple platforms often involves tedious manual processes. This workflow facilitates automated file handling, making it easier for users to upload, parse, and interact with documents through an AI agent. It reduces redundancy and enhances the efficiency of data retrieval and management tasks.

What this workflow does This workflow integrates Supabase storage with Google Drive and employs an AI agent to manage files effectively. The agent can: - Upload files to Supabase storage and activate processes based on file changes in Google Drive. - Retrieve and parse documents, converting them into a structured format for easy querying. - Utilize an AI agent to answer user queries based on saved document data.

1. Data Collection: The workflow initially gathers files from Supabase storage, ensuring no duplicates are processed in the 'files' table. 2. File Handling: It processes files to be parsed based on their type, leveraging LlamaParse for effective data transformation. 3. Google Drive Integration: The workflow monitors a designated Google Drive folder to upload files automatically and refresh document records in the database with new data. 4. AI Interaction: A webhook is established to enable the AI agent to converse with users, facilitating queries and leveraging stored document knowledge.