planeta ai logo
Darmowy szablon automatyzacji

Analizator wiadomości e-mail AI: przetwarzaj pliki PDF, obrazy i zapisuj na Dysku Google + Telegram

12427
25 dni temu
31
bloków


Jak działa ten szablon automatyzacji

Ten workflow automatyzuje proces analizowania wiadomości e-mail i ich załączników (PDF oraz obrazy) przy użyciu modeli AI (DeepSeek, Gemini i OpenRouter). Wyodrębnia i podsumowuje treść wiadomości e-mail oraz załączników, zapisuje podsumowania w Google Sheets i wysyła ostateczne zestawienie przez Telegram.

To potężne narzędzie do automatyzacji analizy i podsumowywania wiadomości e-mail, oszczędzające czas i zapewniające łatwy dostęp do ważnych informacji.

Krok po kroku

  • Wyzwalacz e-mail: Workflow rozpoczyna się od węzła Email Trigger (IMAP), który monitoruje skrzynkę e-mail pod kątem nowych wiadomości. Jeśli e-mail zawiera załączniki, workflow przetwarza je.
  • Sprawdzenie załączników: Węzeł Contain Attachments? sprawdza, czy e-mail zawiera załączniki. Jeśli tak, workflow przechodzi do ich przetwarzania.
  • Przetwarzanie załączników: Węzeł Get PDF and Images Attachments wyodrębnia załączniki PDF i obrazy z e-maila. Węzeł Switch rozdziela PDF-y i obrazy do dalszego przetwarzania:
    • PDF-y: Węzeł Extract from PDF wyodrębnia tekst z PDF-ów, a węzeł PDF Analyzer podsumowuje ich zawartość.
    • Obrazy: Węzeł Analyze Image wykorzystuje AI do opisu zawartości obrazów.
  • Podsumowanie treści e-maila: Węzeł Convert Text konwertuje treść e-maila z HTML na zwykły tekst. Węzeł Email Summarization Chain wykorzystuje AI do wygenerowania podsumowania tekstu e-maila.
  • Zapisywanie podsumowań: Węzły Save Summary PDF, Save Summary Image i Save Summary Text zapisują podsumowania PDF-ów, obrazów i tekstu e-maila w Google Sheets.
  • Konsolidacja podsumowań: Węzeł All Summaries agreguje podsumowania tekstu e-maila, PDF-ów i obrazów. Węzeł Create Final Summary wykorzystuje AI do wygenerowania ujednoliconego podsumowania całej zawartości.
  • Wysyłanie ostatecznego podsumowania: Węzeł Send Final Summary wysyła skonsolidowane podsumowanie przez Telegram na określony Chat ID.

Konfiguracja

Aby skonfigurować i użyć tego workflow w n8n, wykonaj następujące kroki:

Konfiguracja IMAP

  • Skonfiguruj dane logowania IMAP w n8n dla węzła Email Trigger (IMAP).
  • Upewnij się, że konto e-mail jest dostępne przez IMAP.

Konfiguracja modeli AI

  • Skonfiguruj dane logowania DeepSeek, Gemini i OpenRouter w n8n dla węzłów Email Summarization Chain, PDF Analyzer i Create Final Summary.
  • Upewnij się, że modele AI są skonfigurowane do generowania podsumowań.

Integracja z Google Sheets

  • Skonfiguruj dane logowania Google Sheets w n8n dla węzłów Save Summary PDF, Save Summary Image i Save Summary Text.
  • Określ arkusz Google Sheet i arkusz roboczy, w którym będą zapisywane podsumowania.

Integracja z Telegram

  • Skonfiguruj dane logowania Telegram w n8n dla węzła Send Final Summary.
  • Wprowadź swój Chat ID w węźle Telegram, aby otrzymywać ostateczne podsumowanie.

Testowanie workflow

  • Wyślij e-mail z załącznikami (PDF-y i obrazy) na monitorowane konto e-mail.
  • Workflow wykona następujące czynności:
    • Wyodrębni i podsumuje treść e-maila oraz załączniki.
    • Zapisze podsumowania w Google Sheets.
    • Wyśle skonsolidowane podsumowanie przez Telegram.

Opcjonalne dostosowanie

  • Zastąp wyzwalacz IMAP wyzwalaczem Gmail lub Outlook.
  • Zmodyfikuj workflow, aby uwzględniał dodatkowe funkcje, takie jak:
    • Dodanie większej liczby modeli AI do różnych rodzajów analizy.
    • Wysyłanie powiadomień przez inne kanały (np. Slack, e-mail).
    • Integracja z innymi usługami przechowywania (np. Dropbox, AWS S3).

Przykłady zastosowań

Ten szablon automatyzacji może być wykorzystany w wielu scenariuszach biznesowych i osobistych, oszczędzając czas i zwiększając efektywność. Oto kilka potencjalnych zastosowań:

  • Monitorowanie skrzynki e-mail: Automatyczne podsumowywanie ważnych wiadomości i załączników, aby szybko identyfikować kluczowe informacje.
  • Obsługa klienta: Analiza e-maili od klientów i generowanie podsumowań dla zespołu wsparcia, aby przyspieszyć reakcję na zapytania.
  • Raporty biznesowe: Automatyczne przetwarzanie raportów w formacie PDF i generowanie skróconych podsumowań dla menedżerów.
  • Badania rynku: Analiza załączników z danymi rynkowymi i generowanie podsumowań trendów.
  • Zarządzanie projektami: Podsumowywanie e-maili związanych z projektem i załączników, aby śledzić postępy i zadania.
  • Edukacja: Automatyczne przetwarzanie materiałów szkoleniowych w formie PDF i obrazów, tworząc skrócone notatki dla studentów.
  • Personalne zarządzanie informacjami: Organizowanie osobistych e-maili i załączników, aby łatwiej zarządzać ważnymi dokumentami.

Potrzebujesz pomocy w dostosowaniu? Skontaktuj się ze mną w celu konsultacji i wsparcia lub dodaj mnie na LinkedIn.


   Skopiuj kod szablonu   
{"id":"MCzA5RzvO83kNJi7","meta":{"instanceId":"a4bfc93e975ca233ac45ed7c9227d84cf5a2329310525917adaf3312e10d5462","templateCredsSetupCompleted":true},"name":"AI Email Analyzer: Process PDFs, Images","tags":[],"nodes":[{"id":"0526c603-2c35-4f65-88ee-e143f7aa3ca4","name":"Email Trigger (IMAP)","type":"n8n-nodes-base.emailReadImap","position":[-80,500],"parameters":{"options":{},"downloadAttachments":true},"credentials":{"imap":{"id":"k31W9oGddl9pMDy4","name":"IMAP info@n3witalia.com"}},"typeVersion":2},{"id":"9b0b83d1-7d7c-4858-aedc-4816e2f02276","name":"DeepSeek R1","type":"@n8n/n8n-nodes-langchain.lmChatOpenAi","position":[1320,980],"parameters":{"model":{"__rl":true,"mode":"list","value":"deepseek/deepseek-r1:free","cachedResultName":"deepseek/deepseek-r1:free"},"options":{}},"credentials":{"openAiApi":{"id":"XJTqRiKFJpFs5MuX","name":"OpenRouter account"}},"typeVersion":1.2},{"id":"2e8ad64a-d767-441e-9e12-7a75f5ed4c1c","name":"Email Summarization Chain","type":"@n8n/n8n-nodes-langchain.chainSummarization","position":[1360,800],"parameters":{"options":{"binaryDataKey":"={{ $json.data }}","summarizationMethodAndPrompts":{"values":{"prompt":"=Write a concise summary of the following in max 100 words :nn"{{ $json.data }}"nnDo not enter the total number of words used.","combineMapPrompt":"=## Email Summarization System PromptnnYou are a specialized AI assistant focused exclusively on creating precise, concise summaries of emails. Your task is to analyze the complete email text provided as input and produce a clear, comprehensive summary that captures all essential information in a cohesive narrative format.nn### Your responsibilities:nn1. Extract and summarize the main topic and purpose of the emailn2. Identify key points, requests, deadlines, or action items mentionedn3. Preserve critical details like dates, times, locations, and namesn4. Maintain the original tone and urgency level of the messagen5. Organize information in order of importancen6. Remove unnecessary pleasantries, redundancies, and filler contentnn### Summary format:nn- Begin with a one-sentence overview of the email's main purposen- Present all key information in a cohesive paragraph format (no bullet points)n- Follow a logical flow from most to least important informationn- Include any critical deadlines, requests, or action items within the narrativen- Keep the summary to 3-5 sentences totaln- Use clear, straightforward language with appropriate transitions between ideasn- Preserve the original intent and meaning without introducing new informationnn### What to exclude:nn- Greetings and sign-offsn- Redundant informationn- Minor details that don't affect the main messagen- Your own opinions or interpretationsn- Information not explicitly stated in the emailnnThe email text to summarize is:n{{$json.data}}"}}},"operationMode":"nodeInputBinary"},"typeVersion":2},{"id":"97f2b5f8-b2ba-4bd5-a951-c97e64e6f833","name":"Sticky Note","type":"n8n-nodes-base.stickyNote","position":[-140,-280],"parameters":{"color":3,"width":580,"height":400,"content":"# AI Email Analyzer: Process PDFs, Images nnThis is a powerful tool for automating email analysis and summarization, saving time and ensuring that important information is easily accessible and actionable.nnAll summaries are saved on a Google Sheet and identified by a numeric ID referring to the single email.nn## Preliminary step:n- Clone this [Google Drive Sheet](https://docs.google.com/spreadsheets/d/1rBa0RI6XFfMerylVCV0dlKhJT_f4UAd8S6jyYX4aRRo/edit?usp=sharing)n- Insert your Chat_ID in Telegram noden- Choose the AI model you prefern"},"typeVersion":1},{"id":"d2012cbc-0e79-4579-ac3d-e5e84ad56dc1","name":"Switch","type":"n8n-nodes-base.switch","position":[960,120],"parameters":{"rules":{"values":[{"outputKey":"pdf","conditions":{"options":{"version":2,"leftValue":"","caseSensitive":true,"typeValidation":"loose"},"combinator":"and","conditions":[{"id":"31b7fb0b-3149-479e-852a-52c1ec8935ca","operator":{"type":"string","operation":"equals"},"leftValue":"={{ $binary.data.fileExtension }}","rightValue":"pdf"}]},"renameOutput":true},{"outputKey":"image","conditions":{"options":{"version":2,"leftValue":"","caseSensitive":true,"typeValidation":"loose"},"combinator":"and","conditions":[{"id":"9fe6411d-cf35-4fdd-a9ad-8c96f0a5cf66","operator":{"type":"string","operation":"regex"},"leftValue":"={{ $binary.data.fileExtension }}","rightValue":"=/^(jpg|png)$/i"}]},"renameOutput":true}]},"options":{},"looseTypeValidation":true},"typeVersion":3.2},{"id":"8a9d55b8-9ba5-4a6f-ae13-9c529875a2a4","name":"Structured Output Parser","type":"@n8n/n8n-nodes-langchain.outputParserStructured","position":[2040,-320],"parameters":{"schemaType":"manual","inputSchema":"{nt"type": "object",nt"properties": {ntt"content": {nttt"type": "string"ntt}nt}n}"},"typeVersion":1.2},{"id":"658696f5-08e0-4d51-89bc-2a1c31576700","name":"Split Out","type":"n8n-nodes-base.splitOut","position":[2540,-420],"parameters":{"options":{},"fieldToSplitOut":"=output"},"typeVersion":1},{"id":"d2ba57c3-9e0e-4a7d-957d-216763e357c3","name":"Aggregate","type":"n8n-nodes-base.aggregate","position":[3660,220],"parameters":{"options":{},"fieldsToAggregate":{"fieldToAggregate":[{"fieldToAggregate":"data.output"}]}},"typeVersion":1},{"id":"10e6d3c6-10f6-4fea-be37-b5ee50e0b529","name":"OpenRouter Chat Model1","type":"@n8n/n8n-nodes-langchain.lmChatOpenRouter","position":[3920,400],"parameters":{"model":"google/gemini-2.0-flash-exp:free","options":{}},"credentials":{"openRouterApi":{"id":"pb06rfB4xmxzVe3Q","name":"OpenRouter"}},"typeVersion":1},{"id":"dcdcb7f2-669d-4e1b-a3f2-49a5b6c760b1","name":"Contain attachments?","type":"n8n-nodes-base.if","position":[260,500],"parameters":{"options":{},"conditions":{"options":{"version":2,"leftValue":"","caseSensitive":true,"typeValidation":"strict"},"combinator":"and","conditions":[{"id":"5cf96104-c887-44fe-b528-30171943dd15","operator":{"type":"boolean","operation":"true","singleValue":true},"leftValue":"={{ $binary.isNotEmpty() }}","rightValue":""}]}},"typeVersion":2.2},{"id":"6280db8e-42e4-4f88-bbe7-4e65eff3a34f","name":"Get PDF and images attachments","type":"n8n-nodes-base.code","position":[600,300],"parameters":{"jsCode":"let results = [];nnfor (const item of $input.all()) {n for (key of Object.keys(item.binary)) {n results.push({n json: {},n binary: {n data: item.binary[key],n }n });n }n}nnreturn results;"},"typeVersion":2},{"id":"53a7333d-fb49-46d4-9e3b-d186a5e416ca","name":"Extract from PDF","type":"n8n-nodes-base.extractFromFile","position":[1460,-540],"parameters":{"options":{},"operation":"pdf"},"typeVersion":1},{"id":"9d5c3b14-a3b0-4d2b-88d5-5a2c21a6907f","name":"PDF Analyzer","type":"@n8n/n8n-nodes-langchain.chainLlm","position":[1780,-540],"parameters":{"text":"=## PDF Summarization System PromptnnYou are a specialized AI assistant tasked with creating concise, accurate summaries of documents. Your goal is to extract and distill the most important information from the content provided as input and present it in a clear, precise plain text summary.nn### Your responsibilities:nn1. Identify the main topic and purpose of the documentn2. Extract key points, arguments, findings, or conclusionsn3. Preserve essential data points, statistics, dates, and figuresn4. Recognize and highlight critical information and takeawaysn5. Maintain the original document's logical structure in your summaryn6. Prioritize information based on its significance to the document's purposenn### Summary format:nn- Provide your summary in plain text only (no formatting)n- Begin with a concise overview of the document's main topic and purposen- Present important points in a logical, sequential narrativen- Use clear, direct language that accurately represents the original contentn- Maintain appropriate context for all extracted informationn- Keep the summary concise while including all crucial informationn- Use proper transitions between topics to maintain readabilitynn### What to exclude:nn- Minor details that don't contribute to the main pointsn- Repetitive informationn- Extensive examples unless they're critical to understandingn- Citations, references, and bibliographic details unless specifically importantn- Decorative or non-essential images (describe important visualized data if relevant)n- Your own interpretations or opinions not supported by the documentnn{{ $json.text }}","promptType":"define","hasOutputParser":true},"typeVersion":1.5},{"id":"ba6f6d2f-9a13-4bb4-80fb-72f5c4124473","name":"Save summary PDF","type":"n8n-nodes-base.googleSheets","position":[2580,-800],"parameters":{"columns":{"value":{"ID":"={{ $('Email Trigger (IMAP)').item.json.metadata["x-message-id"] }}","DATE":"={{ $now.format('dd/LL/yyyy') }}","TYPE":"pdf","EMAIL":"={{ $('Email Trigger (IMAP)').item.json.from }}","SUBJECT":"={{ $('Email Trigger (IMAP)').item.json.subject }}","SUMMARY":"={{ $json.output.content }}"},"schema":[{"id":"DATE","type":"string","display":true,"required":false,"displayName":"DATE","defaultMatch":false,"canBeUsedToMatch":true},{"id":"EMAIL","type":"string","display":true,"required":false,"displayName":"EMAIL","defaultMatch":false,"canBeUsedToMatch":true},{"id":"ID","type":"string","display":true,"required":false,"displayName":"ID","defaultMatch":false,"canBeUsedToMatch":true},{"id":"SUBJECT","type":"string","display":true,"required":false,"displayName":"SUBJECT","defaultMatch":false,"canBeUsedToMatch":true},{"id":"TYPE","type":"string","display":true,"required":false,"displayName":"TYPE","defaultMatch":false,"canBeUsedToMatch":true},{"id":"SUMMARY","type":"string","display":true,"required":false,"displayName":"SUMMARY","defaultMatch":false,"canBeUsedToMatch":true}],"mappingMode":"defineBelow","matchingColumns":[],"attemptToConvertTypes":false,"convertFieldsToString":false},"options":{},"operation":"append","sheetName":{"__rl":true,"mode":"list","value":"gid=0","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1rBa0RI6XFfMerylVCV0dlKhJT_f4UAd8S6jyYX4aRRo/edit#gid=0","cachedResultName":"Foglio1"},"documentId":{"__rl":true,"mode":"list","value":"1rBa0RI6XFfMerylVCV0dlKhJT_f4UAd8S6jyYX4aRRo","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1rBa0RI6XFfMerylVCV0dlKhJT_f4UAd8S6jyYX4aRRo/edit?usp=drivesdk","cachedResultName":"Analyze Email + Attachments"}},"credentials":{"googleSheetsOAuth2Api":{"id":"JYR6a64Qecd6t8Hb","name":"Google Sheets account"}},"typeVersion":4.5},{"id":"4c7ff16e-8649-4364-9aa6-c06670f4c36a","name":"All summaries","type":"n8n-nodes-base.merge","position":[3080,220],"parameters":{"numberInputs":3},"typeVersion":3},{"id":"46af5694-6b28-45e7-8b1b-d77482b326e7","name":"Map image summaries","type":"n8n-nodes-base.set","position":[2020,280],"parameters":{"options":{},"assignments":{"assignments":[{"id":"11592bed-7555-4e61-a692-d71b1a733fd4","name":"content","type":"string","value":"={{ $json.content }}"}]}},"typeVersion":3.4},{"id":"dc5858b7-c30b-413b-a1d0-143a068f2c87","name":"Upload attachments","type":"n8n-nodes-base.googleDrive","position":[1440,480],"parameters":{"name":"={{$now.format('yyyyLLddhhiiss')}}-{{ $binary.data.fileName }}","driveId":{"__rl":true,"mode":"list","value":"My Drive"},"options":{},"folderId":{"__rl":true,"mode":"list","value":"1CV5PgqBQIVFEacmbApdCApjNEtoNPzXQ","cachedResultUrl":"https://drive.google.com/drive/folders/1CV5PgqBQIVFEacmbApdCApjNEtoNPzXQ","cachedResultName":"Analyze attachments"}},"credentials":{"googleDriveOAuth2Api":{"id":"HEy5EuZkgPZVEa9w","name":"Google Drive account (n3w.it)"}},"typeVersion":3},{"id":"9537f678-163c-40de-93f3-9934f4ae2ad0","name":"Email summary","type":"n8n-nodes-base.set","position":[2000,800],"parameters":{"options":{},"assignments":{"assignments":[{"id":"ef348518-a9fb-4ea9-bd70-9dcf3bff092a","name":"content","type":"string","value":"={{ $json.response.text }}"}]}},"typeVersion":3.4},{"id":"ba0c45d9-7d5a-413e-9034-3e22a79ead77","name":"Send final summary","type":"n8n-nodes-base.telegram","position":[4340,220],"webhookId":"9c8e4675-762e-47dd-8cef-b94a5261ffd4","parameters":{"text":"={{ $json.text }}","chatId":"CHAT_ID","additionalFields":{}},"credentials":{"telegramApi":{"id":"0hSq9VwaiJifiscT","name":"Telegram account"}},"typeVersion":1.2},{"id":"7a97052b-37c5-4754-ac1a-0f1a20569df7","name":"Create final summary","type":"@n8n/n8n-nodes-langchain.chainLlm","position":[3940,220],"parameters":{"text":"=The inputs to synthesize are:n'''n{{ $json.output }}n'''","messages":{"messageValues":[{"message":"## Comprehensive Email Analysis System PromptnnYou are a specialized AI assistant tasked with creating a unified, concise summary of an email and all its attachments. Your input includes a summary of the email text, summaries of any images, and summaries of any PDF attachments. Your goal is to synthesize all this information into a single coherent summary that captures the essential message and purpose.nn### Your responsibilities:nn1. Identify the overarching theme or purpose connecting the email and its attachmentsn2. Recognize relationships between the email content and the attached materialsn3. Extract and consolidate the most critical information from all sourcesn4. Maintain proper context when combining information from different sourcesn5. Prioritize information based on relevance to the email's main purposen6. Create a unified narrative that flows logically between email content and attachmentsnn### Input structure:n- Email summary: A summary of the main email textn- Image descriptions: Summaries of any images attached to the emailn- PDF summaries: Condensed versions of any PDF documents attachednn### Output format:nn- Provide your summary in plain text onlyn- Begin with a one-sentence statement of the email's overall purpose and themen- Present a unified narrative that integrates information from the email and all attachmentsn- Organize information by importance and relevance, not by sourcen- Keep the final summary concise (5-7 sentences maximum) while including all essential informationn- Use clear transitions to maintain coherence when moving between different information sourcesn- Preserve the original intent and tone of the communicationnn### What to include:nn- The main topic and purpose of the communicationn- Key points from both the email and attachmentsn- Critical requests, deadlines, or action itemsn- Essential details like dates, figures, or specific referencesn- Contextual information that clarifies the purpose of attachmentsnn### What to exclude:nn- Redundant information repeated across multiple sourcesn- Minor details that don't contribute to understanding the main messagen- Excessive descriptions of attachments beyond their relevance to the email's purposen- Your own interpretations beyond what's supported by the input materials"}]},"promptType":"define"},"typeVersion":1.5},{"id":"99b4c22c-a29b-4b72-bc4a-bed5c1320386","name":"Save summary image","type":"n8n-nodes-base.googleSheets","position":[2020,20],"parameters":{"columns":{"value":{"ID":"={{ $('Email Trigger (IMAP)').item.json.metadata["x-message-id"] }}","DATE":"={{ $now.format('dd/LL/yyyy') }}","TYPE":"image","EMAIL":"={{ $('Email Trigger (IMAP)').item.json.from }}","SUBJECT":"={{ $('Email Trigger (IMAP)').item.json.subject }}","SUMMARY":"={{ $json.content }}"},"schema":[{"id":"DATE","type":"string","display":true,"required":false,"displayName":"DATE","defaultMatch":false,"canBeUsedToMatch":true},{"id":"EMAIL","type":"string","display":true,"required":false,"displayName":"EMAIL","defaultMatch":false,"canBeUsedToMatch":true},{"id":"ID","type":"string","display":true,"required":false,"displayName":"ID","defaultMatch":false,"canBeUsedToMatch":true},{"id":"SUBJECT","type":"string","display":true,"required":false,"displayName":"SUBJECT","defaultMatch":false,"canBeUsedToMatch":true},{"id":"TYPE","type":"string","display":true,"required":false,"displayName":"TYPE","defaultMatch":false,"canBeUsedToMatch":true},{"id":"SUMMARY","type":"string","display":true,"required":false,"displayName":"SUMMARY","defaultMatch":false,"canBeUsedToMatch":true}],"mappingMode":"defineBelow","matchingColumns":[],"attemptToConvertTypes":false,"convertFieldsToString":false},"options":{},"operation":"append","sheetName":{"__rl":true,"mode":"list","value":"gid=0","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1rBa0RI6XFfMerylVCV0dlKhJT_f4UAd8S6jyYX4aRRo/edit#gid=0","cachedResultName":"Foglio1"},"documentId":{"__rl":true,"mode":"list","value":"1rBa0RI6XFfMerylVCV0dlKhJT_f4UAd8S6jyYX4aRRo","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1rBa0RI6XFfMerylVCV0dlKhJT_f4UAd8S6jyYX4aRRo/edit?usp=drivesdk","cachedResultName":"Analyze Email + Attachments"}},"credentials":{"googleSheetsOAuth2Api":{"id":"JYR6a64Qecd6t8Hb","name":"Google Sheets account"}},"typeVersion":4.5},{"id":"2b32c086-c436-436e-93c3-da88e6f08247","name":"Save summary text","type":"n8n-nodes-base.googleSheets","position":[2020,1040],"parameters":{"columns":{"value":{"ID":"={{ $('Email Trigger (IMAP)').item.json.metadata["x-message-id"] }}","DATE":"={{ $now.format('dd/LL/yyyy') }}","TYPE":"email","EMAIL":"={{ $('Email Trigger (IMAP)').item.json.from }}","SUBJECT":"={{ $('Email Trigger (IMAP)').item.json.subject }}","SUMMARY":"={{ $json.response.text }}"},"schema":[{"id":"DATE","type":"string","display":true,"required":false,"displayName":"DATE","defaultMatch":false,"canBeUsedToMatch":true},{"id":"EMAIL","type":"string","display":true,"required":false,"displayName":"EMAIL","defaultMatch":false,"canBeUsedToMatch":true},{"id":"ID","type":"string","display":true,"required":false,"displayName":"ID","defaultMatch":false,"canBeUsedToMatch":true},{"id":"SUBJECT","type":"string","display":true,"required":false,"displayName":"SUBJECT","defaultMatch":false,"canBeUsedToMatch":true},{"id":"TYPE","type":"string","display":true,"required":false,"displayName":"TYPE","defaultMatch":false,"canBeUsedToMatch":true},{"id":"SUMMARY","type":"string","display":true,"required":false,"displayName":"SUMMARY","defaultMatch":false,"canBeUsedToMatch":true}],"mappingMode":"defineBelow","matchingColumns":[],"attemptToConvertTypes":false,"convertFieldsToString":false},"options":{},"operation":"append","sheetName":{"__rl":true,"mode":"list","value":"gid=0","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1rBa0RI6XFfMerylVCV0dlKhJT_f4UAd8S6jyYX4aRRo/edit#gid=0","cachedResultName":"Foglio1"},"documentId":{"__rl":true,"mode":"list","value":"1rBa0RI6XFfMerylVCV0dlKhJT_f4UAd8S6jyYX4aRRo","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1rBa0RI6XFfMerylVCV0dlKhJT_f4UAd8S6jyYX4aRRo/edit?usp=drivesdk","cachedResultName":"Analyze Email + Attachments"}},"credentials":{"googleSheetsOAuth2Api":{"id":"JYR6a64Qecd6t8Hb","name":"Google Sheets account"}},"typeVersion":4.5},{"id":"135bf3c3-e45f-4363-857b-2345e0bc7964","name":"Convert text","type":"n8n-nodes-base.markdown","position":[860,940],"parameters":{"html":"={{ $json.textHtml }}","options":{}},"typeVersion":1},{"id":"0c2cf33a-d7bb-438d-a9c9-06a77f91b56e","name":"Gemini 2.0 Flash","type":"@n8n/n8n-nodes-langchain.lmChatOpenRouter","position":[1700,-320],"parameters":{"model":"google/gemini-2.0-flash-exp:free","options":{}},"credentials":{"openRouterApi":{"id":"pb06rfB4xmxzVe3Q","name":"OpenRouter"}},"typeVersion":1},{"id":"50d5fd05-db5f-451c-92ce-e0f42d8322f9","name":"Parsing","type":"n8n-nodes-base.code","position":[3360,220],"parameters":{"jsCode":"const inputData = $input.all();nnconst outputData = inputData.map(item => {n n const outputValue = item.json.output || item.json.content;nn return {n data: {n output: outputValue n }n };n});nnreturn outputData;"},"typeVersion":2},{"id":"801659a1-cc9d-4014-9403-d6d0952e856a","name":"Sticky Note1","type":"n8n-nodes-base.stickyNote","position":[520,220],"parameters":{"width":260,"height":240,"content":"Get all attachments present in the email (in this WF only PDFs and images are considered)"},"typeVersion":1},{"id":"15dc13b9-b35c-43d3-8af9-a8793382a2b6","name":"Sticky Note2","type":"n8n-nodes-base.stickyNote","position":[1740,-600],"parameters":{"width":340,"height":200,"content":"Analyze the content of PDF files and make a summary for each one"},"typeVersion":1},{"id":"6c68ce17-13f1-4aba-9f43-e4003e5cd723","name":"Sticky Note3","type":"n8n-nodes-base.stickyNote","position":[1380,120],"parameters":{"height":200,"content":"Analyze the content of the image and describe it accurately"},"typeVersion":1},{"id":"ff746258-dc11-43aa-afe9-06c9dfb3708b","name":"Analyze image","type":"@n8n/n8n-nodes-langchain.openAi","position":[1440,180],"parameters":{"text":"## Image Analysis System PromptnnYou are a specialized AI assistant focused on analyzing images. Your task is to carefully examine the image provided as input and produce a detailed, accurate description in plain text format.nn### Your responsibilities:nn1. Observe and describe the main subject(s) or focal point(s) of the imagen2. Identify notable objects, people, animals, or other elements presentn3. Describe the setting, background, and environment if applicablen4. Note any text visible in the image, transcribing it accuratelyn5. Recognize any actions, activities, or events taking placen6. Identify relevant contextual information (time of day, weather, season, etc.)n7. Describe colors, lighting, composition, and other visual elements when relevantnn### Response format:nn- Provide your analysis in plain text only (no HTML, markdown, or other formatting)n- Begin with a concise overview of what the image depictsn- Follow with a detailed description covering all significant elementsn- Organize information logically, typically moving from main subjects to background detailsn- Use clear, descriptive language that accurately represents what is actually visiblen- Keep descriptions objective and factualnn### What to exclude:nn- Speculation about elements not clearly visible in the imagen- Subjective judgments or interpretations beyond what is objectively presentn- Personal opinions about the quality or purpose of the imagen- Complex technical analysis unless specifically relevantn- Any formatting beyond plain textnnThe image to analyze is the one provided in the input.","modelId":{"__rl":true,"mode":"list","value":"gpt-4o-mini","cachedResultName":"GPT-4O-MINI"},"options":{},"resource":"image","inputType":"base64","operation":"analyze"},"credentials":{"openAiApi":{"id":"CDX6QM4gLYanh0P4","name":"OpenAi account"}},"typeVersion":1.8},{"id":"ce353f02-72ff-49bf-9297-5a2b3229fa49","name":"Sticky Note4","type":"n8n-nodes-base.stickyNote","position":[1340,740],"parameters":{"width":320,"height":180,"content":"Analyze the content of the email and summarize it"},"typeVersion":1},{"id":"01ee4c00-5993-47ce-af04-320cd3319593","name":"Sticky Note5","type":"n8n-nodes-base.stickyNote","position":[3060,100],"parameters":{"width":720,"height":80,"content":"All the summaries of the email components (text, PDF, images) are aggregated and a final summary is generated"},"typeVersion":1}],"active":false,"pinData":{},"settings":{"executionOrder":"v1"},"versionId":"30310971-f23c-4761-823c-36ddad8bc8dd","connections":{"Switch":{"main":[[{"node":"Upload attachments","type":"main","index":0},{"node":"Extract from PDF","type":"main","index":0}],[{"node":"Upload attachments","type":"main","index":0},{"node":"Analyze image","type":"main","index":0}]]},"Parsing":{"main":[[{"node":"Aggregate","type":"main","index":0}]]},"Aggregate":{"main":[[{"node":"Create final summary","type":"main","index":0}]]},"Split Out":{"main":[[{"node":"All summaries","type":"main","index":0}]]},"DeepSeek R1":{"ai_languageModel":[[{"node":"Email Summarization Chain","type":"ai_languageModel","index":0}]]},"Convert text":{"main":[[{"node":"Email Summarization Chain","type":"main","index":0}]]},"PDF Analyzer":{"main":[[{"node":"Save summary PDF","type":"main","index":0},{"node":"Split Out","type":"main","index":0}]]},"All summaries":{"main":[[{"node":"Parsing","type":"main","index":0}]]},"Analyze image":{"main":[[{"node":"Save summary image","type":"main","index":0},{"node":"Map image summaries","type":"main","index":0}]]},"Email summary":{"main":[[{"node":"All summaries","type":"main","index":2}]]},"Extract from PDF":{"main":[[{"node":"PDF Analyzer","type":"main","index":0}]]},"Gemini 2.0 Flash":{"ai_languageModel":[[{"node":"PDF Analyzer","type":"ai_languageModel","index":0}]]},"Save summary PDF":{"main":[[]]},"Save summary text":{"main":[[]]},"Save summary image":{"main":[[]]},"Upload attachments":{"main":[[]]},"Map image summaries":{"main":[[{"node":"All summaries","type":"main","index":1}]]},"Contain attachments?":{"main":[[{"node":"Get PDF and images attachments","type":"main","index":0},{"node":"Convert text","type":"main","index":0}],[{"node":"Convert text","type":"main","index":0}]]},"Create final summary":{"main":[[{"node":"Send final summary","type":"main","index":0}]]},"Email Trigger (IMAP)":{"main":[[{"node":"Contain attachments?","type":"main","index":0}]]},"OpenRouter Chat Model1":{"ai_languageModel":[[{"node":"Create final summary","type":"ai_languageModel","index":0}]]},"Structured Output Parser":{"ai_outputParser":[[{"node":"PDF Analyzer","type":"ai_outputParser","index":0}]]},"Email Summarization Chain":{"main":[[{"node":"Save summary text","type":"main","index":0},{"node":"Email summary","type":"main","index":0}]]},"Get PDF and images attachments":{"main":[[{"node":"Switch","type":"main","index":0}]]}}}
  • CSV
  • Sheet
  • Spreadsheet
  • GS
  • human
  • form
  • wait
  • hitl
  • approval
  • cpde
  • Javascript
  • JS
  • Python
  • Script
  • Custom Code
  • Function
  • LangChain
  • json
  • zod
  • ChatGPT
  • DallE
  • whisper
  • audio
  • transcribe
  • tts
  • assistant
Planeta AI 2025 
magic-wandmenu linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram