Read in an Excel spreadsheet file
How to take the path of a local Excel file and read its contents into n8n.
Time logging on Clockify using Slack
Time Logging on Clockify Using Slack How it works This workflow simplifies time tracking for teams and agencies by integrating Slack with Clockify. It enables users to log, update, or delete time entries directly within Slack, leveraging an AI-powered assistant for seamless and conversational interactions. Key features include: Effortless Time Logging: Create and manage time entries in Clockify without leaving Slack. AI-Powered Assistant: Get step-by-step guidance to ensure accurate and efficient time logging. Project and Client Management: Retrieve project and client information from Clockify effortlessly. Overlap Prevention: Avoid overlapping entries with built-in time validation. Automated Descriptions: Generate ethical, grammatically correct descriptions for time logs. Set up steps Prepare your integrations Ensure you have active accounts for both Slack and Clockify. Generate your Clockify API credentials for integration. Import the workflow Download and import the workflow template into your n8n instance. Configure the workflow to connect with your Slack and Clockify accounts. Configure the workflow Add your Clockify API credentials in the workflow settings. Set up the Slack Trigger to listen for app mentions or specific commands. Test the workflow Use Slack to create a time entry and verify it in Clockify. Test updating and deleting existing entries to ensure smooth functionality. Check for any overlapping time logs or incorrect data entries. Why use this workflow? Efficiency: Eliminate the need to switch between tools for time tracking. Accuracy: AI-driven validation ensures error-free entries. Automation: Simplify repetitive tasks like updating or deleting time logs. Proactive Guidance: Conversational assistant ensures smooth operations.
Send a file from S3 to AWS Textract
This workflow shows how to download an image file from S3 and pass it on to Textract for text extraction. The workflow uses two nodes: AWS S3: This node will download a receipt file from S3 AWS Textract: This node connects to Aamazon's Textract service to extract text from the receipt file
Streamline your Zoom meetings with secure, automated Stripe payments
🎉 Do you want to master AI automation, so you can save time and build cool stuff? I’ve created a welcoming Skool community for non-technical yet resourceful learners. 👉🏻 Join the AI Atelier 👈🏻 --- Unlock streamlined Zoom Meeting organization and exclusive access management with this n8n workflow. Designed for educators, event organizers, and businesses, this tool automates your event logistics, so you can focus on delivering valuable content. Features Zoom Meetings Creation: Instantly generate new Zoom meetings with the n8n built-in form. Collect Payments Using Stripe: Effortlessly monetize your events with secure, automatically created Stripe payment pages for each meeting. Exclusive Gated Access: Ensure your content remains exclusive by sending Zoom meeting passwords only to verified subscribers who have completed their payment through Stripe. Participants Email Notifications: Automate the distribution of Zoom meeting details post-payment, eliminating the need for manual email management and ensuring participants are promptly informed. Instant and Easy Participants Overview: Manage and track your event registrations with ease. All related data is stored in a Google Sheets document that you own. You're notified via email with each new subscription, simplifying participant management. Set Up Steps Connect your Zoom, Stripe, Gmail and Google Sheet credentials. Create an empty Google Sheet in your Google Drive. Fill the config node (Sheet URL, email and currency). Edit email text. This n8n workflow template is designed to minimize setup time and maximize efficiency, allowing you to focus on delivering value to your subscribers. With just a few clicks, you can automate the entire process of organizing and monetizing your Zoom meetings. Created by the n8ninja.
Make every product photo look like a luxury ad fully automated AI + google drive
Watch the video to better understand this workflow : ARRE-automation Good to know: This workflow automatically processes product images from Google Drive, generates AI-powered background prompts using multiple AI models (ChatGPT, Claude, or Groq), creates professional background scenes using Pixelcut.ai, and saves enhanced images back to your Google Drive. Perfect for e-commerce businesses and product photography workflows. Who is this for? ➖E-commerce store owners who need professional product backgrounds ➖Product photographers looking to automate background generation ➖Marketing teams creating consistent product imagery ➖Small businesses wanting to enhance their product photos without expensive studio setups ➖Anyone who needs to quickly transform transparent product images into commercial-ready photos What problem is this workflow solving? This workflow solves the challenge of creating professional product photography backgrounds at scale. Instead of manually editing each product image or setting up expensive photo shoots, it automatically generates contextually appropriate backgrounds for your products using AI technology. It eliminates the time-consuming process of background creation while maintaining professional quality and consistency across your product catalog. What this workflow does: ✅Automatically fetches product images from your Google Drive folder ✅Downloads transparent/background-free product images ✅Uses advanced AI models (ChatGPT, Claude, or Groq) to generate intelligent background prompts based on product analysis ✅Creates professional backgrounds using Pixelcut.ai API with AI-generated or custom prompts ✅Saves enhanced product images back to Google Drive with organized naming ✅Processes multiple images in batch automatically How it works: 1️⃣Google Drive node searches for PNG product images in your specified folder 2️⃣Binary download node retrieves the actual image files for processing 3️⃣Optional AI agent analyzes products using your chosen AI model (OpenAI GPT-4, Claude, or Groq) and generates appropriate background prompts 4️⃣Pixelcut.ai API processes images and adds professional backgrounds using AI-generated or manual prompts 5️⃣Enhanced images are automatically saved back to Google Drive with "enhanced-" prefix How to use: Set up Google Drive OAuth2 credentials in n8n Create a Pixelcut.ai account and get your API key Configure your source folder ID in the Google Drive nodes Set up your output folder ID for enhanced images Choose and configure your preferred AI model credentials (OpenAI for ChatGPT, Anthropic for Claude, or Groq) Replace placeholder API keys with your actual credentials Execute the workflow to process your product images Requirements: ✅n8n instance (cloud or self-hosted) ✅Google Drive account with OAuth2 access ✅Pixelcut.ai API account and key ✅Product images in PNG format (transparent backgrounds recommended) ✅AI API credentials for automatic prompt generation (choose from): OpenAI API (for ChatGPT/GPT-4) Anthropic API (for Claude) Groq API (for fast inference) ✅Basic understanding of n8n workflows Customizing this workflow: 🟢Modify the image format filter to support JPG, WEBP, or other formats 🟢Switch between different AI models (ChatGPT, Claude, Groq) for prompt generation 🟢Customize background prompts for different product categories 🟢Add background removal step for products with existing backgrounds 🟢Switch to different AI background services (Deep-Image.ai, Remove.bg, etc.) 🟢Configure different AI model parameters for varied prompt creativity 🟢Add image resizing or quality optimization steps 🟢Create multiple output folders for different product categories 🟢Add error handling and retry mechanisms for failed processes 🟢Implement A/B testing with different AI models for prompt quality comparison
Automated book summarization with DeepSeek AI, Qdrant Vector DB & Google Drive
📚 AI Book Summarizer with Vector Search – n8n Automation Overview This n8n workflow automates the process of summarizing uploaded books from Google Drive using vector databases and LLMs. It uses Cohere for embeddings, Qdrant for storage and retrieval, and DeepSeek or your preferred LLM for summarization and Q\&A. Designed for researchers, students, and productivity enthusiasts! Result Example --- Problem 🛠️ ⏳ Reading full books or papers to extract core ideas can take hours. 🧠 Manually summarizing or searching inside long documents is inefficient and overwhelming. --- Solution ✅ Use this workflow to: Upload a book to Google Drive 📥 Auto-split and embed the content into Qdrant 🔍 Summarize it using DeepSeek or another LLM 🤖 Store the final summary back to Google Drive 📤 Clean up the vector store afterward 🧹 --- 🔥 Result ⚡ Instant AI-generated book summary 💡 Ability to perform semantic search and question-answering 📁 Summary saved back to your cloud 🧠 Enhanced productivity for learning and research --- Setup ⚙️ (4–8 minutes) Google Drive Setup 🔗 Connect Google Drive credentials 📁 Create an input folder (e.g., book_uploads) 📁 Create an output folder (e.g., book_summaries) ⚡ Trigger: Use File Created node to monitor book_uploads 📥 Summary will be saved in book_summaries LLM & Embeddings Setup 🔑 Create and test API keys for: DeepSeek/OpenAI for summarization Cohere for embeddings Qdrant for vector storage 🧪 Ensure all credentials are added in n8n --- How It Works 🌟 📂 A file is uploaded to Google Drive ⬇️ File is downloaded 🧱 It's processed, split into chunks, and sent to Qdrant using Cohere embeddings ❓ A Q\&A chain with vector retriever performs information extraction 🧠 A DeepSeek AI Agent analyzes and summarizes the book 📤 The summary is saved to your Drive 🧽 The Qdrant vector collection is deleted (clean-up) --- What’s Included 📦 ✅ Google Drive integration (input/output) ✅ File chunking and embedding using Cohere ✅ Vector storage with Qdrant ✅ Q\&A with vector retrieval ✅ Summarization via DeepSeek or other LLM ✅ Clean-up for minimal storage overhead --- Customization 🎨 You can tailor it to your use case: 🧑🏫 Adjust summarization prompt for study notes or executive summaries 🌍 Add translation node for multilingual support 🔍 Enable long-term memory by skipping vector deletion 📨 Send summaries to Notion, Slack, or Email 🧩 Use other LLM providers (OpenAI, Claude, Gemini, etc.) --- 🌐 Explore more workflows ❤️ Buy more workflows at: adamcrafts 🦾 Custom workflows at: adamcrafts@cloudysoftwares.com adamaicrafts@gmail.com > Build once, customize endlessly, and scale your video content like never before. 🚀
Send n8n error reports to LINE
This workflow template, "n8n Error Report to LINE," is designed to streamline error handling by sending real-time notifications to your LINE account whenever an error occurs in any of your n8n workflows. By integrating with the LINE Messaging API , this template ensures you stay informed about workflow failures, allowing you to take immediate action and minimize downtime. Whether you're a developer managing multiple workflows or a business owner relying on automation, this template provides a simple yet powerful way to monitor and resolve errors efficiently. Who Is This Template For? Developers: Who manage complex n8n workflows and need real-time error notifications. DevOps Teams: Looking to enhance monitoring and incident response for automated systems. Business Owners: Who rely on n8n workflows for critical operations and want to ensure reliability. Automation Enthusiasts: Seeking tools to simplify error tracking and improve workflow performance. What Problem Does This Workflow Solve? When automating processes with n8n, errors can occur due to various reasons such as misconfigurations, API changes, or unexpected inputs. Without proper error handling, these issues may go unnoticed, leading to delays or disruptions. This workflow solves that problem by: 1) Automatically detecting errors in your n8n workflows. 2) Sending instant notifications to your LINE account with details about the failed workflow, including its name and execution URL. Allowing you to quickly identify and resolve issues, ensuring smooth operation of your automated systems. What This Workflow Does 1) Error Trigger: The workflow is triggered automatically whenever an error occurs in any n8n workflow configured to use this error-handling flow. 2) Send Notification via LINE: Using the LINE Push API , the workflow sends a message to your LINE account with key details about the error, such as the workflow name and execution URL. You can also customize the notification message to include additional information or format it to suit your preferences. Setup Guide Pre-Requisites Access to the LINE Developers Console with a registered bot and access to the Push API. https://developers.line.biz/console/ [API Reference]( https://developers.line.biz/en/reference/messaging-api/send-narrowcast-message) Basic knowledge of n8n workflows and JSON formatting. An active n8n instance where you can configure error workflows. Step-by-Step Setup Configure the Error Trigger: Set this workflow as the default error workflow in your n8n instance. https://docs.n8n.io/flow-logic/error-handling/ Set Up LINE Push API: Replace <UID HERE> in the HTTP Request node with your LINE user ID to ensure notifications are sent to the correct account.
Create evergreen content with GitHub dynamic images & URL redirects
Transform static digital assets into dynamic, self-updating powerhouses that stay relevant for years to come! This workflow solves a common problem: once you publish forms, emails, or templates, their content becomes frozen in time. Users discovering them months later see outdated information, missed opportunities, and stale offers. Stop losing opportunities to stale content – make your digital assets work harder and stay fresher, automatically! Here's how it works: 🔗 Stable embed links mean your original assets never need updating 🔄 Dynamic URL redirects that automatically point to the latest pages 🖼️ Auto-updating images that showcase fresh offers or content 📅 Scheduled updates keep everything current without manual intervention Perfect for: Workflow sticky notes that become evergreen marketing billboards Registration forms with current promotions Email signatures with latest offers Website banners that stay seasonally relevant Any digital asset you want to "future-proof" The magic: Set it up once, embed the stable URLs/images in your content, then forget about it. Years later, users will still see fresh, as current information automatically pulled from your workflow. Requirements: Free accounts with GitHub (image storage) and shorten.rest (URL redirects). Both can be swapped for your preferred services. --- Follow me on LinkedIn for more tips on AI automation and n8n workflows!
Auto-clean Gmail spam folder - monthly using Gmail API
This automated n8n workflow uses the Gmail API to clean the spam folder by permanently deleting all emails on the first day of each month. The system ensures efficient email management and improves Gmail storage by removing unwanted spam emails. Good to Know Gmail API rate limits should be respected to ensure proper email fetching A short delay is introduced to avoid hitting API limits The workflow runs automatically on the first day of every month Improves Gmail hygiene by removing spam emails How It Works Monthly Trigger (1st Day) - Starts the workflow automatically on the first of every month to perform email cleanup Fetch Gmail Emails - Uses Gmail API to retrieve all emails in the spam folder for the Gmail account Pause Before Deletion (5s) - Introduces a short delay to avoid hitting Gmail's API rate limits and ensure all emails are fetched properly Delete Fetched SPAM Emails - Permanently deletes all retrieved emails from the spam folder to free up Gmail space and improve email hygiene How to Use Import the workflow into n8n Configure Gmail API credentials for access Test the workflow on a sample date to verify email fetching and deletion Adjust the pause duration if needed based on API limits Monitor the workflow to ensure proper spam cleanup Requirements Gmail API credentials Customizing This Workflow Adjust the pause duration in the Pause node to align with Gmail API rate limits Modify the trigger schedule if a different cleanup frequency is preferred
Automated B2B lead management and AI outreach
This workflow is a comprehensive, production-grade automation for B2B lead management and multichannel outreach, designed for Sales Development Representatives (SDRs), growth teams, and sales operations. It covers the entire SDR pipeline: from lead ingestion and validation, through enrichment, scoring, AI-powered outreach, reply handling, analytics, and reporting. Key Features: Lead validation (email, suppression, geo/GDPR) Multi-source data enrichment Lead scoring and tiering (HIGH/MEDIUM/LOW) AI-generated personalized cold emails (with A/B subject testing) Multichannel outreach (Email, LinkedIn, WhatsApp) with rate limiting and compliance AI-based reply simulation and intent classification Automated routing (qualification, follow-up, manual review) Full event logging to database Aggregated analytics and daily reporting Human-readable AI summary and Slack notifications --- What This Workflow Does Lead Ingestion & Validation Loads leads from a source (test data, CRM, webhook, etc.) Validates email format and checks against suppression lists (blocked domains/emails) Applies geo and GDPR compliance logic (blocks/flags leads from restricted countries) Data Enrichment Enriches each lead via one or more external APIs (company info, tech stack, revenue, etc.) Handles enrichment failures gracefully and logs them for analytics Lead Scoring & Segmentation Scores leads based on industry, country, company size, revenue, and pain points Segments leads into HIGH, MEDIUM, or LOW tiers for tailored outreach AI-Powered Outreach Generation Uses OpenAI (or compatible LLM) to generate personalized cold email content Creates A/B tested subject lines for each email Generates LinkedIn and WhatsApp message variants for multichannel outreach Multichannel Outreach Execution Sends emails via SMTP (with rate limiting and quiet hours) Simulates LinkedIn and WhatsApp sends (can be replaced with real integrations) Logs all outreach events to a Postgres database Reply Simulation & AI Classification Simulates a variety of lead replies (interested, not interested, follow-up, unclear) Uses AI to classify reply intent and suggest next actions Automated Routing & Follow-up Routes leads based on AI classification: Interested: Schedules meeting, logs qualification, proposes follow-up Follow-up Later: Schedules future follow-up Not Interested: Marks as closed/lost Unclear: Flags for manual review and notifies team via Slack Event Logging & Analytics Logs every significant event (enrichment, outreach, reply, status change) to a database Aggregates results by lead score, channel, and status Calculates key metrics (qualification rate, enrichment success, multichannel rate, etc.) Reporting & Team Notification Generates a daily analytics row and stores it in the database Uses AI to create a human-readable summary of the run Posts a detailed summary to a Slack channel --- Use Cases Automated SDR Workflows: Replace manual lead research, outreach, and follow-up with a fully automated, auditable process. Growth Experiments: Run A/B tests on messaging, subject lines, and channels at scale. Sales Analytics: Get transparent, granular reporting on every step of the SDR funnel. Compliance-First Outreach: Ensure all outreach respects geo, GDPR, and suppression rules. AI-Driven Personalization: Use LLMs to generate highly relevant, non-generic outreach at scale. --- Installation & Setup Import the Workflow Download or copy the workflow from the n8n Template Store. In your n8n editor, click Import and paste the workflow JSON, or use the "Use Template" button. Configure Required Credentials Postgres: Set up a Postgres credential for event and analytics logging. SMTP: Add your email provider's SMTP credentials for sending emails. OpenAI: Add your OpenAI API key for AI-powered nodes. Slack: Add your Slack API credential for notifications. Enrichment APIs: Add credentials for any external enrichment APIs you use. Customize Lead Source Replace the test data in the Load Test Leads node with your real lead source (e.g., webhook, CRM, Google Sheets, etc.). Adjust Compliance & Suppression Logic Update the suppression lists and geo/GDPR logic in the relevant nodes to match your organization's requirements. Review Multichannel Logic The workflow simulates LinkedIn and WhatsApp sends. Replace these with real integrations if needed. Database Preparation Ensure your Postgres database has the following tables (or adjust node configs): lead_events (for all event logs) analytics_daily (for daily summary rows) meetings (for scheduled meetings) execution_runs (for workflow run metadata) Test the Workflow Run the workflow manually with sample data. Check the database and Slack for logs and notifications. Review AI-generated content for tone and compliance. --- Configuration Details Rate Limiting: Email, LinkedIn, and WhatsApp sends are rate-limited and respect quiet hours. A/B Testing: Each email uses a randomly selected subject variant for ongoing optimization. AI Models: Uses OpenAI GPT-4o-mini by default; can be swapped for other models. Event Logging: Every action (enrichment, outreach, reply, status change) is logged with timestamp and payload for full traceability. Analytics: Aggregates by lead score, channel, and status; calculates rates and averages. Slack Notifications: Posts a summary of each run, including key metrics and AI-generated insights. --- Advanced Customization Add/Replace Enrichment APIs: Plug in any HTTP-based enrichment service. Custom Lead Scoring: Adjust the scoring logic in the Compute Lead Score node to fit your ICP. Custom AI Prompts: Edit the system messages in AI nodes for your brand voice. Additional Channels: Integrate SMS, phone, or other channels as needed. Webhook Triggers: Replace manual trigger with webhook for real-time automation. --- Requirements n8n version 1.123.0 or later Postgres database (or adapt for your DB) SMTP email provider OpenAI API key (or compatible LLM) Slack workspace (for notifications) (Optional) Enrichment API keys --- Template Store Submission Notes All credentials are handled via n8n's credential system (no hardcoded secrets). The workflow is modular, well-commented, and ready for production use. All event and analytics logging is auditable and GDPR-compliant. Please review and test all integrations in your environment before using in production. --- Example Analytics Output | Metric | Value | |-----------------------|---------| | Total Leads | 100 | | Qualified | 22 | | Follow-up Scheduled | 15 | | Closed Lost | 40 | | Manual Review | 3 | | Qualification Rate | 22% | | Enrichment Success | 90% | | Multichannel Rate | 60% | --- Ready to automate your SDR pipeline? Import this workflow and start scaling your B2B outreach today!
Recover failed Stripe payments with AI emails (by FlyCode)
⚙️ Automated Stripe Failed Payment Recovery (with Postmark + AI Email Generator) Recover failed Stripe subscription payments with AI-personalized emails sent via Postmark. 📝 Template Description Recover failed subscription payments automatically with Stripe, Postmark, and AI. This workflow listens for Stripe invoice.payment_failed webhooks, checks that the event is related to an auto-charged subscription, and then automatically sends a personalized email (generated with AI) to the customer. The email is polite, branded, but also urgent — encouraging the customer to pay quickly and avoid service cancellation. --- 🛠️ How it works 📣 Webhook Listens for Stripe webhook events. Make sure to connect it in your Stripe dashboard (see setup below). 🧹 Filter (Guard) Ensures the event is indeed an invoice event and filters out unrelated webhooks. 💡 Code Node Extracts useful fields (firstName, lastName, customer email, amount, currency, invoice number, hosted invoice URL, subscription description, account name). ✅ If Node Verifies that: Event type = invoice.payment_failed Billing reason = subscription_cycle Collection method = charge_automatically 👉 This ensures only recurring subscription invoices with auto-payment are processed. 🤖 AI Agent + OpenAI Generates a ready-to-send email JSON (to, subject, HTML body) using the extracted Stripe data. ✍️ You can customize the prompt here to match your brand’s tone of voice and style. 🧩 Code Parser Parses the AI model’s JSON output into fields (toemail, emailsubject, email_body). 📧 HTTP Request (Postmark) Sends the email using Postmark’s API. You’ll need your own Postmark Server Token, From address, and Message Stream. --- 🚀 Setup Instructions Stripe Webhook Go to Stripe Dashboard → Developers → Webhooks. Click + Add endpoint. Use your n8n Webhook URL (from the Webhook node) as the endpoint. Select event type: invoice.payment_failed. Save and deploy. 👉 Example docs: Stripe: Listen to events with webhooks. Disable Stripe’s Default Failed Payment Emails In Stripe, go to Billing → Settings → Customer emails → Manage failed payments. Turn off “Failed payment” emails under the Revenue Recovery section. This prevents customers from receiving duplicate or conflicting emails. Postmark Setup Create a Postmark account. Add a Server and copy the Server API Token. In n8n, add Postmark credentials with this token. Configure: From = your verified sending email (must be verified in Postmark). MessageStream = typically "outbound" (or any custom stream you set up). Docs: Postmark API overview. OpenAI Setup Add your OpenAI credentials in n8n. Attach them to the OpenAI Chat Model node. You can modify the prompt in the AI Agent node to fit your company’s style. --- ✨ Customization Tips Update the AI prompt with your brand’s tone of voice (friendly, formal, playful, etc.). Adjust the HTML email design inside the prompt (button colors, footer, etc.). Add extra guard conditions (e.g., only trigger if invoice_amount > 0). Change the sending service: replace Postmark with Gmail, SMTP, or another provider. 💬 Or talk to our Billing Recovery Experts at flycode.com for hands-on help. --- ✅ Outcome Whenever a customer’s subscription payment fails, this workflow: Detects it instantly via Stripe Generates a polite but urgent recovery email Sends it automatically via Postmark Result: Fewer cancellations, higher recovered revenue, and a smoother customer experience. 💸💌