The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
This is a nicely built n8n automation workflow — an Invoice Parser Agent. Here's a breakdown of what it does:
What it does, end to end:
Watches a Google Drive folder — polls every minute for new PDF files dropped into a specific "Invoice" folder.
Downloads & extracts text — when a new file appears, it downloads it and extracts the raw text from the PDF.
AI-powered data extraction — passes the text to an LLM (via OpenRouter's free tier) configured as an Information Extractor. It pulls out 7 structured fields: Invoice Number, Sender Name, Sender Email, Sender Address, Total Amount, Invoice Date, and Due Date.
Logs to Google Sheets — appends the extracted data as a new row in a Google Sheet called "Invoice."
AI Agent writes a notification email — a second LLM call acts as a "professional email writer," generating a formatted subject line and message body in strict JSON format.
Sends the email via Gmail — fires off the AI-composed email notification to gmpatel404@gmail.com (the billing team).
Error handling — if the AI agent fails, instead of crashing silently, it logs an error message to a separate "Error Sheets" tab in the same spreadsheet for manual review.
Tech stack: n8n + Google Drive + Google Sheets + Gmail + OpenRouter (free LLM tier) + LangChain nodes (Information Extractor, AI Agent, Structured Output Parser)
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
What if every new lead could be handled before you even open your inbox? ⚡
This AI-powered workflow turns a new email inquiry into a structured, ready-to-handle lead — automatically.
A new inquiry arrives → AI extracts the important details → Airtable/CRM is updated → the response goes through optional human approval → a personalized email is sent → Notion is updated → the team gets notified in Slack → performance data is collected for reporting.
The goal isn't to remove people from the process. It's to remove the repetitive work around them.
This type of workflow can be customized for B2B companies, SaaS businesses, agencies, real estate, e-commerce, recruitment, consulting, customer support, healthcare, finance, education, and other service businesses.
Already know what you want to automate? → Send me your current workflow and I’ll map out how we can automate it.
Still doing repetitive work manually? → Tell me the task that consumes your team’s time, and I’ll help identify what can be automated.
#AIAutomation #AIWorkflow #AIWorkflows #AIAgents #Automation #WorkflowAutomation #BusinessAutomation #ProcessAutomation #n8n #n8nAutomation #ArtificialIntelligence #GenerativeAI #B2B #B2BAutomation #SaaS #SaaSAutomation #SalesAutomation #LeadGeneration #LeadAutomation #LeadManagement #EmailAutomation #CRMAutomation #CustomerSupport #CustomerServiceAutomation #MarketingAutomation #AgencyAutomation #RealEstateAutomation #EcommerceAutomation #RecruitmentAutomation #HRautomation #FinTech #HealthcareAutomation #EdTech #BusinessGrowth #BusinessEfficiency #DigitalTransformation #NoCode #LowCode #OpenAI #AIAgent #CRM #Airtable #Notion #Slack #Productivity #FutureOfWork
I'd use the human approval step to capture corrections, not just a yes/no decision. If a reviewer changes the extracted lead details, does the workflow update Airtable and the reporting record before sending the email?
📧 Automated Email Reporting System — n8n
Designed and developed an automated email reporting workflow using n8n to collect, process, and organize data on a scheduled basis.
The system automatically retrieves data from Google Sheets, processes and transforms the information using JavaScript, iterates through the required records, and generates personalized email reports. It also uses conditional logic to route different cases and stores the processed results back into Google Sheets.
Key features:
⏰ Scheduled workflow execution
📊 Google Sheets data processing
🔄 Automated record iteration
⚙️ JavaScript data transformation
📧 Automated email generation and delivery
🔀 Conditional branching
📋 Automatic report storage and organization
Technologies: n8n · Google Sheets · Gmail · JavaScript · Workflow Automation · Data Processing
I built an AI voice ordering workflow to help a restaurant capture customer orders and pass them to the kitchen with less manual work.
Using Vapi, I configured a voice assistant with the restaurant’s menu and prices to collect customer details and orders. After each call, a webhook triggers an n8n workflow, where OpenAI extracts the order into structured data. The workflow then notifies the kitchen and logs the order in Google Sheets.
I handled the voice assistant setup, webhook integration, AI prompts, and workflow implementation. The solution reduced manual order entry and made order information easier for the kitchen to access.
Tools: Vapi, n8n, OpenAI, Google Sheets, and webhooks.
Having the assistant feed orders straight into the kitchen cuts the manual handoff. The call transcript in Sheets also gives a clear audit trail.