Data Extraction and Storage from Google Drive to Postgres Database

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

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.

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