This AI automation does exactly that:
✓ Detects new files uploaded to Google Drive
✓ Downloads and extracts key info from PDFs
✓ Uses AI to parse and structure the data
✓ Splits it into clean rows for Google Sheets
✓ Automatically appends new entries
🧠 The data structure going into the sheet:
1️⃣ Language of the Q&A
2️⃣ The extracted question
3️⃣ The AI-generated answer
The magic?
It uses an AI Agent with structured output parsing to understand and format unstructured PDFs — no templates, no rules, just intelligence.
✅ Fully open-source (n8n)
✅ No subscriptions
✅ No vendor lock-in
✅ Groq model is free — the only cost is for the LLM call
Perfect for automating:
• Medical documents
• Intake forms
• Contracts
• Support tickets
• Any PDF-based Q&A workflow