Automate Voice Queries from Google Docs with GPT-4o and Supabase

Automate Voice Queries from Google Docs with GPT-4o and Supabase

Transform the way you manage and retrieve information from your Google Docs with our streamlined workflow that leverages GPT-4o and Supabase. This cutting-edge automation indexes your Google Drive documents into a vector store, allowing you to answer voice queries with precision and speed.

What this workflow does

• Automatically runs on a daily schedule or through manual initiation at 02:00 to reindex specified Google Drive documents.
• Efficiently lists and processes files from a designated Google Drive folder, enhancing workflow productivity.
• Downloads content from each Google Drive file, creates OpenAI embeddings, and stores data chunks in a Supabase vector table, ensuring high-quality indexing.
• Receives voice query requests via a POST webhook containing `chatInput` and uses a GPT-4o-mini RAG agent to semantically retrieve relevant information.
• Delivers concise, source-cited voice-friendly answers back to the webhook caller, streamlining information delivery for users.

Use cases

• Enhance customer service platforms with rapid, automated FAQ responses sourced from internal documentation stored in Google Drive.
• Empower remote teams by enabling instant access to specific document details during voice calls or meetings.
• Support education platforms by allowing students to query course material stored in Google Docs and receive articulate audio responses.

Technical details

• Integrations used: Google Drive, OpenAI, Supabase, Webhook.
• Nodes involved: code, webhook, sticky note, Google Drive, HTTP request, and manual trigger.
• Setup requires Google Drive OAuth2 credentials, OpenAI API credential, and Supabase project configuration with a vector table.

This workflow is perfect for n8n users, automation engineers, and SaaS operators looking to enhance their information retrieval systems with robust automation. Experience the seamless integration of Google Drive, GPT-4o, and Supabase to revolutionize how you handle voice queries today.