Cracked Inbound Gmail Analyst w/ LlamaParse

Businesses that receive invoices or other documents via email and need to extract and organize data, or automate data entry. This workflow automatically monitors Gmail for emails with attachments. It then uses AI (LlamaParse and OpenAI) to extract, summarize, and categorize information from these attachments. It saves the original and processed documents to Google Drive, updates Google Sheets with extracted data, and sends notifications via Telegram. Set up credentials for Gmail, Google Drive, Google Sheets, LlamaParse, OpenAI, and Telegram. Customize AI prompts for document summarization and JSON extraction. Define the Google Sheet to update and the Telegram chat ID for notifications. n8n instance, Google Workspace account (Gmail, Drive, Sheets), LlamaParse API key, OpenAI API key, Telegram bot token and chat ID. Users can customize the Gmail search query (sender, attachments), AI prompts for summarization and JSON extraction, the target Google Sheet columns, and Telegram notification messages. The workflow also allows for adding more document classifications. Key Technologies: Gmail,LlamaParse,OpenAI,Google Sheets,Google Drive,Telegram,n8n Automation Value: Automates data extraction from email attachments. Reduces manual data entry and human error. Provides quick summaries of documents via Telegram. Organizes documents and extracted data in Google Drive and Google Sheets. Streamlines invoice processing and financial data management. Best Practices: Use environment variables for sensitive data like API keys and chat IDs. Thoroughly test AI prompts with diverse document types to ensure accurate extraction and summarization. Implement error handling (as shown with Telegram error messages) to catch and notify about processing failures. Regularly review and refine AI prompts to adapt to changes in document formats or extraction requirements. Ensure appropriate Google Sheets permissions for the n8n service account to prevent access issues.