Workflow Templates

How It Works This workflow automates the entire property lead generation process in a few simple steps: Property Search: Connects to BatchData's Property Search API with customizable parameters (location, property type, value range, equity percentage, etc.) Lead Filtering & Scoring: Processes results to identify the most promising leads based on criteria like absentee ownership, years owned, equity percentage, and tax status. Each property receives a lead score to prioritize follow-up. Skip Tracing: Automatically retrieves owner contact information (phone, email, mailing address) for each qualified property. Data Formatting: Structures all property and owner data into a clean, organized format ready for your systems. Multi-Channel Output: Generates an Excel spreadsheet with all lead details Pushes leads directly to your CRM (configurable for HubSpot, Salesforce, etc.) Sends a summary email with the spreadsheet attached The workflow can run on a daily schedule or be triggered manually as needed. All parameters are easily configurable through dedicated nodes, requiring no coding knowledge. Who's It For This workflow is perfect for: Real Estate Investors looking to find off-market properties with motivated sellers Real Estate Agents who want to generate listing leads from distressed or high-equity properties Investment Companies that need regular lead flow for acquisitions Real Estate Marketers who run targeted campaigns to property owners Wholesalers seeking to build a pipeline of potential deals Property Service Providers (roof repair, renovation contractors, etc.) who target specific property types Anyone who needs reliable, consistent lead generation for real estate without the manual work of searching, filtering, and organizing property data will benefit from this automation. About BatchData BatchData is a comprehensive property data provider that offers access to nationwide property information, owner details, and skip tracing services. Key features include: Extensive Database: Covers 150+ million properties across all 50 states Rich Property Data: Includes ownership information, tax records, sales history, valuation estimates, equity positions, and more Skip Tracing Services: Provides owner contact information including phone numbers, email addresses, and mailing addresses Distressed Property Indicators: Flags for pre-foreclosure, tax delinquency, vacancy, and other motivation factors RESTful API: Professional API for programmatic access to all property data services Regular Updates: Continuously refreshed data for accurate information BatchData's services are designed for real estate professionals who need reliable property and owner information to power their marketing and acquisition strategies. Their API-first approach makes it ideal for workflow automation tools like N8N.

This workflow creates a daily, automated backup of all workflows in a self-hosted n8n instance and stores them in Google Drive. Instead of exporting every workflow on every run, it uses content hashing to detect meaningful changes and only updates backups when a workflow has actually been modified. To keep Google Drive clean and predictable, the workflow intentionally deletes the existing backup file before uploading the updated version. This avoids duplicate files and ensures there is always one authoritative backup per workflow. A Data Table is used as an index to track workflow IDs, hash values, and timestamps. This allows the workflow to quickly determine whether a workflow already exists, whether its content has changed, or whether it should be skipped entirely. How it works Runs daily using a Cron Trigger. Fetches all workflows from the n8n API. Processes workflows one-by-one for reliability. Generates a SHA-256 hash for each workflow. Compares hashes against a stored Data Table. Deletes existing Google Drive backups when changes are detected. Uploads updated workflows and skips unchanged ones. Store new or updated workflows details in Data Table. Filters workflows based on the configured backup scope (all | active | tagged ). Backs up all workflows, only active workflows, or only workflows matching a specific tag. Applies the scope filter before hashing and comparison, ensuring only relevant workflows are processed. Setup steps Set the Cron schedule** Open the Cron Trigger node and choose the time you want the backup to run (for example, once daily during off-peak hours). Create a Data Table** Create a new n8n Data Table with the title defined in dataTableTitle. This table stores workflowId, workflowName, hashCode, and DriveFiveId. Configure the Set node** In the Set Backup Configuration node, provide the following values: { "n8nHost": "https://your-n8n-domain", "apiKey": "your-n8n-api-key", "backupFolder": "/n8n/workflow-backups", "hashAlgorithm": "sha256", "dataTableTitle": "n8n_workflow_backup_index", "backupScope" : "", "requiredTag" : "" } In the Set Backup Configuration node, choose how workflows should be selected for backup: all – backs up every workflow (default) active – backs up only enabled workflows tagged – backs up only workflows containing a specific tag If using the tagged option, provide the required tag name to match. { "backupScope": "tagged", "requiredTag": "production" } Connect Google Drive credentials** Authorize your Google Drive account and ensure the backup folder exists. Activate the workflow** Once enabled, backups run automatically with no further action required.

Conference Synthetic Personas: Slack → Gemini → CRM Insights Who is this for? Event strategists, conference organizers, and marketing teams planning content/networking who want to interview realistic audience personas based on their participantants behavioural data before spending budget. What problem is this workflow solving? Event deisgn and management is guesswork: Content misses audience needs Networking formats flop No pre-validation of concepts This workflow creates interviewable synthetic personas from your real CRM data, test ideas pre-event. What this workflow does Trigger**: Slack /doppelganger "EventX" 5 hubspot CRM Pull**: HubSpot/Salesforce/Sheets attendee data Gemini Analysis**: Generates 5+ realistic personas per event Slack Cards**: Rich persona profiles + 14 auto-interview questions Thread Replies**: Team follow-ups in persona context Sheets Log**: Personas + conversations archived Setup (8 minutes) Slack**: OAuth2 + /doppelganger slash command Gemini**: Google API key (Flash/Pro) CRM**: HubSpot API / Salesforce OAuth / Google Sheets Sheets ID**: Personas + Conversations tabs Fully configurable, no code changes needed. How to customize to your needs CRMs**: HubSpot → Salesforce → Sheets CSV Personas**: Speakers/Exhibitors/Attendees Questions**: Edit 14 interview prompts (5 categories) Scale**: Multi-event batching Output**: Add Teams/Notion sync ROI: 40% better content relevance** (pre-validated) 25% lower no-show rates** (targeted comms) 2h → 2min** persona generation Need help customizing?: Contact me for consulting and support: LinkedIn / Message Keywords: event personas, synthetic audience, conference planning, attendee segmentation, event strategy automation

💰 AI Expense Tracker — Chat to Track Spending Instantly Track your expenses by chatting naturally. No forms, no apps — just type and it's saved. 📖 Description This workflow turns a simple chat interface into a powerful personal expense tracker. Just describe your spending in plain language — the AI understands it, categorizes it, and saves it to Google Sheets automatically. Example inputs the AI understands: spent 500 on lunch uber 150 paid 1200 electricity bill lunch in feb 25 cost 500 ← handles past dates too netflix 499 $50 hotel booking ← detects currency No rigid formats. No dropdowns. Just type naturally. ✨ Key Features Natural language input** — type expenses exactly how you'd say them AI-powered parsing** — Claude Haiku extracts amount, category, date, currency automatically 9 auto-detected categories** — Food, Transport, Shopping, Bills, Entertainment, Health, Business, Education, Other Multi-currency support** — INR, USD, EUR, GBP Past date handling** — "lunch in feb 25 cost 500" saves to February 2025, not today Running monthly total** — each row stores the cumulative month total Monthly summary** — type SUMMARY or summary february for any month Works on empty sheet** — no errors on first use Invalid input handling** — friendly error if no amount detected 💬 Commands | What you type | What happens | | :--- | :--- | | spent 500 on lunch | ✅ Saved: 🍕 Food & Dining — Lunch · ₹500 | | uber 150 | ✅ Saved: 🚗 Transport — Uber · ₹150 | | 1200 electricity bill | ✅ Saved: 💡 Bills & Utilities · ₹1200 | | lunch in feb 25 cost 500 | ✅ Saved to February 2025 correctly | | SUMMARY | 📊 Current month report with breakdown | | summary february | 📊 February report (current year) | | summary february 2025 | 📊 February 2025 specific report | | HELP | 📖 Shows all commands and categories | 🛠 Setup Requirements 1. Google Sheet Create a new Google Sheet with these exact headers in Row 1: | Col | Header | | :---: | :--- | | A | Date | | B | Amount | | C | Category | | D | Description | | E | Currency | | F | Month | | G | Raw Message | | H | Total | 2. Credentials needed | Credential | Used for | Free? | | :--- | :--- | :--- | | Anthropic API | Claude Haiku AI parsing | Paid (very low cost) | | Google Sheets OAuth2 | Read & write expenses | Free | 3. After importing Connect your Anthropic credential to the Claude Haiku node Connect your Google Sheets credential to all sheet nodes Update the Sheet ID in all Google Sheets nodes to point to your sheet Open the workflow chat and type your first expense 🏗 How It Works You type: "spent 500 on car wash" ↓ Detect Intent → classified as: expense ↓ Read All Expenses → loads sheet (works even if empty) ↓ Prepare Data → calculates existing month total ↓ AI Parse Expense (Claude Haiku) → amount: 500 → category: Transport → description: Car wash → date: today → currency: INR ↓ Parse & Total → derives Month from parsed date → computes new running total ↓ Is Valid? (amount > 0 and is_expense = true) ✅ YES → Save to Sheet → Reply with confirmation ❌ NO → Ask user to include an amount Summary flow: You type: "summary february" ↓ Detect Intent → classified as: summary ↓ Read for Summary → loads all rows ↓ Build Summary → detects "february" in message → filters rows by February (current year) → calculates total, breakdown by category, daily avg ↓ Returns formatted report 📊 Sample Summary Output 📊 March 2026 Report 💳 Total: ₹8,450 📝 Entries: 12 📈 Daily avg: ₹470 🔝 Top: 🍕 Food & Dining Breakdown: 🍕 Food & Dining: ₹3,200 (38%) 🚗 Transport: ₹1,800 (21%) 💡 Bills & Utilities: ₹1,200 (14%) 🛍️ Shopping: ₹1,050 (12%) 🎬 Entertainment: ₹800 (9%) 🏥 Health: ₹400 (5%) 📂 Auto-Detected Categories | Emoji | Category | Example keywords | | :---: | :--- | :--- | | 🍕 | Food & Dining | lunch, dinner, restaurant, zomato, swiggy, grocery | | 🚗 | Transport | uber, ola, petrol, metro, flight, car wash, parking | | 🛍️ | Shopping | amazon, flipkart, clothes, electronics, shoes | | 💡 | Bills & Utilities | electricity, wifi, rent, recharge, emi, gas | | 🎬 | Entertainment | netflix, movie, spotify, concert, gaming | | 🏥 | Health | medicine, doctor, gym, pharmacy, hospital | | 💼 | Business | office, software, domain, hosting, tools | | 📚 | Education | course, books, tuition, udemy, fees | | 💰 | Other | anything that doesn't match above | ⚙️ Workflow Nodes | Node | Type | Purpose | | :--- | :--- | :--- | | When chat message received | Chat Trigger | Entry point | | Detect Intent | Code | Classify: expense / summary / help | | Intent Switch | Switch | Route to correct path | | Read All Expenses | Google Sheets | Load rows (alwaysOutputData: true) | | Prepare Data | Code | Compute month total, handle empty sheet | | AI Parse Expense | LLM Chain | Extract fields using Claude Haiku | | Claude Haiku | Anthropic Model | AI model for parsing | | Parse & Total | Code | Validate, derive month, compute total | | Is Valid Expense? | IF | Check amount > 0 | | Save Expense to Sheet | Google Sheets | Append new row | | Reply Saved | Code | Format confirmation message | | Reply Invalid | Code | Request amount from user | | Read for Summary | Google Sheets | Load all rows for report | | Build Summary | Code | Filter by month, compute breakdown | | Send Help | Code | Return command reference | 🔧 Customisation Ideas Add a budget alert** — warn when monthly total exceeds a set limit Telegram integration** — replace chat trigger with Telegram bot WhatsApp integration** — use Twilio WhatsApp as the input channel Weekly digest** — add a Schedule Trigger for automatic weekly reports Multi-user** — store user ID with each row to support team expense tracking Export to PDF** — generate monthly expense report as a PDF ⚠️ Important Notes The Read All Expenses node has Always Output Data enabled — this is required so the flow works on an empty sheet Month is derived from the parsed date, not today's date — so past-dated entries file correctly The Total column stores the running month total at the time of each entry — it does not update retroactively if you delete rows 📦 Requirements Summary n8n (cloud or self-hosted) Anthropic API key (Claude Haiku — very low token usage) Google account with Sheets access Built with n8n · Claude Haiku · Google Sheets By Nirav Gajera

Birthday & Anniversary Reminder with AI Gift Ideas — Telegram Never forget a birthday again. This workflow checks your contacts daily and sends you a Telegram alert 7 days before each birthday and on the day itself — with a warm, AI-generated personal message and 3 gift ideas tailored to the person's interests. How It Works Fill a Google Sheet ("People" tab) with: name, birthday, relationship, interests The workflow runs daily at 8 AM (configurable) Checks if any birthday is today → sends 🎂 "TODAY" alert Checks if any birthday is in 7 days → sends 📅 "REMINDER" alert AI (Groq, free tier) writes a warm, personalized birthday message based on the person's name, age, relationship, and interests AI suggests 3 specific gift ideas with price estimates ($20-100) Everything sent to your Telegram in one clean message What You'll Receive on Telegram 🎂 TODAY — Khalil Mansour turns 34! 👤 friend 📅 2026-04-26 💡 Interests: football, gaming, tech gadgets 💌 MESSAGE: Happy Birthday Khalil! 🎉 Wishing you an epic 34th year filled with incredible goals, clutch victories, and exciting new tech to geek out over. You deserve all the best — enjoy your day! 🎁 GIFT IDEAS: FIFA 26 Ultimate Edition ($60) Razer BlackShark V2 gaming headset ($45) Anker portable phone charger for match days ($30) Workflow Architecture ▶️ Manual Test ──→ 📖 Read People → 📅 Check Dates → 🎁 Format Messages ⏰ Daily 8 AM ──↗ ↓ 🤖 AI Personalize ← Groq Chat Model ↓ 📝 Combine Message ↓ 📲 Send Telegram 9 nodes total. Each node has a clear, single responsibility. Google Sheet Format Create a Google Sheet with a tab named "People" and these columns: | name | birthday | relationship | interests | |---|---|---|---| | Mom | 1965-08-20 | family | gardening, cooking | | Ahmad | 1990-05-15 | friend | photography, hiking | | Sarah | 1985-12-03 | colleague | books, cooking | | Boss | 1978-11-02 | work | golf, wine, travel | What You Need Google Sheet** with your contacts (format above) Telegram bot** — create via @BotFather in 2 minutes, then send /start to your bot Groq API key** — free, no credit card needed (console.groq.com) Setup (10 minutes) Import the workflow JSON into n8n Open 📖 Read People → select your Google Sheet and set tab name to "People" Open 📲 Send Telegram → add your Telegram credential and set your Chat ID (get it from @userinfobot on Telegram) Open Groq Chat Model → add your Groq API credential Click ▶️ Manual Test to verify everything works Activate the workflow — it runs automatically every day at 8 AM Features 7-day advance reminder** — enough time to buy and ship a gift Day-of alert** — never miss sending a birthday message AI-personalized messages** — warm, unique messages based on who the person is and what they like AI gift suggestions** — 3 specific ideas with prices, tailored to their interests Age calculation** — automatically calculates how old they're turning Year wrap-around** — correctly handles birthdays that already passed this year Graceful fallback** — if AI is unavailable, you still get the basic reminder Manual test button** — test the full workflow before activating Customizable Reminder window** — change from 7 days to any number (edit one line in the Check Dates node) Alert time** — change from 8 AM to any time (edit the cron in the Schedule trigger) AI model** — swap Groq model in the Chat Model node (default: llama-3.1-8b-instant) Multiple events** — works for birthdays, anniversaries, or any annual date — just add rows Monthly Cost $0. Google Sheets is free. Telegram Bot API is free. Groq free tier (14,400 requests/day) easily handles a few AI calls per day. Setup Time 10 minutes. Import → connect 3 credentials → fill your contacts sheet → activate. Done forever.

Who is this for This template is perfect for: Market Researchers** tracking industry trends. Tech Teams** wanting to stay updated on specific technologies (e.g., "AI", "Cybersecurity"). Content Creators** looking for curated news topics. Busy Professionals** who need a high-signal, low-noise news digest. What it does Fetches News: Pulls daily articles via NewsAPI based on your chosen keyword (default: "technology"). AI Filtering: Uses an AI Agent (via OpenRouter) to filter out low-quality or irrelevant clickbait. Daily Digest (Slack): Summarizes the top 3 articles in English. Translates the summaries to Japanese using DeepL (optional). Posts both versions to a Slack channel. Data Archiving (Sheets): Extracts structured data (Title, Author, Summary, URL) and saves it to Google Sheets. Weekly Trend Report: Every Monday, it reads the past week's data from Google Sheets and uses AI to generate a high-level trend report and strategic insights. How to set up Configure Credentials: You will need API keys/auth for NewsAPI, OpenRouter (or OpenAI), DeepL, Google Sheets, and Slack. Setup Google Sheet: Create a sheet with the following headers in the first row: title, author, summary, url. Map the Sheet: In the "Append row in sheet" and "Read sheet (weekly)" nodes, select your file and map the columns. Define Keyword: Open the "Set Keyword" node and change chatInput to the topic you want to track (e.g., "Crypto", "SaaS", "Climate Change"). Slack Setup: Select your desired channel in the Slack nodes. Requirements n8n** (Self-hosted or Cloud) NewsAPI** Key (Free tier available) OpenRouter** (or any LangChain compatible Chat Model like OpenAI) DeepL** API Key (for translation) Google Sheets** account Slack** Workspace How to customize Change the Language:** Remove the DeepL node if you only want English, or change the target language code. Adjust the Prompt:** Modify the "AI Agent (Filter)" system message to change how strict the news filtering is. Change Schedule:** Adjust the Cron nodes to run at your preferred time (currently set to Daily 8 AM and Weekly Monday 9 AM).

AI YouTube Trend Intelligence Report: YouTube API + GPT-4o + PDF Dashboard Who is this for? AI creators, marketers, agencies, and researchers tracking YouTube trends who need weekly high-signal insights without 4+ hours manual research. **What problem is this workflow solving? Trend hunting is exhausting:** Scanning 500+ videos across keywords Manual engagement calculations No automated filtering or analysis Scattered spreadsheets vs polished reports This workflow auto-discovers top videos, ranks by engagement, and delivers branded PDF + Sheets dashboard. What this workflow does Trigger: Form input (keywords, days back) or weekly cron YouTube API: Searches 10 keywords → ~500 videos (past 7 days) Ranking: Views + engagement rates → top performers Google Sheets: Exports channels/videos/keywords/stats GPT-4o: Analyzes trends → content recommendations PDF.co: HTML charts → branded PDF report Gmail: Delivers to inbox Setup:(5 minutes) YouTube Data API v3 key (HTTP Query Auth) Google Sheets OAuth2 for exports OpenAI API (GPT-4o-mini) PDF.co for HTML-to-PDF Gmail OAuth2 + recipient email Fully configurable env vars—no hardcoded IDs. How to customize: Edit 10-term list for your niche Filters: Adjust min views (1k), engagement (2%) Schedule: Daily/weekly cron Output: Swap Gmail for Slack/Notion Scale: 1000s videos/month ROI: 4+ hours saved weekly 20% higher content performance Automated competitive intel Zero manual spreadsheet work Need help customizing? Contact me for consulting and support: LinkedIn / **[Message](https://tally.so/r/E Keywords: YouTube trend analysis, AI YouTube research, YouTube analytics automation, content trend tracker, video engagement ranking, YouTube API n8n, weekly YouTube report, YouTube keyword monitoring

WooCommerce Weekly Sales KPI Reporting to Slack & Google Sheets This workflow automatically generates a weekly sales performance report from WooCommerce and shares it with your team. It runs on a weekly schedule, fetches last week’s orders and refunds, calculates key sales KPIs, stores the results in Google Sheets and sends a summarized report to a Slack channel. Quick Implementation Steps (Get Started Fast) Connect WooCommerce, Slack and Google Sheets credentials in n8n. Update the WooCommerce store domain in the Configure WooCommerce Store node. Review the Slack channel and Google Sheet settings. Activate the workflow. That’s it — your weekly sales KPIs will now be generated and shared automatically. What It Does This workflow helps you track and share weekly WooCommerce performance without manual effort. It automatically calculates key sales metrics such as total orders, total revenue, average order value, refunds and top-performing products based on the previous week’s data. The workflow begins on a weekly schedule and determines the exact date range for the last completed week. Using this date range, it pulls sales orders and refund data from WooCommerce through HTTP requests. Multiple calculations are then performed to generate meaningful KPIs that are useful for both operational and leadership-level reporting. Once the KPIs are calculated, the workflow consolidates them into a clean report format. The data is saved in Google Sheets for long-term tracking and a readable summary is sent to a Slack channel so stakeholders can quickly review weekly performance. Who’s It For E-commerce store owners using WooCommerce Operations and sales teams tracking weekly performance Business managers who want automated KPI reporting Teams using Slack and Google Sheets for collaboration and reporting Requirements to Use This Workflow An active WooCommerce store with REST API access WooCommerce Consumer Key and Secret (Basic Auth) An n8n instance with scheduled workflows enabled A Slack workspace with permission to post messages A Google Sheets account with access to the target spreadsheet How the Workflow Works Weekly Schedule Trigger The workflow runs once per week. The exact day and time are configurable. Calculate Last Week’s Date Range A Code node calculates the start and end dates of the previous week. Configure WooCommerce Store The WooCommerce store domain is defined once and reused across API requests. Fetch Weekly Data from WooCommerce Orders with completed and processing status Refund data for the same date range Calculate KPIs Separate Code nodes calculate: Total orders and total revenue Average order value Refund count and refund amount Top products based on revenue Merge KPI Results All calculated KPIs are combined into a single dataset. Prepare Final KPI Report Fields Only required, clean fields are retained for reporting. Store Data in Google Sheets Each workflow run appends one new row with weekly KPI data. Send Weekly Report to Slack A formatted summary is posted to the selected Slack channel. Setup Instructions Update the WooCommerce domain in the Configure WooCommerce Store node. Verify WooCommerce API credentials in all HTTP Request nodes. Select the desired Slack channel in the Slack node. Confirm the target Google Sheet and worksheet. Adjust the weekly schedule if needed. Activate the workflow. How To Customize Nodes Weekly Sales KPI Trigger** Change the day or time to run the workflow at any point during the week. Configure WooCommerce Store** Update the domain if you move to a different store or environment. HTTP Request Nodes** Modify order statuses or add filters as needed. KPI Calculation Code Nodes** Add new metrics or adjust existing calculations. Slack Node** Send reports to a different channel or workspace. Google Sheets Node** Store data in another sheet or spreadsheet. Add-ons (Additional Features) Monthly or daily KPI reporting Email-based KPI reports Separate reports for different WooCommerce stores Alerting when revenue drops below a threshold Dashboard integration using BI tools Use Case Examples Weekly sales performance review for management Tracking revenue and refunds trends over time Sharing automated reports with remote teams Maintaining a historical KPI log in Google Sheets Supporting business decisions with consistent weekly data There can be many more use cases depending on how this workflow is customized or extended. Troubleshooting Guide | Issue | Possible Cause | Solution | |------|---------------|----------| | No data in Slack | Workflow not active | Activate the workflow | | Empty KPIs | No orders in the selected week | Verify WooCommerce data | | Incorrect dates | Schedule misconfiguration | Review trigger timing | | Google Sheets not updating | Permission issue | Reconnect Google Sheets credentials | | WooCommerce API error | Invalid credentials | Check Consumer Key and Secret | Need Help? If you need help setting up this workflow, customizing KPIs or building advanced reporting automation, our n8n workflow developers at WeblineIndia are here to help. Our team has strong expertise in n8n workflow automation, WooCommerce integrations and business intelligence reporting. Whether you want to extend this workflow or build a similar solution tailored to your business needs, feel free to reach out to WeblineIndia for expert support.

Automated Marketing Analytics Report with AI Agent How it works Transform your marketing data into actionable insights with this intelligent automation workflow. The system combines scheduled triggers with AI-powered analysis to deliver comprehensive marketing reports directly to your inbox. Key Features: Scheduled automated reporting (daily, weekly, or monthly) AI-powered data analysis using advanced language models Multi-platform marketing data integration via GoMarble MCP Intelligent report generation with actionable recommendations Direct email delivery of formatted reports Set up steps Prerequisites: GoMarble MCP account and API access Gmail account for report delivery n8n instance (cloud or self-hosted) Configuration Time: ~15-20 minutes Step-by-step setup: Connect GoMarble MCP to n8n Follow the integration guide: GoMarble n8n Setup Configure your marketing platform credentials (Google Ads, Facebook Ads, Analytics) Configure the Schedule Trigger Set your preferred reporting frequency Choose optimal timing for data availability Customize the Report Prompt Define specific metrics and KPIs to track Set analysis parameters and report format preferences Set up AI Agent Configuration Choose between Anthropic Claude or OpenAI models Configure the GoMarble MCP tools for your marketing platforms Configure Gmail Integration Set recipient email addresses Customize email template and subject line Advanced Configuration: Add conditional logic for performance thresholds Include custom data visualization requests Set up alert triggers for significant metric changes What you'll get Automated Intelligence:** Regular marketing performance analysis without manual effort Cross-Platform Insights:** Unified view of Google Ads, Facebook Ads, and Analytics data AI-Powered Recommendations:** Strategic insights and optimization suggestions Professional Reports:** Well-formatted, executive-ready marketing summaries Scalable Solution:** Easy to extend with additional marketing platforms or custom metrics Perfect for marketing teams, agencies, and business owners who want to stay on top of their marketing performance with minimal manual work.

This workflow automates the entire process of running a Print-on-Demand (POD) business by combining market trend analysis with autonomous AI design and quality control. It acts as a virtual product team that researches, designs, vets, and publishes new products to your store every week. Who is it for? This template is ideal for e-commerce entrepreneurs, content creators, and print-on-demand store owners who want to scale their merchandise inventory without spending hours on design and market research. What it does Market Research: Fetches real-time search data from Google Trends and customer preference data from Typeform. AI Design: Uses OpenAI (GPT-4o) to brainstorm t-shirt concepts based on the gathered trends, then generates high-quality vector-style images using Replicate (Flux/Stable Diffusion). Quality Control: A "Vision AI" agent analyzes the generated image, rates it on a scale of 1-10, and filters out any design scoring below 7. Dynamic Pricing & Publishing: Automatically calculates a premium price for higher-rated designs and publishes the product directly to your Printify store. Logging: Saves the product details to Airtable for your records. How to set up Configure Credentials: Open the "Workflow Configuration" node. Replace the placeholder values with your API keys for OpenAI, Replicate, Printify, and Typeform. Set Printify Details: In the "Workflow Configuration" node, add your Shop ID. In the "Publish to Printify" node, update the blueprint_id (the specific t-shirt model, e.g., Bella+Canvas 3001) and print_provider_id. Airtable Setup: Create a table with columns for Title, Description, Price, Quality Score, and Image URL, then map the IDs in the Airtable node. Requirements n8n: Cloud or Self-hosted instance. API Keys: OpenAI (with GPT-4o access), Replicate, Printify, Typeform, and Airtable. Printify Account: A connected store (e.g., Shopify, Etsy, or Pop-up). How to customize Prompt Engineering: Modify the "Chief Designer AI" system prompt to change the artistic style (e.g., from "vector" to "pixel art" or "vintage"). Pricing Logic: Adjust the JavaScript in the "Dynamic Pricing Calculator" to change your base margins or markup rules. Schedule: Change the "Weekly Schedule Trigger" to run daily or monthly depending on your volume needs.

Log meal nutrition from LINE food photos to Google Sheets using Gemini AI Who is this for Health-conscious individuals, people on a diet, and anyone who wants to track daily nutrition without manual data entry. Designed especially for LINE users (Japan, Taiwan, Thailand, etc.) who want an effortless way to monitor calories and macronutrients from meal photos. What this workflow does Send a meal photo to a LINE bot and Gemini 1.5 Flash automatically identifies the food and estimates calories, protein, fat, and carbohydrates. Each meal is logged to Google Sheets with a timestamp and user ID. The workflow calculates the running daily calorie total and warns when the personal limit is exceeded. Every Monday morning, a weekly nutrition summary with AI-generated advice is pushed via LINE automatically. How to set up Create a LINE Messaging API channel and copy the Channel Access Token Copy your LINE User ID for weekly Push messages Set up a Google Sheet with columns: Timestamp, LINE_UID, Food_Name, Meal_Type, Calories, Protein, Fat, Carbs, Confidence Get a Google Gemini API key (free tier available) Configure CALORIE_LIMIT (default 2000) and LINE_USER_ID in the Set Config Fields node Register the n8n Webhook URL in LINE Developer Console Requirements LINE Messaging API account (free tier) Google Sheets (any Google account) Google Gemini API key (free tier available) How to customize Adjust CALORIE_LIMIT in the Set Config Fields node for different dietary goals. Add a Slack notification node to share weekly reports with a fitness accountability group. Modify the Gemini prompt to track additional nutrients like fiber or sodium. Node List | # | Node Name | Type | Role | |---|-----------|------|------| | 1 | Set Config Fields | Set | Centralizes LINE token, Sheet ID, calorie limit, and user ID | | 2 | When LINE Event Received | Webhook | Receives LINE Webhook (POST) | | 3 | If Image Message | If | Branches on image vs text message | | 4 | If Report Command | If | Checks whether text is a report command | | 5 | Send Help Reply via LINE | HTTP Request | Sends usage guide as reply | | 6 | Fetch LINE Image Data | HTTP Request | Downloads image from LINE Content API | | 7 | Encode Image to Base64 | Code | Converts image binary to Base64 string | | 8 | Gemini Food Analysis Config | Gemini Chat Model | Gemini 1.5 Flash model for food analysis | | 9 | Process Food Analysis | LLM Chain | Estimates nutrition info from meal image as JSON | | 10 | Extract Nutrition Data | Code | Extracts and parses JSON from Gemini response | | 11 | Append Meal to Sheets | Google Sheets | Appends nutrition data to spreadsheet | | 12 | Read Today's Total from Sheets | Google Sheets | Retrieves all records for today | | 13 | Compute Daily Calorie Total | Code | Calculates total calories for the day | | 14 | If Over Calorie Limit | If | Checks whether daily limit is exceeded | | 15 | Send Calorie Warning via LINE | HTTP Request | Sends calorie warning reply via LINE | | 16 | Send Nutrition Info via LINE | HTTP Request | Sends nutrition info and daily total via LINE | | 17 | Weekly 9AM Schedule | Schedule Trigger | Triggers weekly report every Monday at 9 AM JST | | 18 | Read Weekly Data from Sheets | Google Sheets | Retrieves records from the past 7 days | | 19 | Summarize Weekly Stats | Code | Aggregates weekly totals, averages, and peak day | | 20 | Gemini Weekly Report Config | Gemini Chat Model | Gemini 1.5 Flash model for weekly comment | | 21 | Create Weekly Comment with LLM | LLM Chain | Generates personalized nutrition advice | | 22 | Deliver Weekly Report via LINE | HTTP Request | Sends weekly report via LINE Push | | 23 | Send Webhook Response OK | Respond to Webhook | Returns HTTP 200 to Webhook | Total: 23 nodes (+ 9 Sticky Notes) Sticky Note Compliance | # | Sticky Note Title | Color | Role | |---|-------------------|-------|------| | 1 | Main Sticky Note (Overview) | Yellow | Workflow overview, How it works, Setup steps, Customization | | 2 | Set configuration fields | White | Covers configuration setup | | 3 | Receive and verify message type | White | Covers LINE webhook and message type checks | | 4 | Download and convert image | White | Covers image fetch and Base64 encoding | | 5 | Analyze image and parse data | White | Covers Gemini analysis and data parsing | | 6 | Log and calculate nutrition | White | Covers meal logging and daily total calculation | | 7 | Notify via LINE based on calorie | White | Covers calorie warning and nutrition info LINE replies | | 8 | Weekly report scheduling and stats | White | Covers schedule trigger and weekly aggregation | | 9 | Respond to LINE webhook | White | Covers webhook response | All sticky notes use H2 headings (## ) and follow n8n public guidelines. Setup Guide 1. Create a LINE Messaging API channel Log in to LINE Developers Create a new provider and a Messaging API channel Issue a long-lived Channel Access Token and copy it Copy your User ID from the channel basic settings 2. Prepare Google Sheets Create a new spreadsheet Add the following headers in row 1: Timestamp | LINE_UID | Food_Name | Meal_Type | Calories | Protein | Fat | Carbs | Confidence Copy the spreadsheet ID from the URL (between /d/ and /edit) 3. Get a Google Gemini API key Go to Google AI Studio Create an API key (free tier available) Register it as a Google PaLM API credential in n8n 4. Configure the n8n workflow Import the workflow JSON into n8n Open Set Config Fields and enter: LINE_CHANNEL_ACCESS_TOKEN GOOGLE_SHEET_ID CALORIE_LIMIT (default: 2000) LINE_USER_ID Set up Google Sheets OAuth2 and Google PaLM API credentials 5. Register the Webhook URL Activate the workflow in n8n Copy the Webhook URL Paste it into LINE Developers Console → Messaging API settings Enable Webhook and verify the connection 6. Test Send a meal photo to your LINE bot → confirm nutrition info is returned Send "report" as text → confirm weekly summary is returned Send other text → confirm help message is returned Tags ai gemini line google-sheets health nutrition-tracking image-recognition automation

Description Automatically generate multi-jurisdiction tax summaries from Stripe invoices and sync them into Google Sheets with daily reporting. This workflow ensures compliance-ready tax data, detailed breakdowns by country/state/tax rate, and real-time Slack notifications for both success and error handling. 💳📈📢 What This Template Does Triggers daily at 2:00 AM using a scheduled cron. ⏰ Fetches paid invoices from Stripe (last 30 days). 💳 Validates data integrity before processing. ✅ Summarizes taxes by period, country, state, and rate. 🧮 Formats and logs results in Google Sheets for reporting. 📊 Sends Slack notifications for both success and failure. 📢 Key Benefits Automated tax compliance reporting. 🧾 Accurate multi-jurisdiction tracking. 🌍 Eliminates manual spreadsheet work. ⏱️ Maintains a historical audit trail. 📋 Real-time notifications keep your team informed. 🔔 Built-in error handling ensures reliability. 🛡️ Features Daily cron schedule (0 2 * * *). Stripe invoices fetched with expanded tax amounts. Intelligent grouping by period, country, state, and tax rate. Google Sheets integration with append/update logic. Success Slack message: summary totals, record count, period. Error Slack message: troubleshooting guidance and failure logs. Uses environment variables for secure configuration (GOOGLE_SHEETS_DOCUMENT_ID, SLACK_CHANNEL_ID). Requirements n8n instance (cloud or self-hosted). Stripe API credentials with invoice read access. Google Sheets OAuth2 credentials with write access. Slack API credentials with chat:write permissions. Proper tax configuration in Stripe for accurate reporting. Target Audience Finance teams handling recurring billing and tax filings. 💼 Accountants needing automated jurisdiction tax breakdowns. 📊 SaaS businesses managing global customers. 🌐 Agencies and SMEs streamlining monthly tax reporting. 🏢 Remote teams requiring real-time workflow notifications. 📲 Step-by-Step Setup Instructions Configure Stripe API credentials in n8n. Set up Google Sheets with a “Tax Summary” sheet (columns: period, country, state, tax rate, taxable amount, tax collected, processing date). Configure Slack API credentials and channel ID (e.g., tax-reports). Replace hardcoded values with environment variables for security. Import this workflow JSON into n8n. Run once manually with test invoices to validate. Enable the workflow for daily automated reporting. ✅