Library / Documents, PDF & OCR
Documents, PDF & OCR
Save Gmail Attachments to Drive and Log Data in Sheets with OpenAI
When a new email with a PDF arrives in Gmail, it files the attachment in Google Drive, has OpenAI extract key values and records them in Google Sheets.
What it does
## 3. Use LLMs to Extract Values from Data Read more about Basic LLM Chain 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
Documents, PDF & OCRSave Gmail Attachments to Drive and Sheets with OpenAI30 stepsDocuments, PDF & OCRSave matching Gmail PDF attachments to Google Drive using OpenAI17 stepsEmail AutomationLog Gmail invoice attachments to Google Sheets with easybits and Telegram11 stepsDocuments, PDF & OCRExtract Gmail attachment data with OpenAI into Google Sheets14 steps