Data extraction and storage from Google Drive to Postgres

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

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.

1. 1
   Import the workflow template into your n8n instance.
2. 2
   Connect your Google Drive and Postgres accounts.
3. 3
   Configure the folder ID for the Google Drive search.
4. 4
   Set the schedule for the workflow trigger.
5. 5
   Test the workflow to ensure proper functionality.