Extract invoice data from PDFs with AI - Google Sheets Email alerts
Built by Setidure Technologies This smart n8n automation extracts invoice details from PDF files uploaded to Google Drive using AI, logs them to a Google Sheet, and notifies the billing team via email — all without manual intervention. ⚠️ Note: This workflow requires a self-hosted n8n instance with LangChain, LLM, and Google integrations configured. 📦 What This Workflow Does Monitors a Google Drive folder for new invoice uploads Extracts text and parses key invoice details using LLM via LangChain Logs extracted data into a Google Sheet (Invoice Database) Generates a summary email using GPT-4O-MINI (Greenie) Sends the email to the billing team via Gmail ✅ Prerequisites A Google Drive folder to monitor for PDF uploads A Google Sheet named Invoice Database with the following columns: Invoice Number, Client Name, Client Email, Client Address, Client Phone, Invoice Date, Due Date, Total Amount Service account or OAuth credentials for: Google Drive Google Sheets Gmail LangChain + Ollama integration for LLM responses 🔧 Step-by-Step Setup Instructions Clone this workflow into your self-hosted n8n instance Set up credentials: Google Drive (for folder trigger) Google Sheets (for data logging) Gmail (for sending email) Ollama (local LLM) or any connected LangChain provider Configure the trigger node to watch your specific Invoice Uploads folder Update the Google Sheet node with your Invoice Database sheet URL and column mapping Test with a sample invoice to validate the AI extraction and email generation 🔄 Workflow Steps Step 1: Trigger on New File in Google Drive Node Name: Watch for New Invoices Type: Google Drive Trigger Event: fileCreated Triggers when a new PDF file is uploaded to a designated folder Step 2: Download the Uploaded File Node Name: Download Invoice PDF Type: Download Binary Downloads the invoice file from Google Drive Step 3: Extract Raw Text from PDF Node Name: Extract PDF Text Type: Extract from File Extracts unstructured text content from the downloaded PDF Step 4: Parse Invoice Fields Using AI Node Name: Parse Invoice Data with LLM Type: LangChain Agent LLM is prompted to extract: Invoice Number Client Name, Email, Address, Phone Invoice Date, Due Date, Total Amount Fields not found are skipped Step 5: Log Extracted Data to Google Sheet Node Name: Log to Invoice Database Type: Google Sheets Appends a new row with the extracted fields to the Invoice Database spreadsheet Step 6: Create Email Notification via LLM Node Name: Generate Billing Email Summary Type: LangChain Agent (GPT-4O-MINI) Prompt instructs AI to: Act as “Greenie” from Green Grass Corp Inform billing that a new invoice was processed Confirm logging into the Invoice Database Step 7: Send the Email to Billing Team Node Name: Email Billing Team Type: Gmail Send To: billing@example.com Subject and body injected from LLM output Step 8: End Workflow Gracefully Node Name: End Type: No Operation Used to cleanly terminate the flow 🧠 Example Output (Email) Subject: New Invoice Logged – Client: ABC Corp Hi Billing Team, A new invoice has been received and processed automatically. The following details have been extracted and logged into the Invoice Database: Invoice Number: INV-1024 Client: ABC Corp Amount: $1,450 Due Date: July 15, 2025 Please review the Invoice Database for full details. Regards, Greenie Green Grass Corp
By Aashit SharmaAnalyze brand mentions on Reddit with GPT-4o mini and Notion integration
The Reddit Comment Analyzer is an n8n automation that helps businesses monitor brand mentions, analyze sentiment, and store insights in Notion. 🚀 Features 💬 Automated Comment Sourcing Tracks brand mentions (including misspellings) across Reddit. Filters relevant comments to avoid noise. 📊 AI-Powered Sentiment & Emotion Analysis Categorizes sentiment as Positive, Neutral, Negative, or Unrelated. Identifies emotions like frustration, excitement, or trust. ✅ Actionable Insights & Recommendations Suggests responses based on comment sentiment. Provides AI-driven insights for brand strategy. 📂 Seamless Notion Integration Automatically logs comments & analysis in a Notion database. Prevents duplicates by checking against existing records. 💡 Who is it for? Marketing Teams: Monitor brand perception & adjust messaging. Customer Support: Address concerns & engage with users. Social Media Managers: Track discussions and optimize engagement. 🔥 How to Get Started 1️⃣ Enter your brand name & business details 2️⃣ Connect Reddit & Notion accounts 3️⃣ Run the automation & gain instant insights Optimize your brand strategy with real-time Reddit insights! 🚀
By Ian DikhtiarMulti-channel website downtime alerts with UptimeRobot, Slack, WhatsApp & Notion
Description Automates website downtime detection and notifications using UptimeRobot. Triggers alerts via Slack, WhatsApp, or Email when a website goes down. Creates a task in Notion and tags the responsible engineer for resolution. Essential Information Monitors website status via UptimeRobot webhook. Sends immediate alerts to multiple channels (Slack, WhatsApp, Email). Generates a Notion task to track and assign downtime resolution. System Architecture Downtime Detection Pipeline: UptimeRobot Webhook Trigger: Detects website status changes (triggers on "down" status). Alert Generation Flow: Send Slack Alert: Notifies the team via Slack. Send WhatsApp Alert: Sends a message via WhatsApp. Send Email Alert: Emails the team about the downtime. Task Management: Create Notion Task: Creates a task in Notion and tags the responsible engineer. Implementation Guide Import the workflow JSON into n8n. Configure UptimeRobot webhook with the workflow URL (trigger on "down" status). Set up Slack, WhatsApp, and Email credentials. Configure Notion integration and specify the responsible engineer tag. Test with a simulated downtime event. Monitor alert delivery and task creation accuracy. Technical Dependencies UptimeRobot API for website monitoring and webhook triggers. Slack API for team notifications. WhatsApp API (e.g., Twilio) for messaging. Email service (e.g., SMTP) for email alerts. Notion API for task management. n8n for workflow automation. Customization Possibilities Adjust UptimeRobot trigger to include additional status conditions (e.g., "paused"). Customize alert messages in Slack, WhatsApp, and Email nodes. Modify Notion task template to include more details (e.g., downtime duration). Add escalation logic for unresolved issues. Integrate with additional tools (e.g., PagerDuty) for alerts.
By Oneclick AI SquadLive airport delay dashboard with FlightStats, Google Sheets & Slack alerts
Live Airport Delay Dashboard with FlightStats & Team Alerts Description Automates live monitoring of airport delays using FlightStats API. Stores and displays delay data, with Slack alerts for severe delays to operations/sales teams. Essential Information Runs on a scheduled trigger (e.g., hourly or daily). Fetches real-time delay data from FlightStats API. Stores data in Google Sheets and alerts teams via Slack for severe delays. System Architecture Delay Monitoring Pipeline: Set Schedule: Triggers the workflow hourly or daily via Cron. FlightStats API: Retrieves live airport delay data. Data Management Flow: Set Output Data: Prepares data for storage or display. Merge API Data: Combines and processes delay data. Alert and Display: Send Response via Slack: Alerts ops/sales for severe delays. No Action for Minor Delays: Skips minor delays with no action. Implementation Guide Import the workflow JSON into n8n. Configure Cron node for desired schedule (e.g., every 1 hr). Set up FlightStats API credentials and endpoint (e.g., https://api.flightstats.com). Configure Google Sheets or Notion for data storage/display. Test with a sample API call and verify Slack alerts. Adjust delay severity thresholds as needed. Technical Dependencies Cron service for scheduling. FlightStats API for real-time delay data. Google Sheets API or Notion API for data storage/display. Slack API for team notifications. n8n for workflow automation. Database & Sheet Structure Delay Tracking Sheet (e.g., AirportDelays): Columns: airportcode, delaystatus, delayminutes, timestamp, alertsent Example: JFK, Severe, 120, 2025-07-29T20:28:00Z, Yes Customization Possibilities Adjust Cron schedule for different frequencies (e.g., every 30 min). Modify FlightStats API parameters to track specific airports. Customize Slack alert messages in the Send Response via Slack node. Integrate with a dashboard tool (e.g., Google Data Studio) for live display. Add email alerts for additional notification channels.
By Oneclick AI SquadCreate AI newsletters with GPT-4o, human approval workflow, and SendGrid
Generate AI newsletters from form inputs and send via SendGrid Streamline your email marketing process with this AI-powered "Human-in-the-Loop" workflow. It allows you to generate high-quality, targeted newsletters from a simple form input, review them via email, and automatically distribute them to your subscribers upon approval. Who is this for? Digital marketers, content creators, community managers, and small business owners who want to maintain consistent communication with their audience but need to reduce the time spent on drafting and formatting emails. What does this workflow do? Input Collection: Starts with a user-friendly n8n Form where you input the newsletter topic, target audience, and sender details. Data Logging: Automatically saves the form responses to a Google Sheet for your records. AI Generation: Uses OpenAI (GPT-4o) to draft a catchy subject line and valuable body content formatted in Markdown based on your inputs. Approval Process: Sends a "Review Request" email to your inbox (via Gmail). This email contains a preview of the newsletter and a special link to approve it. Execution Wait: The workflow pauses and waits for you to click the approval link. Distribution: Once approved, it converts the Markdown to HTML and sends the final newsletter to your subscriber list using SendGrid. Requirements OpenAI API Key: To utilize GPT-4o for content generation. Google Cloud Account: Required for the Google Sheets (logging) and Gmail (approval notifications) nodes. SendGrid Account: Required for sending the final newsletter to your subscribers. n8n version: Ensure you are using a version that supports the LangChain nodes. How to set up Configure Credentials: Set up your credentials for OpenAI, Google (Sheets & Gmail), and SendGrid within n8n. Subscriber List: Open the Workflow Configuration node (Set node). Replace the placeholder with your comma-separated list of subscriber emails. Google Sheets: Create a Google Sheet with columns for topic, target, sender, and admin_email. Update the Store Form Responses node with your Document ID and Sheet Name. Sender Verification: In the SendGrid node, ensure the "From Email" matches a verified sender identity in your SendGrid account. Test: Click "Test Workflow," fill out the Form Trigger URL, and check your email for the approval draft. Click the link in the email to finish the process. How to customize Change the AI Model: You can swap the OpenAI model node for Anthropic (Claude) or a local LLM if preferred. Adjust the Prompt: Edit the system message in the Generate Newsletter Content agent node to change the tone or structure of the newsletter. Swap Email Providers: If you don't use SendGrid or Gmail, simply replace these nodes with the email service of your choice (e.g., Mailchimp, Outlook, AWS SES).
By 小林幸一