Save email attachments to Nextcloud
This workflow will take all emails you put into a certain folder, upload any attachements to Nextcloud, and mark the emails as read (configurable). Attachements will be saved with automatically generated filenames: 2021-01-01From-Sender-NameFilename-of-attachement.pdf Instructions: Allow lodash to be used in n8n (or rewrite the code...) NODEFUNCTIONALLOW_EXTERNAL=lodash (environment variable) Import workflow Set credentials for Email & Nextcloud nodes Configure to use correct folder / custom filters Activate Custom filter examples: Only unread emails: Custom Email Config = ["UNSEEN"] Filter emails by 'to' address: Custom Email Config = [["TO", "example+invoices@posteo.de"]]
By ManuAutomate hyper-personalized email outreach with AI, Gmail & Google Sheets
This n8n template from Intuz provides a complete and automated solution for hyper-personalized email outreach. It powerfully combines AI with Gmail and Google Sheets, using specific keywords and prospect data to automatically craft unique, compelling email content that boosts engagement and secures more replies. Instead of manually replying to every lead or inquiry, this template does the heavy lifting for you, ensuring every response is relevant, thoughtful, and timely. It reads each person's unique inquiry, uses OpenAI to craft a perfectly tailored and human-like response, and sends it directly from your Gmail account. Ideal for sales, marketing, and customer support teams looking to boost engagement and save hours of manual work. Use Cases: Sales Teams: Instantly follow up with new leads from your website's contact form with a personalized touch. Customer Support: Provide initial, intelligent responses to support tickets, answering common questions or acknowledging receipt of a complex issue. Marketing Automation: Nurture leads by responding to content downloads or webinar sign-ups with relevant, non-generic information. Founders & Solopreneurs: Manage all incoming business inquiries (partnerships, media, etc.) efficiently without sacrificing quality. How It Works: Trigger the Flow (Manual): Start the automation whenever you're ready to process a new batch of inquiries from your sheet. Fetch Inquiries from Google Sheets: The workflow connects to your specified Google Sheet and reads each row. It pulls the contact's First Name, Email ID, the Inquiry Intent (e.g., "Demo Request," "Pricing Inquiry"), and the full text of their Original Inquiry. Sync Your Signature: Before writing the email, an HTTP Request node dynamically fetches your display name from your Gmail account settings. This ensures the signature in the generated email (Thanks, {{Your Name}}) is always accurate. Craft a Hyper-Personalized Reply with AI: It uses this context to generate a high-quality, professional, and friendly email reply in HTML format. For example: If the intent is "Technical Support," the AI will generate a helpful, empathetic response addressing the technical issue. If the intent is "Partnership Proposal," it will draft a professional reply acknowledging the proposal and outlining the next steps. Send via Gmail: The final node takes the AI-generated message, adds a relevant subject line (e.g., "Re: Your Demo Request"), and sends it directly to the contact's email address from your connected Gmail account. This process loops for every single row in your Google Sheet, turning a list of names into a series of meaningful conversations. Setup Instructions: To get this workflow running, you'll need to configure a few things: Credentials: Google: Connect your Google account via OAuth2 and ensure you have enabled access for Google Sheets, Google Drive, and Gmail. OpenAI: Add your OpenAI API key as a credential. Google Sheet Setup: Create a Google Sheet with the following exact column headers: -First Name -Email ID -Inquiry Intent (A short category like "Demo Request", "Billing Issue", etc.) -Original Inquiry (The full text of the email or message you received). Node Configuration: Get row(s) in sheet: Select your Google Sheet document and the specific sheet name. Message a model (OpenAI): Choose your preferred OpenAI model (e.g., gpt-4-turbo, gpt-3.5-turbo). HTTP Request & Send Personalized emails: These nodes should automatically use your configured Gmail credentials. No changes are typically needed. Connect with us Website: https://www.intuz.com/services Email: getstarted@intuz.com LinkedIn: https://www.linkedin.com/company/intuz Get Started: https://n8n.partnerlinks.io/intuz For Custom Worflow Automation Click here- Get Started
By Intuz AI social media caption creator creates social media post captions in Airtable
Welcome to my AI Social Media Caption Creator Workflow! What this workflow does This workflow automatically creates a social media post caption in an editorial plan in Airtable. It also uses background information on the target group, tonality, etc. stored in Airtable. This workflow has the following sequence: Airtable trigger (scan for new records every minute) Wait 1 Minute so the Airtable record creator has time to write the Briefing field retrieval of Airtable record data AI Agent to write a caption for a social media post. The agent is instructed to use background information stored in Airtable (such as target group, tonality, etc.) to create the post. Format the output and assign it to the correct field in Airtable. Post the caption into Airtable record. Requirements Airtable Database: Documentation AI API access (e.g. via OpenAI, Anthropic, Google or Ollama) Example of an editorial plan in Airtable: Editorial Plan example in Airtable For this workflow you need the Airtable fields "createdat", "Briefing" and "SoMeText_AI" Feel free to contact me via LinkedIn, if you have any questions!
By Friedemann SchuetzTurn YouTube transcripts into newsletter drafts using Dumpling AI + GPT-4o
🧾 What this workflow does This workflow turns YouTube video links into ready-to-edit newsletter drafts using Dumpling AI and GPT-4o. It reads new video URLs from a Google Sheet, extracts their transcripts, summarizes them into email-friendly content, and logs the finished draft back into the same sheet. An email notification is also sent to alert the user once each draft is created. --- 👤 Who is this for Newsletter writers or marketers repurposing video content YouTube creators building email follow-ups from videos Agencies or VAs batching social → email content Automation users streamlining content workflows --- ⚙️ How to set up ✅ Requirements Google Sheet with the following columns: link — YouTube video URL blog post — for saving the generated newsletter draft Active accounts for: Dumpling AI (API for YouTube transcripts) OpenAI GPT-4 or GPT-4o Google Sheets Gmail (OAuth2 credential) --- 🔧 Setup steps Connect all credentials using n8n's Credential Manager: Google Sheets (OAuth2) Dumpling AI (via HTTP Header Auth) OpenAI Gmail Update the sheet ID and tab name in both Google Sheets nodes. Customize the GPT-4o prompt (optional): Located in the “GPT-4o: Write Newsletter Draft from Transcript” node You can edit tone, structure, and audience targeting in the system message Verify email recipient in the Gmail node and update if needed. --- 🧠 How it works The workflow is triggered manually or on schedule. It pulls YouTube links without drafts from the sheet. Each video’s transcript is fetched using Dumpling AI. GPT-4o summarizes the transcript into a clean, friendly newsletter format. The draft is written back to the same row in Google Sheets. An email is sent to notify the user that the draft is ready. --- 🛠️ Customization ideas Send finished drafts to Notion or Airtable instead of Sheets Generate social media posts from the same transcript Add automatic review steps using GPT scoring or editing Trigger this on new form submissions or YouTube uploads instead --- This is a fast, AI-powered way to turn long-form video content into clean, polished newsletters — ready to share or schedule with minimal editing.
By YangDetect and store the information about a purchase using the image of a receipt
Companion workflow for blogpost
By amudhanGet daily SMS updates about weather
Get daily SMS updates to tell you if you should wear a sweater
By tanaypantScrape product info from website URLs in Google Sheets using Dumpling AI
📄 What this workflow does This workflow automatically scrapes product information from any website URL entered into a Google Sheet and stores the extracted product details into another sheet. It uses Dumpling AI to extract product data such as name, price, description, and reviews. --- 👤 Who is this for This is ideal for: Lead generation specialists capturing product info from prospect websites eCommerce researchers collecting data on competitor product listings Sales teams building enriched product databases from lead URLs Anyone who needs to automate product scraping from multiple websites --- ✅ Requirements A Google Sheet with a column labeled Website where URLs will be added A second sheet (e.g., product details) where extracted data will be saved Dumpling AI API access to perform the extraction Connected Google Sheets credentials in n8n --- ⚙️ How to set up Replace the Google Sheet and tab IDs in the workflow with your own. Make sure your source sheet includes a Website column. Connect your Dumpling AI and Google Sheets credentials. Make sure the output sheet has the following headers: productName price productDescription (The workflow supports review, but it’s optional.) Activate the workflow to start processing new rows. --- 🔁 How it works (Workflow Steps) Watch New Website URL in Google Sheets: Triggers when a new row is added with a website URL. Extract Product Info with Dumpling AI: Sends the URL to Dumpling AI’s extract endpoint using a defined schema for product details. Split Extracted Products: Separates multiple products into individual items if the page contains more than one. Append Product Info to Google Sheets: Adds the structured results to the specified product details sheet. --- 🛠️ Customization Ideas Add a column to store the original source URL alongside each product Use OpenAI to generate short SEO summaries for each product Add filters to ignore pages without valid product details Send Slack or email notifications when new products are added to the sheet
By YangCreate a new team for a project in Notion
Creates a new team for a project from webhook form data. When the project is created the current semester is added to it's relation attribute. More info can be found on using this workflow as part of a larger system here.
By Will StenzelTelegram AI chatbot with document-based answers using OpenAI and PGVector RAG
🤖 AI Q&A Chatbot Workflow – Build Your Own AI Agent Trained on Private Documents This powerful AI automation add-on upgrades your Telegram Bot Starter Template by integrating a fully functional AI chatbot and a context-aware AI agent that answers user questions using your internal documents. Unlike generic bots, this chatbot uses your own data to respond with deeply personalized, context-relevant information — perfect for support, onboarding, internal knowledge access, and client-facing interactions. It connects to any PostgreSQL database — including Neon.tech, Supabase, or a self-hosted Postgres setup — allowing you to build custom AI-powered FAQ assistants, internal support bots, or knowledge-based customer service tools. --- 🧠 Why It Works: Contextual Retrieval The secret is Contextual Retrieval — a powerful technique where your documents are stored in a way that preserves meaning and context. This allows the AI to fetch highly relevant, source-backed responses, eliminating hallucinations and guesswork. > Data is embedded, chunked, and saved in a vector database (Postgres + PGVector), enabling smart semantic search tailored to your needs. 📖 Learn more about this approach in this article by Anthropic → --- ✨ Key Features Chat with your internal documents: Uses your content to answer questions with precision Built-in document vectorization: Pre-configured Google Drive ingestion flow (Notion, Airtable, Dropbox available separately) Contextual memory: Past chats stored in PostgreSQL for personalized conversations Plug-and-play architecture: Connect Supabase, OpenAI, custom APIs via n8n’s interface --- 👤 Who Can Use This Workflow? Entrepreneurs & startups building branded AI chatbots without code Customer support teams automating answers using documentation Ops teams creating internal FAQ bots for onboarding and training No-code developers using n8n to build Telegram bots with AI features --- ⚙️ Setup Instructions You'll find step-by-step instructions inside the workflow. Quick Setup Overview: Import the workflow into n8n (cloud or self-hosted) Add your Telegram Bot credentials Connect your PostgreSQL DB (Neon, Supabase, etc.) Set up document ingestion from Google Drive Activate the workflow and start chatting --- 🧩 Extensibility This workflow is modular and ready to expand. Build powerful assistants by connecting additional workflows: Vectorization modules for Notion, Airtable, Dropbox, and others Any vector DB: Neon.tech, Supabase, or self-hosted PGVector ✍🏻 Telegram User Registration Module → 💵 Telegram Payment, Invoicing & Refund Module → --- 🧠 More Smart AI Agents Explore more AI workflows and agents on my Gumroad → 🌐 Agent: Find in the Internet — fetches live info from the web 📁 Agent: Search Internal Docs — queries Notion, Google Drive, etc. 📦 Agent: Check Order Status — reads status from Airtable or CRM 💰 Agent: Calculate Cost or Quote — builds pricing logic from inputs 📨 Submit your idea here for a custom AI agent →
By Victor GoldAutomated daily financial analysis from Loyverse POS with Google Sheets & email
Automatically fetches daily sales, shifts, and receipts from Loyverse. Calculates gross profit, net operating profit, other key metrics, saves them to a Google Sheet and sends out a daily report via email. Who’s it for This template is for any business owner, manager, or analyst using Loyverse POS who needs more advanced financial reporting. If you're a restaurant, bar, or retail owner who wants to automatically track daily net profit, compare sales to historical averages, and build a custom financial dashboard in Google Sheets, this workflow is for you. How it works / What it does This workflow runs automatically on a daily schedule. It fetches all sales data and receipts from your Loyverse account for the previous business day, defined by your custom shift times (even past midnight). A powerful Code node then processes all the data to calculate the metrics that Loyverse either doesn't provide at all, or only spreads out across several separate reports instead of in one consolidated place. Already set up are metrics like... -Total Revenue, Gross Profit, and Net Operating Profit Cash handling differences (over/under) Average spend per receipt (ATV) 30-day rolling Net Operating Profit (NOP) Performance vs. your historical weekday average Finally, it appends the single, calculated row of daily metrics to a Google Sheet and sends an easily customizable summary report to your email. How to set up This workflow includes detailed Sticky Notes to guide you through the setup process. Because every business has a unique POS configuration (different POS devices, categories, and payment types), you'll need to set up a few things manually before executing the workflow. I've tried to make this as easy as possible to follow, and the entire setup should only take about 15 minutes. Preparations & Credential setup Subscribe to "Integrations" Add-on in Loyverse ($9 / month) to gain API access. Create an Access token in Loyverse Create Credentials: In your n8n instance, create credentials for Loyverse (use "Generic" > "Bearer Auth"), Google Sheets (OAuth2), and your Email (SMTP or other). Make a copy of a prep-configured Google Spreadsheet (Link in the second sticky note inside the workflow). Fill MASTER CONFIG: Open the MASTER CONFIG node. Follow the comments inside to add your Google Sheet ID, Sheet Names, business hours, timezone, and Loyverse IDs (for POS devices, payment types, and categories). Configure Google Sheet Nodes Configure Read Historical Data: Open this node. Follow the instructions in the nearby Sticky Note to paste the expressions for your Document ID and Sheet Name. Configure Save Product List: Open this node. Paste in the expressions for Document ID and Sheet Name. The column mapper will load; map your sheet columns (e.g., itemname) to the data on the left (e.g., {{ $json.itemname }}). Configure Save Latest Sales Data: Open this node. Paste in the expressions for Document ID and Sheet Name. Save and run the workflow. After that, the column mapper will load. This is the most important step: map your sheet's column names (e.g., "Total Revenue") to the calculated metrics from the Calculate All Metrics node (e.g., {{ $json.totalGrossRevenue }}). Activate the workflow. 🫡 Requirements Loyverse Integrations Subscription Loyverse Access Token Credentials for Loyverse (Bearer Auth) Credentials for Google Sheets (OAuth2) Credentials for Email/SMTP sender How to customize the workflow This template is designed to be highly flexible. Central Configuration: Almost all customization (POS devices, categories, payment types, sheet names) is done in the MASTER CONFIG node. You don't need to dig through other nodes. Add/Remove Metrics: The Calculate All Metrics node has additional metrics already set up, just add the relevant collumns to the SalesData sheet or even add your own calculations to the node. Any new metric you add (e.g., metrics.myNewMetric = 123) will be available to map in the Save Latest Sales Data node. Email Body: You can easily edit the Send email node to change the text or add new metrics from the Calculate All Metrics node.
By Nik B.Automate email tracking & generate pixel for lead nurturing with Google Sheet
This workflow automates the process of sending personalized lead-nurturing emails and tracking when each recipient opens the message through a custom tracking pixel. It integrates Google Sheets, Gmail, OpenAI, and webhooks to generate, deliver, and monitor engagement with your email sequence. It sends personalized emails containing a unique, invisible tracking pixel and then monitors who opens the email by detecting when the pixel is loaded, logging the activity back to a Google Sheets CRM. --- Key Features ✅ 1. Fully Automated Lead Nurturing Once leads are added to the Google Sheet, the workflow handles everything: Generating email content Creating tracking pixels Sending emails Updating CRM fields No manual actions required. ✅ 2. Real-Time Email Open Tracking Thanks to the pixel + webhook integration: You instantly know when a lead opens an email Data is written back to the CRM automatically No external email marketing platforms are needed ✅ 3. Infinite Scalability with Zero Extra Cost You can send emails and track performance using: n8n (self-hosted or cloud) Gmail Google Sheets AI-generated content This replicates features of expensive tools like HubSpot or Mailchimp—without their limits or pricing tiers. ✅ 4. Clean and Organized CRM Updates The system keeps your CRM spreadsheet structured by automatically updating: Send dates Pixel IDs Open status This ensures you always have accurate, up-to-date engagement data. ✅ 5. Easy to Customize and Expand You can easily add: Multi-step email sequences Click tracking Lead scoring Zapier/Make integrations CRM synchronization The workflow is modular, so each step can be modified or extended. --- How it Works Load Lead Data from Google Sheets The workflow reads your CRM-like Google Sheet containing lead information (name, email, and status fields such as EMAIL 1 SEND, PIXEL EMAIL 1, etc.). This allows the system to fetch only the leads that haven’t received Email 1 yet. Generate a Unique Tracking Pixel For each lead, the workflow creates a unique identifier (“pixel ID”). This ID is later appended to a small invisible 1×1 image—your tracking pixel. Example pixel structure used in emails: <img src width="1" height="1"> When the email client loads this image, n8n detects the open event via the webhook. Use AI to Generate a Personalized HTML Email An OpenAI node creates the email body in HTML, inserting the tracking pixel directly inside the content. This ensures the email is personalized, consistent, and automatically includes the tracking mechanism. Send the Email via Gmail The Gmail node sends the generated HTML email to the lead. After sending, the workflow updates the Google Sheet to log: Email sent flag Pixel ID generated Sending date Detect Email Opens with Webhook + Pixel Image When the recipient opens the email, their client loads the hidden pixel. That triggers your webhook, which: Extracts the pixel ID and email address from the query parameters Matches it with the lead in Google Sheets Update CRM When Email Is Opened The workflow updates the CRM by marking OPEN EMAIL 1 as “yes” for the corresponding pixel ID. This transforms your sheet into a live tracking dashboard of lead engagement. --- Set up Steps To configure this workflow, follow these steps: Prepare the CRM: Make a copy of the provided Google Sheet template. In your copy, fill in the "DATE," "FIRST NAME," "LAST NAME," and "EMAIL" columns with your lead data. Configure the Workflow: In the "Get CRM," "Update CRM," and "Update Open email 1" nodes, update the documentId field to point to your new Google Sheet copy. In the "Generate Pixel" node, locate the webhookurl assignment. Replace the placeholder text https://YOURN8NWEBHOOKURL with the actual, production webhook URL generated by the "Webhook" node in your n8n environment. Important: After setting this, you must activate the workflow for the webhook to be live and able to receive requests. Configure Credentials: Ensure the following credentials are correctly set up in your n8n instance: Google Sheets OAuth2 API: For reading from and updating the CRM sheet. Gmail OAuth2: For sending emails. OpenAI API: For generating the email content. Test and Activate: Execute the workflow once manually to send test emails. Check the Google Sheet to confirm that the "EMAIL 1 SEND," "PIXEL EMAIL 1," and "EMAIL 1 DATE" columns are populated. Open one of the sent test emails to trigger the tracking pixel. Verify in the Google Sheet that the corresponding lead's "OPEN EMAIL 1" field is updated to "yes." Once testing is successful, activate the workflow. --- Summary This workflow provides a powerful, low-cost automation system that: Sends personalized AI-generated emails Tracks email opens via a unique pixel Logs all actions into Google Sheets Automatically updates lead engagement data --- Need help customizing? Contact me for consulting and support or add me on Linkedin.
By DavideAssign Requests Using AI and Send Reminders Based On NocoDB Kanban Board Status
Who is it for? This is automation for support project manager, which helps not only to keep developres informed but also automatically keep clients in the loop - especially useful if you are managing SLA-like agreement. It is actually simple incident management board using free Kanban board, that is extended in functionality via N8N. How It Works? Script has two entry points. The first one is incident form. When incident details are provided, automation gets incident definitions from database and pushes both information to AI. AI comparse definitions with client request, refines incident priority and pushed it in NocoDB database. Second is schedule trigger, which is responsible for regular notificaitons on task status. If task is not picked up or delivered in proper time, then emails or slack messages are being sent both to client and responsible developer. How to set up? Clone automation Create (samples below) two NocoDB tables: one with definitions and second that servers as Kanban board (mind column naming!) Set up email and slack connection You should be ready to go Different incident naming If your incident level naming is different, you need to update few nodes and few columns in NocoDB. This is because incident naming must be unified through: automation flow, incident definitions and column NocoDB select fields. So be sure that following is the same: NocoDB: Incident definitions, column "Title" NocoDB: Tasks table, single select fields: "expected category" "assigned category" N8N: Incident Form "Incident Desired Category" NocoDB Tables Incident definitions table |Title |Definition |Response time|Resolution time|Default assignee| |single line text|text|number|number|email| Tasks table |email|message|expected category|internal notes|assigned category|status|expected response|expected resolution|assignee|assignee slack| |email|text|single select|text|single select|single select|date and time|date and time|email|slack username| Use kanban board Simply set up Kanban view and stack by "status" field. What's More? That's actually it. I hope that this automation will help your support line be much more streamlined! There is actually more that you could do with this automation, but it really depends on your needs. For example, you could add Email trigger to handle incoming support requests (but remember to adjust nodes accordingly). Another thing is that you could make different notification schema, depending on your needs (for example I do imagine that you may want a day or two delay before you notify client that task is after due). Thank you, perfect! Glad I could help. Visit my profile for other automations for businesses. And if you are looking for dedicated software development, do not hesitate to reach out!
By Łukasz