Use Cases
- Automate the extraction of documents from Google Drive for data analysis.
- Store and manage large volumes of text and PDF files in a structured database.
- Utilize AI embeddings for improved search and retrieval of document content.
How It Works
Trigger the workflow manually or on a schedule. Search for files in a designated Google Drive folder. Download files based on their type (PDF, text, JSON). Extract content from the downloaded files. Generate embeddings for the extracted content using OpenAI. Store the embeddings and original content in a Postgres database.
Setup Steps
- 1Import the workflow template into your n8n instance.
- 2Connect your Google Drive and Postgres accounts.
- 3Set the folder ID for the Google Drive search.
- 4Configure the Postgres database connection settings.
- 5Test the workflow to ensure proper functionality.
Apps Used
Google Drive
Postgres
OpenAI
Categories
Target Roles
Tags
#data extraction
#process automation
#document automation