by Alejandro Alfonso
++Who is this for++ Small business owners, freelancers, and agencies who receive inbound leads through a web form and want instant, personalized follow-up — without manually reading every submission. ++What it does++ When someone fills out your lead intake form, this workflow instantly: Scores the lead 1-100 using OpenAI based on budget, project fit, and clarity Classifies them as Hot, Warm, or Cold Sends a personalized email reply that references what they actually wrote Logs everything to Google Sheets with the score and AI reasoning Hot leads get an enthusiastic reply with a calendar booking link. Warm leads get a helpful response with suggested next steps. Cold leads get a polite acknowledgment. Every lead gets a response within seconds. ++How to set up++ Fill in the "Configure Your Settings" node with your business name, email, calendar link, and description Connect your Gmail and Google Sheets credentials Add your OpenAI API key Create a Google Sheet with the column headers listed in the workflow's sticky notes Paste your Sheet URL into the "Log Lead with Score" node Activate the workflow and share the form URL Requirements n8n account (cloud or self-hosted) OpenAI API key Gmail account (OAuth2) Google Sheets (one blank sheet) How to customize Edit the OpenAI system prompt to adjust scoring criteria for your industry Modify the tier thresholds (currently Hot 70+, Warm 40-69, Cold 0-39) Customize the email tone by editing each Gmail node Add or remove form fields to match your intake need
by Jitesh Dugar
Stop chasing blurry receipts and manually typing expense data. This workflow creates an intelligent, "snap-and-submit" reimbursement pipeline that hosts photos via UploadToURL, extracts deep data via Mindee OCR, and utilizes a confidence-based gate to auto-approve low-risk expenses while routing high-value items to Slack for manager approval. 🎯 What This Workflow Does Transforms receipt photos into verified, approved expense entries in seconds: 📝 Captures Receipt Assets - Employees submit a receipt via a mobile-friendly n8n form or direct Webhook. ☁️ Instant CDN Hosting - UploadToURL converts the photo into a permanent CDN link used as "digital proof" in Expensify and Google Sheets. 👁️ Deep OCR Extraction - Mindee OCR parses the image to extract Merchant Name, Total Amount, Tax, Date, and Currency with high precision. 🚦 Confidence-Based Routing - A "Smart Gate" evaluates the OCR confidence and amount: Auto-Approve: High-confidence extractions below your set threshold (e.g., $50) are approved instantly. Manager Review: Ambiguous or high-value receipts trigger an interactive Slack message for 1-click approval. 🏦 Platform Sync - Automatically creates the expense record in Expensify and logs a detailed audit trail in Google Sheets. 📧 Employee Feedback - Sends an automated Gmail confirmation to the employee with a reimbursement ETA. ✨ Key Features UploadToURL Integration**: Native community node hosting ensures that receipt proof is always accessible via a stable URL, eliminating broken attachments. Intelligent Auto-Approval**: Reduce manager workload by up to 70% by automating approval for small, clearly-read expenses. Interactive Slack Approvals**: Managers can approve or reject expenses directly from Slack without leaving their chat interface. Comprehensive Audit Trail**: Every submission is logged in Google Sheets with OCR confidence scores and original asset links for finance audits. Mobile-First Design**: The n8n form is optimized for "snap-and-go" submissions from smartphones. 💼 Perfect For Finance & Operations Teams**: Streamlining accounts payable and employee reimbursements. Fast-Growing Startups**: Scaling internal processes without adding administrative headcount. Remote-First Companies**: Providing a centralized, digital-only path for global expense tracking. Managers**: Who want to clear approval queues instantly via mobile Slack notifications. 🔧 What You'll Need Required Integrations UploadToURL** - To host receipt photos and provide CDN links. n8n Community Node** - n8n-nodes-uploadtourl must be installed. Mindee API** - To perform high-accuracy receipt OCR. Expensify** - To create the final expense reports. Google Sheets** - To maintain the master expense audit log. Optional Integrations Slack** - For interactive manager approval buttons. Gmail** - For employee status notifications. 🚀 Quick Start Import Template - Copy the JSON and import it into your n8n canvas. Install Node - Ensure the UploadToURL community node is installed. Set Credentials - Link your UploadToURL, Mindee, Expensify, Google Sheets, and Slack accounts. Configure Thresholds - Set the AUTO_APPROVE_THRESHOLD variable (e.g., 50) in n8n. Prepare Sheet - Create a sheet named Expense Audit Log with columns for Merchant, Total, Status, and CDN URL. Go Live - Distribute the Form URL to your team and start fast-tracking reimbursements. 🎨 Customization Options Multi-Level Approval**: Add a second IF gate for expenses over $500 that requires both a Manager and a VP approval. Currency Conversion**: Insert a node to automatically convert non-USD receipts into your base company currency using real-time rates. Policy Enforcement**: Add logic to check if the Merchant is on a "blacklisted" list (e.g., gambling or non-business entertainment). ERP Integration: Replace Expensify with **NetSuite, Xero, or QuickBooks for direct accounting sync. 📈 Expected Results 80% reduction** in manual data entry for employees. Zero "Lost" Receipts**: Every submission is instantly hosted and backed up on the CDN. Faster Reimbursements**: Employees get paid in days rather than weeks thanks to auto-approvals. Finance Peace of Mind**: A perfect, link-verified audit trail in Google Sheets for every single cent spent. 🏆 Use Cases Travel & Expenses Employees on the road can snap a photo of their hotel bill or taxi receipt; the system hosts the image on UploadToURL and files the claim before they even board their flight home. Office Supply Procurement Standardize small recurring purchases (like Amazon or Staples orders) so they bypass manual review and land straight in your accounting software. Client Entertainment Automatically tag meal expenses with a "Client Gift" category based on the merchant detected, ensuring tax compliance is handled by the AI. 💡 Pro Tips Confidence Scores**: The workflow calculates a composite score. If the AI is unsure about the Merchant Name, it will route to a manager even if the amount is small. Mobile Form**: Save the n8n form URL as a "Home Screen" shortcut on employee iPhones/Androids for an app-like experience. Expensify Policies**: Ensure your EXPENSIFY_POLICY_ID matches the policy where you want the expenses to appear. Ready to automate your expenses? Import this template and connect UploadToURL to start fast-tracking your reimbursements today. Questions about the Slack interactivity setup? The workflow includes detailed sticky notes explaining how to handle the button response loop.
by Jitesh Dugar
AI Vendor / Partner Proposal Evaluation & Auto-Response System Description Automate vendor and partner proposal evaluation from slow, manual PDF reviews into a fast, consistent, and AI-powered decision workflow. This workflow accepts proposal PDFs via webhook, extracts and cleans document content, uses AI to analyze proposals for key information and risks, and automatically decides whether the proposal should be flagged for review or approved instantly. The system guarantees one proposal = one decision, eliminates duplicate outputs, and ensures stakeholders are notified immediately when risks are detected — while low-risk proposals are auto-approved without human intervention. What This Workflow Does Transforms vendor proposal evaluation into a single, reliable automation: 📥 Proposal Intake via Webhook – Accepts vendor or partner proposal PDFs through an API-ready webhook endpoint. 📄 PDF Download & Text Extraction – Downloads the submitted PDF and extracts readable text from the document. 🧹 Text Cleanup & Normalization – Removes noise such as headers, page numbers, and repeated titles to improve AI accuracy. 🧠 AI Proposal Evaluation – Uses OpenAI to summarize the proposal, extract key points, identify the category, and detect risks or missing information. 🧩 Structured JSON Parsing – Converts AI output into clean, automation-safe JSON. ⚖️ Risk Decision Logic – Calculates a single risk flag for the entire proposal (no fragmented decisions). 🚨 Risk Alerts – Sends a structured Slack alert when risks are detected, prompting manual review. ✅ Auto-Approval Flow – Automatically approves proposals with no risks and returns a success response via webhook. Key Features 🤖 AI-Powered Proposal Analysis – Consistent summaries and risk detection across all proposals. 📄 PDF-First Workflow – Designed specifically for real-world proposal documents. ⚖️ One Proposal = One Decision Logic – Prevents duplicate items or conflicting outcomes. 🚨 Instant Risk Notifications – Alerts stakeholders the moment issues are detected. ✅ Automatic Approvals – Saves time by instantly approving low-risk proposals. ⚙️ Automation-Safe JSON Output – Perfect for extending into CRMs, databases, or dashboards. Perfect For 🏢 Procurement & Vendor Management Teams 🤝 Partnerships & Business Development Teams 📊 Operations & Strategy Teams 🚀 Startups reviewing vendor or partner proposals 🧾 Compliance & Risk Review Teams What You’ll Need Required Integrations 🤖 OpenAI – Proposal evaluation, summarization, and risk detection 💬 Slack – Risk alerts and internal notifications 🌐 Webhook Access – Proposal submission endpoint Optional Enhancements 📄 PDF Report Generation – Create downloadable AI evaluation reports 📊 Google Sheets / Database Logging – Track proposal decisions 📧 Email Notifications – Notify vendors of approval or next steps 🗂 CRM Integration – Push approved vendors into onboarding systems 🌍 Multi-Language Analysis – Support international proposals Quick Start 1️⃣ Import the workflow into your n8n workspace 2️⃣ Add OpenAI and Slack credentials 3️⃣ Deploy the webhook and copy the URL 4️⃣ Submit a proposal PDF to the webhook 5️⃣ Review Slack alerts or approval responses 6️⃣ Activate the workflow Customization Options 1️⃣ AI Prompt Tuning – Adjust evaluation depth or industry focus 2️⃣ Risk Rules – Change what qualifies as a flagged proposal 3️⃣ Approval Messaging – Customize webhook responses 4️⃣ Notification Channels – Swap Slack for email or Teams 5️⃣ Additional Fields – Extract budgets, timelines, or compliance data Expected Results ⚡ Faster proposal review cycles 🤖 Consistent and unbiased evaluations 📉 Reduced manual workload 🚨 Immediate visibility into risky proposals ✅ Clean, documented approval decisions Workflow Structure Overview 📥 Proposal Upload ↓ 📄 PDF Download & Parsing ↓ 🧹 Text Cleanup ↓ 🧠 AI Proposal Evaluation ↓ 🧩 JSON Parsing ↓ ⚖️ Risk Decision ↓ 🚨 Slack Alert or ✅ Auto Approval
by Jason Stelo
This workflow uses Tally.so to collect client input that you input yourself during the meeting or after from a simple form and send that data to n8n via an API webhook. Once received, n8n processes the information and uses OpenAI to expand on the provided details transforming the short client notes into a complete, well-structured proposal. After generating the proposal, the workflow automatically: Drafts a professional follow-up email using the generated proposal details. Prepares the email inside Gmail, ready for your review and final send. This creates a fast, automated process turning raw meeting notes into a polished, client-ready deliverable within minutes.
by Jitesh Dugar
Turn your best 5-star reviews into a daily stream of branded social proof content -- fully automated. This workflow pulls the oldest unposted 5-star review from Google Sheets, generates a custom quote card using the hcti.io HTML-to-image API, uploads it via Upload to URL to get a stable public CDN link, and publishes it directly to Instagram with a formatted caption. The source row is updated to prevent duplicate posts and the team is notified on Slack. What This Workflow Does Review Dispatch Automation Schedule Trigger** -- fires daily at 9 AM. Adjust the cron expression for any cadence (twice weekly, every other day, etc.) Google Sheets -- Fetch Review** -- reads the Reviews sheet filtering for Rating = 5 and Posted = FALSE, sorted by Submitted At ascending for FIFO queue dispatch. Fetches exactly one row per run. IF -- Has Valid Review** -- exits the workflow cleanly on the false branch if no unposted reviews remain. No errors, no failed executions. Dynamic Quote Card Generation Code -- Prepare Fields** -- cleans the raw sheet row: truncates review text to card-safe length, formats the star rating as a count, builds the full Instagram caption with attribution line and hashtag block (max 2200 characters). Set -- Assemble HTML Card** -- constructs a 1080x1080px HTML/CSS quote card template using n8n expressions that reference prepared text fields and env var brand colors. HTML is built in a Set node rather than a Code node to avoid Web Application Firewall false positives on template submission. HTTP -- hcti.io** -- sends the HTML string to the hcti.io API (HTML/CSS to Image) which renders it as a PNG and returns an image URL. Free tier covers 100 renders per month. CDN Bridge via Upload to URL Upload to URL** -- mandatory step. Instagram Graph API requires a direct public HTTPS image URL and rejects binary payloads and base64 strings. This node downloads the rendered PNG from hcti.io and re-uploads it to a CDN, returning a stable public URL Instagram can access. Code -- Merge Fields** -- combines the CDN URL from Upload to URL with the caption and review metadata from the earlier Code node using cross-node reference. Instagram Two-Step Publish Flow HTTP -- IG Create Media Container** -- Step 1 of Instagram publishing. POSTs the CDN image URL and caption to /v19.0/{ig_user_id}/media. Returns a container_id that Instagram uses to stage and validate the image. Wait 6s** -- processing buffer to ensure Instagram completes async validation before the publish call. HTTP -- IG Publish Container** -- Step 2. Calls /media_publish with the container_id. Returns the live Instagram Post ID confirming the post is on the feed. Logging and Notification Google Sheets -- Mark as Posted** -- updates the source row: sets Posted = TRUE and writes back the Post ID and timestamp. Prevents the same review from being picked up on the next scheduled run. Slack -- Notify Team** -- sends reviewer name, a 100-character review snippet, the Post ID, and the CDN card URL so the team can verify what went live. Key Features Queue-based dispatch** -- reviews post in submission order (FIFO). Oldest unposted 5-star review goes first on every run, keeping the feed chronologically authentic. WAF-safe card assembly** -- the HTML quote card is built in a Set node using n8n expressions rather than as a raw string in a Code node. This avoids Cloudflare WAF false positives during template submission. Mandatory CDN bridge** -- Upload to URL is a required step, not optional. Instagram's API will reject any image that is not a direct public HTTPS URL, including hcti.io's own image URLs in some configurations. Duplicate-safe** -- the Google Sheets update node writes Posted = TRUE immediately after publish. The same review can never be re-queued. Source-agnostic** -- works with Google Reviews, Trustpilot, Capterra, or any form tool (Typeform, Tally, Jotform) that appends rows to a Google Sheet. Fully customizable card design** -- background color, text color, and accent color are all controlled by environment variables. No code changes needed to rebrand. What You Will Need Credentials Google Sheets OAuth2** -- connected to your Reviews spreadsheet hcti.io Basic Auth** -- user ID and API key from hcti.io (free tier available at hcti.io) Upload to URL** -- credentials configured in n8n Instagram Graph API** -- Business or Creator account access token Slack OAuth2** -- for team notifications Google Sheets Columns Required Reviewer Name -- Review Text -- Rating -- Source -- Posted -- Submitted At -- Instagram Post ID -- Posted At -- Card Image URL Perfect For SaaS companies** -- automate a daily customer love post from your existing review pipeline E-commerce brands** -- convert 5-star product reviews into social proof content on a consistent schedule Hospitality and restaurants** -- publish verified guest reviews from Google or Tripadvisor automatically Agencies** -- run one instance per client by swapping env vars, with a separate Google Sheet per brand Retail and service brands** -- keep Instagram active with authentic customer voices without any manual effort
by Flavio Paesano
Workflow: RSS to E-Mail *7 Nodes + AI Model ⚙️ Pipeline Steps Daily Morning Trigger Fires every day at 8:00 AM. Define RSS Sources Outputs 27 curated RSS feed URLs across 7 categories: Category --------Sources Fetch RSS Feeds Reads each feed (includes error handling so one broken feed won't kill the workflow). Clean and Prepare for AI Deduplicates by URL, strips HTML tags, truncates descriptions, sorts by date, and keeps the 150 most recent articles. AI Article Curator (GPT-5 Mini) Reviews all articles and picks the 30 most interesting and diverse ones. Build Digest Email Generates a beautiful HTML email with a purple gradient header, numbered article cards with titles, descriptions, dates, and source attribution. Send Digest Email Sends the final curated digest via Gmail. 🚀 How to Activate To get this workflow running, you need to: • Connect OpenAI: Add your credentials to the AI model node. • Connect Gmail: Add your credentials to the Send node. • Set Target Email: Update your email address in the "Send Digest Email" node (it is currently a placeholder). Enable: Toggle the workflow to Active.
by CentralStationCRM
Overview This template benefits anyone who wants to: automate web research on a prospect company compile that research into an easily readable note and save the note into CentralStationCRM Tools in this workflow CentralStationCRM, the easy and intuitive CRM Software for small teams. Here is our API Documentation if you want to customize the workflow. ChatGPT, the well-known ai chatbot Tavily, a web search service for large language models Disclaimer Tavily Web Search is (as of yet) a community node. You have to activate the use of community nodes inside your n8n account to use this workflow. Workflow Screenshot Workflow Description The workflow consists of: a webhook trigger an ai agent node an http request node The Webhook Trigger The Webhook is set up in CentralStationCRM to trigger when a new company is created inside the CRM. The Webhook Trigger Node in n8n then fetches the company data from the CRM. The AI Agent Node The node uses ChatGPT as ai chat model and two Tavily Web Search operations ('search for information' and 'extract URLs') as tools. Additionally, it uses a simple prompt as tool, telling the ai model to re-iterate on the research data if applicable. The AI Agent Node takes the Company Name and prompts ChatGPT to "do a deep research" on this company on the web. "The research shall help sales people get a good overview about the company and allow to identify potential opportunities." The AI Agent then formats the results into markdown format and passes them to the next node. The CentralStationCRM protocol node This is an HTTP Request to the CentralStationCRM API. It creates a 'protocol' (the API's name for notes in the CRM) with the markdown data it received from the previous node. This protocol is saved in CentralStationCRM, where it can easily be accessed as a note when clicking on the new company entry. Customization ideas Even though this workflow is pretty simple, it poses interesting possibilities for customization. For example, you can alter the Webhook trigger (in CentralstationCRM and n8n) to fire when a person is created. You have to alter the AI prompt as well and make sure the third node adds the research note to the person, not a company, via the CentralStationCRM API. You could also swap the AI model used here for another one, comparing the resulting research data and get a deeper understanding of ai chat models. Then of course there is the prompt itself. You can definitely double down on the information you are most interested in and refine your prompt to make the ai bot focus on these areas of search. Start experimenting a bit! Preconditions For this workflow to work, you need a CentralStationCRM account with API Access an n8n account with API Access an Open AI account with API Access Have fun with our workflow!
by Jitesh Dugar
📄 AI-Powered Verified Job Offer Letter Generator Description Creating job offer letters manually is time-consuming, error-prone, and difficult to scale. This AI-powered workflow automates the entire job offer letter process — from validating candidate emails to generating and delivering professional PDF offer letters. This intelligent workflow eliminates repetitive drafting, reduces human errors, and ensures offer letters are sent only to verified email addresses, helping HR teams move faster while maintaining professionalism and accuracy. What This Workflow Does Transforms manual offer letter creation into a seamless, automated HR process: 📝 Capture Candidate & Job Details – Receives candidate name, email, job role, salary, joining date, and company details via webhook or form. 📧 Email Verification – Validates the candidate’s email address before sending any communication to prevent delivery errors. 🧠 AI-Powered Offer Letter Generation – Uses AI to generate a clear, professional, and structured job offer letter. 📄 HTML Offer Letter Formatting – Converts the AI-generated content into a clean and readable HTML layout. 📑 PDF Generation – Automatically converts the offer letter into a professional PDF document. 📧 Offer Letter Delivery – Sends the PDF offer letter directly to the verified candidate email. 🗂️ Document Storage – Saves a copy of the offer letter for internal records and future reference. 🔁 Confirmation Response – Returns a success response confirming completion. Key Features 🤖 AI Offer Letter Writing – Generates professional, ready-to-send offer letters automatically. 📧 Email Verification Built-In – Ensures offer letters are only sent to valid email addresses. 📑 PDF Generation – Creates clean, official-looking offer letters. ⚙️ End-to-End Automation – No manual drafting, formatting, or sending required. 📂 Centralized Record Keeping – Keeps copies of all generated offer letters. 🔄 Flexible Triggering – Can be triggered from HR systems, forms, or internal tools. Perfect For 🏢 HR & Recruitment Teams – Automate offer letter creation and delivery. 🚀 Startups & Growing Companies – Send professional offer letters without extra admin work. 🏫 Staffing & Hiring Agencies – Generate offer letters quickly for multiple candidates. 💻 Remote & Distributed Teams – Ensure consistent communication across locations. 🧠 Operations Teams – Maintain accurate records and reduce manual errors. What You’ll Need Required Integrations 🌐 Webhook Trigger – Receives candidate and job details. 🤖 OpenAI – Generates offer letter content. 📧 VerifyEmail – Validates candidate email addresses. 📄 HTMLCSS to PDF – Converts HTML into PDF offer letters. 📧 Gmail – Sends the offer letter email. ☁️ Google Drive (optional) – Stores generated offer letters. Optional Enhancements 🎨 Brand Customization – Add company logo, colors, and formatting to offer letters. 🧾 HR System Integration – Connect with ATS or HR tools for automatic triggering. 🌍 Multilingual Offer Letters – Generate offer letters in different languages. 🔐 Approval Step – Add internal approval before sending offer letters. 📊 Audit Logging – Store offer letter data in Google Sheets or databases. 📎 Additional Attachments – Include policies or onboarding documents with the offer letter. Quick Start 1️⃣ Import the workflow template into your n8n workspace 2️⃣ Connect credentials for OpenAI, VerifyEmail, Gmail, and HTMLCSS to PDF 3️⃣ Send test candidate data to the webhook 4️⃣ Review the generated PDF offer letter 5️⃣ Activate the workflow and start sending offer letters automatically Customization Options 1️⃣ Offer Letter Tone – Adjust AI prompt for formal or friendly tone. 2️⃣ Company Branding – Customize HTML layout and styling. 3️⃣ Email Content – Modify subject line and email message. 4️⃣ PDF Layout – Adjust spacing, fonts, and structure. 5️⃣ Storage Location – Change where offer letters are saved. 6️⃣ Validation Rules – Extend email or input checks. Expected Results ⚡ Faster Hiring Process – Generate offer letters in minutes. 🤖 Consistent Quality – Every offer letter follows a professional format. 📧 Error-Free Delivery – Verified emails reduce failed communication. 🗂️ Organized Records – All offer letters stored automatically. 🏢 Professional Candidate Experience – Clean, official documents every time. Workflow Structure Visualization 📝 Candidate & Job Details ↓ 📧 Email Verification ↓ 🧠 AI Offer Letter Generation ↓ 📄 HTML Formatting ↓ 📑 PDF Conversion ↓ 📧 Email Delivery ↓ 🔁 Confirmation Response 🚀 Ready to Automate Job Offer Letters? Import this template today and let AI handle offer letter creation, verification, and delivery — so your team can focus on hiring the right talent faster. ✨
by Afareayo Soremekun
ChannelCrawler API to Google Slides Template This template shows how you can use the ChannelCrawler API alongside ChatGPT (or any LLM) to generate google slides using images and texts received from the API How it Works A user inputs the link to the Youtube channel(s) of their target creators The list is parsed by a python script, returning it in a format that can be ran in a loop The workflow iterates over each channel url The url is passed to the ChannelCrawler API, where it returns a json of the creators profile. The OpenAI node processes the description and content of the creators profile to create a summary We retrieve the google slides presentation using the get presentation node. We use the Google Slides API to duplicate an existing page and pull back the original page as it has a new revision ID We use the Google Slides API to change the image placeholder of the of the image Presentation Lastly we update other placeholders in with text from the ChannelCrawler and ChatGPT outputs How to Use From executing the workflow, a pop up form will come up where you can insert the Youtube Channel urls On submission, provided the prerequisites are set up - rest of the workflow will be triggered Use Cases You can create profiles on influencers and creators with extensive data points from the ChannelCrawler API and consistent summarisation from GPT Prerequisites ChannelCrawler Account - there's a great pay as you go options for access to the API OpenAI account - the you can access free Open AI credit if you are a first time n8n user! Check the credentials options in the node Google account (For slides) - You should have a google account or sign up for google with your non google email
by Amit Kumar
Who This Workflow Is For This workflow is ideal for YouTube creators, automation builders, and marketers who want to produce short AI-generated videos automatically. It’s especially useful for channels that publish frequent Shorts-style content or want to automate the entire video creation and posting process without manual scripting, editing, or uploading. What This Workflow Does This automation creates short AI videos by combining Gemini-generated scripts with KIE AI’s text-to-video rendering. It generates a title, description, and video prompt, sends the prompt to KIE AI to create the video, and then automatically uploads the finished result to your YouTube channel using Blotato. Each run generates a new video concept selected from a predefined set of templates, providing ongoing variety and fresh content. The workflow handles idea generation, video rendering, polling, media upload, and publishing from start to finish. How It Works Schedule Trigger starts the workflow based on your chosen frequency. Randomizer selects one creative template from several predefined options. Gemini Prompter generates a title, description, and structured video prompt. KIE AI renders the video using the Sora-style text-to-video model. Polling + Wait retrieves the completed video once rendering finishes. Blotato uploads and publishes the final video to your connected YouTube channel. How to Set Up Add your Google Gemini, KIE AI, and Blotato API credentials. Connect your YouTube channel inside Blotato. Adjust the schedule (e.g., every 6–12 hours). Edit or expand prompt templates inside the Prompter node. Activate the workflow to allow fully automated video generation and publishing. Customization Ideas Add logging to Google Sheets or Notion. Add Telegram, email, or Discord notifications when a new video is posted. Change video length, aspect ratio, or watermark settings in the Create video node. Expand your creative template list to increase content variety.
by Paul Abraham
GummyMail – Gumroad Personalized Autoreply system This n8n template automates post-purchase communication for Gumroad creators by sending AI-powered personalized thank-you emails and logging customer data into Notion. It helps creators engage buyers instantly while keeping a clean customer CRM — fully hands-free. Use cases Automatically send personalized thank-you emails after every Gumroad purchase Maintain a lightweight customer CRM in Notion Reduce manual email follow-ups for digital product sales Improve buyer experience and post-purchase engagement Build a foundation for creator support, upsells, or onboarding flows Good to know This workflow connects to a few external services, so credentials must be configured before running the template. It works on both n8n Cloud and self-hosted instances, and setup typically takes 5 minutes. Requirements n8n Cloud or self-hosted instance Gmail account (OAuth connected) to receive and send emails Notion account with a customer database Google Gemini API key for AI-generated email content Customising this workflow Replace Gmail with Slack, Telegram, or WhatsApp for message delivery Swap Google Gemini with OpenAI or Claude for different writing styles Add follow-up emails, upsells, or discount links Extend the Notion database into a full creator CRM Use it as a base for Gumroad analytics, support automation, or AI creator tools
by Nirav Gajera
Jira Daily Worklog Automation — Auto-log Time from Google Sheets to Jira Every Night Automatically logs time to Jira every night from a Google Sheet. No manual worklog entries needed — just fill in your sheet and the workflow handles the rest at 10 PM. Built for developers and teams who track their daily tasks in a spreadsheet and want their Jira time entries done automatically, with a clean email report. How It Works Runs every night at 10 PM via a Schedule Trigger Reads all rows from your Google Sheet and filters rows where status = Pending and date <= today Loops through each pending row one at a time using splitInBatches Builds the Jira worklog payload — normalises time format, constructs the ISO timestamp from date + started_at Calls the Jira REST API (POST /rest/api/3/issue/ticket_id/worklog) with Basic Auth Updates the sheet row status to Completed or keeps it Pending with an error message and incremented retry_count After all rows are processed, reads results from static data and builds a summary GPT-4o-mini** writes a friendly 2–3 sentence team update Sends a formatted HTML email report via Gmail with success count, fail count, total time logged, and the AI summary How to Use Step 1 — Set up your Google Sheet Create a sheet with these exact column headers in row 1: | ticket_id | log_text | date | started_at | log_time | status | error_message | retry_count | |-----------|----------|------|------------|----------|--------|---------------|-------------| ticket_id — your Jira issue key e.g. PROJ-123 log_text — worklog comment e.g. Reviewed PR and fixed unit tests date — date to log against e.g. 2026-04-02 started_at — time the work started e.g. 09:30 log_time — time spent e.g. 1h, 30m, 1h30m status — set to pending for rows to be processed error_message — auto-filled on failure retry_count — auto-incremented on failure Step 2 — Add credentials in n8n Google Sheets OAuth2** — connect your Google account Gmail OAuth2** — connect your Gmail account for email reports HTTP Basic Auth** — your Jira email + API token (get token at id.atlassian.com/manage-profile/security/api-tokens) OpenAI API** — for the AI summary (GPT-4o-mini) Step 3 — Update the workflow Open the Read Log Sheet node and select your spreadsheet and sheet tab Open the Update Sheet node and do the same Open Jira: Add Worklog and update the Atlassian domain in the URL: https://YOUR-DOMAIN.atlassian.net/... Open both Gmail nodes and update the sendTo email address Select your HTTP Basic Auth credential in Jira: Add Worklog Step 4 — Activate Toggle the workflow to Active. It will run automatically every night at 10 PM. To test immediately, open the workflow and click Test Workflow. Requirements n8n (self-hosted or cloud) Google account with Google Sheets + Gmail Jira Cloud account with an API token OpenAI API key (free tier works for low volume) Customising This Workflow Change the schedule** — edit the cron expression in the trigger node. Examples are in the sticky note Change the Jira domain** — update the URL in Jira: Add Worklog to your Atlassian subdomain Use Telegram instead of Gmail** — replace both Gmail nodes with a Telegram node using chatId and text Skip the AI summary** — delete the AI Summary node and wire Build Summary directly to the Gmail node; update the email template to remove $json.message.content Add multiple projects** — the sheet supports any mix of ticket IDs from different Jira projects in the same run Catch missed past days** — the filter already picks up rows where date < today, so any past pending rows are automatically retried on the next run