Library / Documents, PDF & OCR
Documents, PDF & OCR
Extract Gmail attachment data with OpenAI into Google Sheets
Runs on each new Gmail email, saves attachments to Google Drive, uses OpenAI to extract structured values, and appends them to Google Sheets.
What it does
## 3. Use LLMs to Extract Values from Data [Read more about Basic LLM Chain]({{ $env.WEBHOOK_URL }} Large language models are perfect for data extraction tasks as they can work across a range of document layouts without human intervention. The extracted data can then be sent to a variety of datastores such as spreadsheets, accounting systems and/or CRMs. Tip: The "Structured Output Parser" ensures the AI output can be inserted to our spreadsheet without additional clean up and/or formatting.
The steps
- Gmail Trigger1
- Setup1
- Upload PDF to Drive1
- Rename file1
- Move to the correct folder1
- Gmail
- Extract from File2
- Google Drive
- OpenAI Model
- Structured Output Parser
- Append to Reconciliation Sheet
- Map Output
- Apply Data Extraction Rules
- Only invoice mails with attachments
Similar automations
Email AutomationCreate and Send an Outlook Draft with Attachment6 stepsDocuments, PDF & OCRSave Gmail Attachments to Drive and Log Data in Sheets with OpenAI14 stepsDocuments, PDF & OCRExtract Text from Drive PDFs and Images with Gemini12 stepsDocuments, PDF & OCRMatch Emailed PDFs with OpenAI and Save to Drive19 steps