Workflow Templates

What it does Automatically respond to Google Form entries submitted via Google Sheets. This workflow notifies your Slack team, sends a personalized Gmail response to the user, and adds the user to Google Contacts — all triggered instantly upon new row addition in your connected Sheet. Who's it for Perfect for lead capture forms, client inquiries, or feedback submissions. Trigger: When a new row is added to a connected Google Sheet (usually linked to a Google Form). Slack Notification: Sends a Slack message to your selected channel with the form data. Gmail Message: Sends an automatic email reply to the submitter (using their email from the form). Add Google Contact: Automatically creates a new contact in Google Contacts using the form data. This setup is ideal for automating client communication and internal team alerts without manual input.

Reimbursements used to be a headache. Employees submitted receipts through emails, managers got stuck in approval chains, and finance teams spent hours checking for duplicates, updating sheets, and sending follow-up emails. So, we automated it. Using n8n, we built a smart Employee Reimbursement Workflow that does everything… in just a few clicks. Here’s how it works.] When an employee uploads a receipt, the workflow first checks for duplicates. If the file is new, it’s uploaded to Google Drive instantly. Next, a unique tracking ID is generated—no manual typing, no mistakes. Then, all the details are logged in Google Sheets in real time, ready for records. And finally, the Finance team gets an email notification with everything they need to process the payment—no chasing, no missing info. The impact? We’ve cut processing time by over 70%, reduced errors to nearly zero, and made the entire process stress-free for employees and finance alike. This isn’t just automation—it’s giving people their time back.

A next-generation AI-powered DeFi health monitor that tracks wallet positions across Aave V3 using GPT-4o and LangChain. It delivers human-readable reports via Telegram and Gmail, triggered on schedule or manually. Built for professionals monitoring multiple DeFi wallets. 🧩 System Components | Component | Role | | --------------------------------- | ------------------------------------------------------------- | | ✅ Scheduler | Triggers the workflow periodically | | ✅ Google Sheets Wallet Loader | Loads all monitored wallet addresses | | ✅ Set Variables | Injects dynamic wallet + date | | ✅ AAVE Portfolio AI Agent | GPT-4o + LangChain AI that generates human-readable summaries | | ✅ Moralis API Nodes (3) | Collect Aave V3 supply/borrow/collateral data | | ✅ OpenAI Chat Model (gpt-4o-mini) | Interprets on-chain data and explains it | | ✅ Telegram Delivery | Sends summary to Telegram chat | | ✅ Gmail Email Sender | Sends full HTML report to email | | ✅ HTML Formatter | Beautifies AI output into email structure | ⚙️ How It Works Scheduled or manual trigger Pulls wallet addresses from Google Sheets For each wallet: Pulls Aave data from Moralis GPT-4o AI generates report Sends summary to Telegram Sends full HTML report via Gmail 🛠 Installation Steps 1. Import the Workflow Upload AAVE_Portfolio_Professional_AI_Agent.json to your n8n instance. 2. Connect These Credentials | Service | Required Credential Type | | -------- | ---------------------------- | | Moralis | HTTP Header Auth (X-API-Key) | | OpenAI | GPT-4o via OpenAI API Key | | Telegram | Telegram Bot API Token | | Gmail | Gmail OAuth2 Credential | 3. Create Google Sheet Column name must be: wallet_address Add wallet addresses you want monitored 📬 Output Format Telegram Message Example 📊 Aave DeFi Health Report Wallet: 0xABC...123 Date: 2025-05-21 ▪️ Pool: Aave Ethereum USDC • Supply: $10,040 • Borrowed: $5,500 • Health Factor: 3.43 • Liquidation Risk: No Email Report Full HTML + plain text versions Auto-generated date + styled per wallet Includes notes and threshold warnings 🧠 Smart Features GPT-4o generates clear human summaries Monitors multiple wallets in one run Flags liquidation risk dynamically Logs daily performance snapshots 💡 Customization Ideas Add Telegram slash command /aave <wallet> Expand to monitor Compound, Lido, or Uniswap Export to Notion, Slack, or Data Studio 🧾 Licensing & Attribution © 2025 Treasurium Capital Limited Company Architecture, prompts, and report formatting are intellectual property protected. No unauthorized rebranding, redistribution, or resale permitted. 🔗 For support or licensing inquiries: LinkedIn – Don Jayamaha 🚀 Track all your Aave DeFi positions using AI—delivered via Telegram + Gmail. Perfect for funds, traders, and DeFi power users. 🎥 Watch the Live Demo:

🖼️ Image-to-Image AI Generator from Google Sheets with Google Drive Upload ✅ Use Case Automatically generate AI images from prompts listed in a Google Sheet, upload the images to Google Drive, and log the result back into the sheet. Uses the image-to-image-gpt API for fast, customizable generation. 💡 Problem It Solves Manual image generation workflows are inefficient and error-prone. Creative and content teams often have to: Manually paste prompts into image generation tools Save images locally Upload to Google Drive Paste the link back into tracking spreadsheets This automation removes all that friction—turning one spreadsheet into a complete image creation pipeline. 🌟 Benefits 🔁 Fully automated image generation 📤 Direct uploads to Google Drive 🧾 Image links and timestamps logged in Google Sheets ⚠️ Built-in error logging for API failures 🧩 Modular and easily extensible 📊 Keeps a historical log of successes and errors 🧩 Workflow Overview | Node | Description | |------|-------------| | 1. Manual Trigger | Starts the workflow when executed manually | | 2. Google Sheets2 | Reads all rows from the input Google Sheet | | 3. Loop Over Items | Processes one row (prompt) at a time | | 4. If2 | Filters only rows where Prompt is not empty and drive path is empty | | 5. HTTP Request1 | Calls the image-to-image-gpt API with the prompt | | 6. If1 (Error Handling) | If an error exists in the API response, route to logging | | 7. Google Sheets4 (Error Log) | Appends error details to a log sheet for review | | 8. Code1 | Decodes the base64 image returned by the API | | 9. Google Drive1 | Uploads the image to a selected Google Drive folder | | 10. Google Sheets1 (Write Back) | Updates the original row with the image drive path and timestamp | | 11. Wait | Delays the next prompt to prevent hitting API rate limits | 🛠 Tech Stack n8n** (no-code automation) Google Sheets** (data input/output) Google Drive** (image storage) image-to-image-gpt API via RapidAPI JavaScript (in Code node)** for base64 processing 📝 Sheet Format Your Google Sheet should include the following columns: | Column | Purpose | |----------------|----------------------------------| | Prompt | The AI prompt to send to the API | | Image url | (Optional) Initial image URL | | drive path | Updated with Drive link by flow | | Generated Date | Auto-filled by the workflow | | Base64 | Stores raw or error data | 🚀 How to Use Import this workflow into your n8n instance Set up Google Sheets and Google Drive service credentials Add your RapidAPI key in the HTTP Request node headers Use the image-to-image-gpt endpoint in the HTTP request Configure the Google Sheet and Drive folder in the respective nodes Execute manually or add a Cron node for scheduling 📌 Example Applications 🛍 eCommerce: Auto-generate product mockups 🧵 Fashion/Design: Visualize styles or fabrics from prompts ✍️ Blogging/Content: Auto-generate header images from titles 📣 Marketing: Generate ad banners from text 🧪 Tips You can add a Cron node if you want this to run on a schedule Use a separate tab/sheet for logging failed prompts Extend the flow by adding: Email notifications Slack alerts File name templating Create your free n8n account and set up the workflow in just a few minutes using the link below: 👉 Start Automating with n8n Save time, stay consistent, and grow your LinkedIn presence effortlessly!

What it does This workflow automates content syndication and posting to LinkedIn and X/Twitter. It takes existing long-form articles and generates from them engaging social posts optimized for each platform. The workflow takes links to existing articles from a given sitemap. It randomly selects the next article to republish, making sure that articles are not repeated. For simplicity it uses a Google spreadsheet to track the articles that have already been republished. Requirements Existing sitemap Google Gemini API key (or other model provider's key) Google Sheets credentials LinkedIn credentials X/Twitter credentials How to set up Adjust the schedule as needed (by default triggers daily at noon) Configure parameters in the parameters node: Set the sitemap URL (e.g. https://example.com/sitemap.xml) Set the language of the posts Enable/disable channels as needed Configure Google Sheets credentials for get processed articles and add processed articles nodes Create a new Google spreadsheet document with "url", "status", "timestamp", "LinkedIn post" and "Twitter post" columns Specify that spreadsheet document in get processed articles node (other nodes will take it from here) Add Google Gemini API key for the model (or change to any other model of choice) Configure LinkedIn and X/Twitter credentials for publishing

How It Works This workflow automates the complete end-to-end processing of daily revenue transactions for finance and accounting teams. It systematically retrieves, validates, and standardizes transaction data from multiple sources, computes applicable tax obligations, identifies anomalies, and generates regulatory compliance reports. Designed primarily for accountants and financial analysts, it significantly reduces manual workload, improves the accuracy of tax calculations, and automates submission to relevant authorities. Transaction data flows through integrated sources, undergoes validation and AI-driven tax assessment, and ultimately produces well-formatted reports ready for secure archiving or automated email distribution. Setup Steps Connect Google Sheets/SQL for transactions Configure tax rules in workflow Set Gmail/Drive for report delivery Activate schedule for daily execution Prerequisites Accounts and API credentials for Google Sheets, Gmail, Drive; access to transaction database; tax rule configuration. Use Cases Daily financial reconciliation, automated tax calculation, anomaly detection in revenue streams. Customization Adjust connectors, validation rules, and tax logic to match local regulations or additional data sources. Benefits Reduces manual effort, improves accuracy, ensures timely compliance, and enables proactive anomaly detection.

Never miss a workflow failure Automatically capture, analyze, and debug n8n workflow errors using Claude Sonnet 4 with real-time documentation lookup via Context7 MCP server. Why this works better Documentation-first AI analysis Context7 searches official n8n docs before diagnosing. Claude Sonnet 4 only responds after finding relevant documentation—no hallucinations. Complete error intelligence Every error stored in Supabase with full context: stack traces, execution data, workflow structure, AI analysis. Track patterns across all workflows. Production-ready emails Professional HTML with inline code snippets, proper formatting, and one-click execution links. What happens Root cause - Plain English explanation Specific fix - Exact field names and values Prevention tip - Avoid future errors Execution link - One-click debug access Statistics - Error frequency tracking How it works Error → Your workflow fails Capture → Full context retrieved Research → Context7 searches n8n Analysis → AI diagnoses with context Email → Formatted alert delivered Record → Error stored in database Requirements Supabase** - Free tier works OpenRouter** - $5 credit Context7** - Free API available SMTP** - For email delivery n8n API** - Must be enabled Setup: 15 minutes Overview Complete instructions with SQL script included in workflow sticky notes. Activate: Settings → Error Workflow → Select this workflow Customize Reduce cost: Remove workflow_json and execution_data from prompt Change output: Swap email node for Telegram/Slack/Discord—expressions provided in notes FAQ Works with community nodes? Yes. Context7 searches all n8n documentation. Handles sensitive data? Remove workflow_json and execution_data from prompt to exclude content. Customizable design? Yes. HTML template in "Build HTML" node is fully editable.

How It Works This workflow automates IoT device compliance monitoring and anomaly detection for industrial operations. Designed for facility managers, quality assurance teams, and regulatory compliance officers, it solves the challenge of continuously monitoring sensor networks while ensuring regulatory adherence and detecting operational issues in real-time.The system runs every 15 minutes, fetching IoT sensor data and structuring it for analysis. Dual AI agents evaluate compliance against regulatory standards and detect operational anomalies. Issues trigger immediate email and Slack alerts for rapid response. Daily data aggregates into comprehensive ESG reports with AI-generated insights, automatically emailed to stakeholders for transparency and audit trails. Setup Steps Configure AirTable credentials and set 15-minute schedule interval Add OpenAI API keys for compliance and anomaly detection agents, configure regulatory thresholds Set Gmail/Slack credentials for alerts and ESG report distribution Prerequisites IoT sensor platform API access, OpenAI API key, Gmail/Slack accounts Use Cases Manufacturing quality control, environmental compliance monitoring Customization Modify sensor polling frequency, adjust compliance rules, customize anomaly thresholds Benefits Continuous compliance assurance, instant anomaly detection

This AI Blog Generator is an advanced n8n-powered automation workflow that leverages Google Gemini and Google Sheets to generate SEO-friendly blog articles for Shopify products. It automates the entire process — from fetching product data to creating structured HTML content — with zero manual effort. 💡 Key Advantages Our AI Blog Generator offers five core advantages that make it the perfect solution for automated content creation: 🔗 Shopify Product Sync** — Automatically pulls product data (titles, descriptions, images, etc.) via Shopify API. ✍️ SEO Blog Generation** — Gemini generates blog titles, meta descriptions, and complete articles using product information. 🗂️ Structured Content Output** — Creates well-formatted HTML with headers and bullet points for seamless Shopify blog integration. 📄 Google Sheets Integration** — Tracks blog creation and prevents duplicate publishing using a centralized Google Sheet. 📤 Shopify Blog API Integration** — Publishes the generated blog to Shopify with a single API call. ⚙️ How It Works The workflow follows a systematic 8-step process that ensures quality and efficiency: Step-by-Step Process Manual Trigger – Start the workflow via a test trigger or scheduler. Fetch Products from Shopify – Retrieves all product details, including images and descriptions. Fix Input Format – Organizes and updates the input table using Code and Google Sheet nodes. Filter Duplicates – Ensures no previously used rows are processed again. Limit Control – Processes one row at a time and loops until all blogs are posted. Gemini AI Generation – Creates SEO-friendly blog content in HTML format from product data. HTML Structure Fix – Adjusts content for JSON compatibility by cleaning unsupported HTML tags. Article API Posting – Sends finalized blog content to Shopify for publishing or drafting. 🛠️ Setup Steps Required Node Configuration To implement this workflow, you'll need to configure the following n8n nodes: Trigger Node:** Start the workflow instantly. Shopify Node:** Fetch product details. Google Sheet Node:** Store input/output data and track blog creation status. Code Node:** Format data as required. Filter Node:** Remove used rows to avoid duplication. Limit Node:** Process one blog at a time. Agent Node:** Sends prompt to Gemini and returns parsed SEO-ready content. HTTP Node:** Posts content to Shopify via the API. 🔐 Credentials Required Authentication Setup Before running the workflow, ensure you have the following credentials configured: Shopify Access Token** – For fetching products and posting blogs Gemini API Key** – For AI-powered blog generation Google Sheets OAuth** – For logging and tracking workflow data 👤 Ideal For Target Users This automation workflow is specifically designed for: Ecommerce teams** automating blogs for hundreds of products Shopify store owners** boosting organic traffic effortlessly Marketing teams** building scalable, AI-driven content workflows 💬 Bonus Tip Extensibility Features The workflow is fully modular and highly customizable. You can easily extend it for: Internal linking** between related products Multi-language translation** for global markets Social media sharing** automation Email marketing** integration All extensions can be implemented within the same n8n flow, making it a comprehensive content automation solution.

AI Blog & LinkedIn Content Publisher How it works Daily trigger scans your Notion database for unpublished blog ideas AI generates complete blog posts + engaging LinkedIn content using OpenAI (Blog Posting is not implemented yet) Creates custom images for posts using Replicate's Flux-Schnell AI model Auto-publishes to LinkedIn with image OR emails draft for review Updates Notion with published content and tracks status Set up steps Connect accounts: Notion, OpenAI, Replicate, LinkedIn, Gmail Create 2 Notion databases: Ideas (input) and Articles (output) Update config node: Add your database IDs and email Test with one idea: Run manually first to verify everything works Enable daily automation: Turn on the cron trigger Perfect for: Content creators, developers, and marketers who want to transform rough ideas into professional blog posts and LinkedIn content automatically.

📊 Automated Website Traffic Tracker with Google Sheets Logging Track website traffic and backlinks effortlessly using the Website Traffic Checker - Ahref API. This n8n workflow automates data retrieval and logging into Google Sheets, making it perfect for SEO professionals and digital marketers. 🧩 What This Workflow Does (Summary) Accepts a domain via a simple web form. Sends the domain to Website Traffic Checker - Ahref API. If successful: Extracts backlink and traffic data. Appends the results to two separate Google Sheets. If failed: Sends an email alert with domain and status code. 🔧 Node-by-Node Explanation | Node | Purpose | | ---------------------------------- | ---------------------------------------------------------------------------------------------------------------- | | 🟢 Form Trigger | Starts the workflow when a domain is submitted via form. | | 🟩 Set Domain Value | Stores the submitted domain into a variable. | | 🌐 HTTP Request | Calls Website Traffic Checker - Ahref API. | | ✅ IF Node | Checks if the API responded with statusCode = 200. | | ❌ Email Node (Fail) | Sends an alert email if API fails. | | 📦 Code (Backlink Info) | Extracts backlink data from API response. | | 📄 Google Sheet: Backlink Info | Appends backlink data to a sheet. | | 📦 Code (Traffic Info) | Extracts traffic data from API response. | | 📄 Google Sheet: Traffic Data | Appends traffic metrics to another sheet. | 📁 Google Sheet Columns Backlink Info Sheet | Column | Description | | ------------------ | --------------------------- | | website | Domain submitted | | ascore | Authority score | | referring domain | Number of referring domains | | total backlinks | Total backlinks | Traffic Data Sheet | Column | Description | |----------------------|---------------------------------------------| | accuracy | Accuracy level of the traffic data | | bounce_rate | Bounce rate percentage | | desktop_share | Percentage of traffic from desktop devices | | direct | Direct traffic sources | | display_ad | Display ad traffic sources | | display_date | Date when traffic data was captured | | mail | Traffic from email campaigns | | mobile_share | Percentage of traffic from mobile devices | | pages_per_visit | Average number of pages per visit | | paid | Paid traffic sources | | prev_bounce_rate | Bounce rate in the previous period | | prev_direct | Previous period's direct traffic | | prev_display_ad | Previous period's display ad traffic | | prev_mail | Previous period's email traffic | | prev_pages_per_visit | Previous period's pages per visit | | prev_referral | Previous period's referral traffic | | prev_search_organic | Previous organic search traffic | | prev_search_paid | Previous paid search traffic | | prev_social_organic | Previous organic social traffic | | prev_social_paid | Previous paid social traffic | | prev_time_on_site | Previous time spent on site | | prev_users | Number of users in the previous period | | prev_visits | Visits in the previous period | | rank | Global rank of the website | | referral | Referral traffic | | search | Total search traffic | | search_organic | Organic search traffic | | search_paid | Paid search traffic | | social | Total social traffic | | social_organic | Organic social traffic | | social_paid | Paid social traffic | | target | Targeted country or demographic | | time_on_site | Average time spent on site | | unknown_channel | Traffic from unknown sources | | users | Number of unique users | | visits | Total number of visits | 🔐 How to Configure 🔑 Get API Key Go to Website Traffic Checker - Ahref API on RapidAPI. Sign in or create a free RapidAPI account. Subscribe to the API plan. Copy your x-rapidapi-key from the Endpoints tab. 📝 Add Key in n8n Go to your HTTP Request node. Under Headers, set: x-rapidapi-host = website-traffic-checker-ahref.p.rapidapi.com x-rapidapi-key = your API key 📄 How to Setup Google Sheets in n8n Connect a Google account via Google Sheets credentials in n8n. Use the full Google Sheet URL in the documentId field. Set correct Sheet name or GID (e.g., "Traffic Data"). Use Auto Map or Custom Map to define columns. > Make sure your Google Sheet has edit access and headers already created. 🧠 Use Case & Benefits 👤 Ideal For: SEO analysts Digital marketers Agencies managing multiple clients Web analytics consultants ✅ Benefits: Fully automated data collection. No manual copy-paste** from tools. Real-time insights delivered to Google Sheets. Easy monitoring of backlinks and traffic trends.

Use Cases Receive a newsletter featuring curated, contributor-friendly issues from your favorite repositories. By regularly reviewing active issues and new releases, you'll naturally develop stronger habits around open source contribution as your brain starts recognizing these projects as important. How It Works Collects the latest issues, comments, and recent commits using the GitHub API. Uses an AI model to select up to three beginner-friendly issues worth contributing to. Summarizes each issue—with contribution guidance and relevance insights—using Deepwiki MCP. Converts the summaries into HTML and delivers them as an email newsletter. Requirements GitHub Personal Access Token OpenRouter API Key Google App Password Make sure your target open-source project is indexed at https://deepwiki.com/{owner}/{repo} (e.g. https://deepwiki.com/vercel/next.js) How to Use Update the “Load repo info” node with your target repository’s owner and name (e.g. owner: vercel, repo: next.js). Add your GitHub Personal Access Token to the credentials of the “Get Issues from GitHub” node. Connect your OpenRouter API key to all models linked to the Agent node. Add your Google App Password to the “Send Email” node credentials. Enter the same email address (associated with the Google App Password) in both the “to email” and “from email” fields — the newsletter will be sent to this address. Customization Adjust the maximum number of contributor-friendly issues retrieved in the “Get Top Fit Issues” node. Improve results by tuning the models connected to the Agent node. Refine the criteria for “contributor-friendliness” within the “IssueRank Agent” node. Cron Setup Replace the manual trigger with a Schedule Trigger node or another scheduling-capable node. If you don't have an n8n Cloud account, use this alternative setup: fork the repository and follow the setup instructions. TroubleShooting If there is an issue with the AI model’s response, modify the ai_model setting. (If you want to use a free model, search for models containing “free” and choose one of them.)