Google Sheets node
Merge node
+16

AI Email Analyzer: Process PDFs, Images & Save to Google Drive + Telegram

Published 2 days ago

Created by

n3witalia
Davide

Categories

Template description

This workflow automates the process of analyzing emails and their attachments (PDFs and images) using AI models (DeepSeek, Gemini, and OpenRouter). It extracts and summarizes the content of emails and attachments, saves the summaries to Google Sheets, and sends a final consolidated summary via Telegram.

This is a powerful tool for automating email analysis and summarization, saving time and ensuring that important information is easily accessible and actionable.

Below is a breakdown of the workflow:


1. How It Works

The workflow is designed to process incoming emails, analyze their content and attachments, and generate summaries. Here's how it works:

  1. Email Trigger:

    • The workflow starts with the Email Trigger (IMAP) node, which monitors an email inbox for new emails.
    • If an email contains attachments, the workflow processes them.
  2. Check for Attachments:

    • The Contain Attachments? node checks if the email has attachments.
    • If attachments are present, the workflow proceeds to process them.
  3. Process Attachments:

    • The Get PDF and Images Attachments node extracts PDF and image attachments from the email.
    • The Switch node separates PDFs and images for further processing:
      • PDFs: The Extract from PDF node extracts text from PDFs, and the PDF Analyzer node summarizes the content.
      • Images: The Analyze Image node uses AI to describe the content of images.
  4. Summarize Email Content:

    • The Convert Text node converts the email's HTML content to plain text.
    • The Email Summarization Chain node uses AI to generate a summary of the email's text content.
  5. Save Summaries:

    • The Save Summary PDF, Save Summary Image, and Save Summary Text nodes save the summaries of PDFs, images, and email text, respectively, to Google Sheets.
  6. Consolidate Summaries:

    • The All Summaries node aggregates the summaries of the email text, PDFs, and images.
    • The Create Final Summary node uses AI to generate a unified summary of all the content.
  7. Send Final Summary:

    • The Send Final Summary node sends the consolidated summary via Telegram to a specified chat ID.

2. Set Up Steps

To set up and use this workflow in n8n, follow these steps:

  1. IMAP Configuration:

    • Set up IMAP credentials in n8n for the Email Trigger (IMAP) node.
    • Ensure the email account is accessible via IMAP.
  2. AI Model Configuration:

    • Configure the DeepSeek, Gemini, and OpenRouter credentials in n8n for the Email Summarization Chain, PDF Analyzer, and Create Final Summary nodes.
    • Ensure the AI models are set up to generate summaries.
  3. Google Sheets Integration:

    • Set up Google Sheets credentials in n8n for the Save Summary PDF, Save Summary Image, and Save Summary Text nodes.
    • Specify the Google Sheet and worksheet where the summaries will be saved.
  4. Telegram Integration:

    • Set up Telegram credentials in n8n for the Send Final Summary node.
    • Insert your Chat ID in the Telegram node to receive the final summary.
  5. Test the Workflow:

    • Send an email with attachments (PDFs and images) to the monitored email account.
    • The workflow will:
      • Extract and summarize the email content and attachments.
      • Save the summaries to Google Sheets.
      • Send a consolidated summary via Telegram.
  6. Optional Customization:

    • replace IMAP trigger with Gmail or Outlook trigger
    • Modify the workflow to include additional features, such as:
    • Adding more AI models for different types of analysis.
    • Sending notifications via other channels (e.g., Slack, email).
    • Integrating with other storage services (e.g., Dropbox, AWS S3).

Share Template

More AI workflow templates

OpenAI Chat Model node
SerpApi (Google Search) node

AI agent chat

This workflow employs OpenAI's language models and SerpAPI to create a responsive, intelligent conversational agent. It comes equipped with manual chat triggers and memory buffer capabilities to ensure seamless interactions. To use this template, you need to be on n8n version 1.50.0 or later.
n8n-team
n8n Team
HTTP Request node
Merge node
+7

Scrape and summarize webpages with AI

This workflow integrates both web scraping and NLP functionalities. It uses HTML parsing to extract links, HTTP requests to fetch essay content, and AI-based summarization using GPT-4o. It's an excellent example of an end-to-end automated task that is not only efficient but also provides real value by summarizing valuable content. Note that to use this template, you need to be on n8n version 1.50.0 or later.
n8n-team
n8n Team
HTTP Request node
WhatsApp Business Cloud node
+10

Building Your First WhatsApp Chatbot

This n8n template builds a simple WhatsApp chabot acting as a Sales Agent. The Agent is backed by a product catalog vector store to better answer user's questions. This template is intended to help introduce n8n users interested in building with WhatsApp. How it works This template is in 2 parts: creating the product catalog vector store and building the WhatsApp AI chatbot. A product brochure is imported via HTTP request node and its text contents extracted. The text contents are then uploaded to the in-memory vector store to build a knowledgebase for the chatbot. A WhatsApp trigger is used to capture messages from customers where non-text messages are filtered out. The customer's message is sent to the AI Agent which queries the product catalogue using the vector store tool. The Agent's response is sent back to the user via the WhatsApp node. How to use Once you've setup and configured your WhatsApp account and credentials First, populate the vector store by clicking the "Test Workflow" button. Next, activate the workflow to enable the WhatsApp chatbot. Message your designated WhatsApp number and you should receive a message from the AI sales agent. Tweak datasource and behaviour as required. Requirements WhatsApp Business Account OpenAI for LLM Customising this workflow Upgrade the vector store to Qdrant for persistance and production use-cases. Handle different WhatsApp message types for a more rich and engaging experience for customers.
jimleuk
Jimleuk
HTTP Request node
Markdown node
+5

AI agent that can scrape webpages

⚙️🛠️🚀🤖🦾 This template is a PoC of a ReAct AI Agent capable of fetching random pages (not only Wikipedia or Google search results). On the top part there's a manual chat node connected to a LangChain ReAct Agent. The agent has access to a workflow tool for getting page content. The page content extraction starts with converting query parameters into a JSON object. There are 3 pre-defined parameters: url** – an address of the page to fetch method** = full / simplified maxlimit** - maximum length for the final page. For longer pages an error message is returned back to the agent Page content fetching is a multistep process: An HTTP Request mode tries to get the page content. If the page content was successfuly retrieved, a series of post-processing begin: Extract HTML BODY; content Remove all unnecessary tags to recude the page size Further eliminate external URLs and IMG scr values (based on the method query parameter) Remaining HTML is converted to Markdown, thus recuding the page lengh even more while preserving the basic page structure The remaining content is sent back to an Agent if it's not too long (maxlimit = 70000 by default, see CONFIG node). NB: You can isolate the HTTP Request part into a separate workflow. Check the Workflow Tool description, it guides the agent to provide a query string with several parameters instead of a JSON object. Please reach out to Eduard is you need further assistance with you n8n workflows and automations! Note that to use this template, you need to be on n8n version 1.19.4 or later.
eduard
Eduard
Merge node
Telegram node
Telegram Trigger node
+2

Telegram AI Chatbot

The workflow starts by listening for messages from Telegram users. The message is then processed, and based on its content, different actions are taken. If it's a regular chat message, the workflow generates a response using the OpenAI API and sends it back to the user. If it's a command to create an image, the workflow generates an image using the OpenAI API and sends the image to the user. If the command is unsupported, an error message is sent. Throughout the workflow, there are additional nodes for displaying notes and simulating typing actions.
eduard
Eduard
Google Drive node
Binary Input Loader node
Embeddings OpenAI node
OpenAI Chat Model node
+5

Ask questions about a PDF using AI

The workflow first populates a Pinecone index with vectors from a Bitcoin whitepaper. Then, it waits for a manual chat message. When received, the chat message is turned into a vector and compared to the vectors in Pinecone. The most similar vectors are retrieved and passed to OpenAI for generating a chat response. Note that to use this template, you need to be on n8n version 1.19.4 or later.
davidn8n
David Roberts

Implement complex processes faster with n8n

red icon yellow icon red icon yellow icon