Use Cases
- Automate data extraction from Google Drive files for analysis.
- Store and manage extracted content in a Postgres database.
- Utilize AI embeddings for enhanced data retrieval.
How It Works
Scheduled trigger initiates the workflow at specified intervals. Search for files in a designated Google Drive folder. Download identified files based on their types. Extract content from files (PDF, text, JSON). Generate embeddings using OpenAI for the extracted content. Store the processed data in a Postgres PGVector database.
Setup Steps
- 1Import the workflow template into your n8n instance.
- 2Connect your Google Drive and Postgres accounts.
- 3Configure the folder ID for the Google Drive search.
- 4Set the schedule for the workflow trigger.
- 5Test the workflow to ensure proper functionality.
Apps Used
Google Drive
Postgres
OpenAI
Categories
Target Roles
Tags
#data extraction
#process automation
#workflow management