by Websensepro
Automatically Assign Jira Service Management Reporter from Forwarded Emails This workflow solves a common problem in Jira Service Management: when an email is forwarded to create a ticket, Jira often sets the forwarding system (e.g., support@yourcompany.com) as the reporter, not the original customer. This template automates the process of parsing the original sender's details from the email body and correctly assigning them as the ticket's reporter. If the customer doesn't exist in Jira, a new customer profile is created automatically before the ticket is assigned. What it Does Triggers on New Issue: The workflow starts when a new issue is created in a specified Jira project. Filters Forwarded Emails: An If node checks if the issue was created by one of your internal forwarding email addresses. The workflow only proceeds for these specific issues. Parses Details: A Code node uses regular expressions to parse the issue description (the forwarded email's body) and extract the original sender's name and email address. Searches for Existing Customer: An HTTP Request node checks if a customer with the extracted email already exists in your Jira Service Desk. Creates New Customer: If the customer is not found, another HTTP Request node creates a new customer profile in Jira Service Management. Assigns Reporter: Finally, a Jira node updates the issue's "Reporter" field to the existing or newly created customer, ensuring the ticket is correctly associated with the original sender. Use Cases Shared Support Inboxes**: Automatically process emails sent to a general support inbox (e.g., support@company.com) that are then forwarded to Jira. Departmental Forwarding**: Handle tickets forwarded from specific departments (e.g., sales@company.com or billing@company.com) and assign the original sender correctly. Personal Email Forwarding**: Useful when a team member forwards a customer email from their personal inbox to the Jira Service Management-connected address. Customization The Parse Details From Description node uses a regular expression (regex) to find the sender's email. The default regex is designed for standard forwarded emails that look like this: From: John Doe <john.doe@example.com> If your email client forwards emails in a different format, you may need to adjust the regex in the Code node. For example, if your format is From: [john.doe@example.com], you would need to update the regex pattern to match this structure. Troubleshooting Reporter Not Being Updated**: Verify that the forwarding email addresses in the Filter Forwarding Emails node are correct. Check the body of the Jira ticket's description to ensure the forwarded email content is present and in a format the regex can parse. Customer Not Found/Created**: Ensure your Jira API credentials have the necessary permissions to search for and create customers in Jira Service Management. Workflow Not Triggering**: Confirm that the Jira Trigger is correctly configured for the right project and that the webhook is active in your Jira instance. Requirements An n8n instance (self-hosted or cloud). Jira Software Cloud API credentials with Service Management permissions. How to Set Up Connect Credentials: In the Jira Trigger, Jira, and HTTP Request nodes, select your Jira Software Cloud API credentials. Configure Trigger: In the Jira Trigger node, select the Jira project you want this workflow to monitor. Set Filter Emails: In the Filter Forwarding Emails (If) node, replace the placeholder email addresses with the internal email addresses that forward mail to Jira. Update Jira Domain: In both HTTP Request nodes (Search for Existing Customer and Create Customer), replace the YOUR_JIRA_DOMAIN placeholder with your actual Atlassian domain (e.g., my-company.atlassian.net). Activate Workflow: Save and activate the workflow.
by Charles
🚀 Market Research Analytics System > Transform Google Maps data into actionable business insights with AI-powered analysis 📋 Overview This n8n workflow automatically collects business data from Google Maps, analyzes customer reviews using AI, and generates comprehensive market research reports delivered straight to your inbox. 🎯 Use Cases | User Type | Example Usage | |---------------|-------------------| | 🏢 Business Owners | Analyze competition before opening new location | | 💼 Entrepreneurs | Research market gaps and opportunities | | 📊 Marketing Teams | Understand customer sentiment and preferences | | 💰 Investors | Evaluate market potential in target areas | | 🔍 Consultants | Create detailed market reports for clients | 🛠️ Customization Examples Different Business Types // Restaurants {"search_query": "restaurants downtown", "analysis_focus": "restaurant"} // Hotels {"search_query": "hotels near airport", "analysis_focus": "hospitality"} // Fitness Centers {"search_query": "gyms and fitness centers", "analysis_focus": "fitness"} Multiple Cities // New York {"search_location": "@40.7589,-73.9851,12z", "city_name": "New York City"} // London {"search_location": "@51.5074,-0.1278,12z", "city_name": "London"} // Tokyo {"search_location": "@35.6762,139.6503,12z", "city_name": "Tokyo"} 📊 What You'll Get Your automated report includes: 🎯 Executive Summary Key market insights in 3-4 sentences Biggest business opportunities identified Immediate action recommendations 📈 Market Analysis Competition density and market gaps Price segments and quality distribution Geographic hotspots and trends 💬 Customer Intelligence Top 5 factors customers value most Common complaints and pain points Overall sentiment analysis 🏆 Competitive Landscape Strongest competitors identified Their strengths and weaknesses Positioning opportunities 💡 Strategic Recommendations Optimal business model suggestions Pricing and marketing strategies 30/90/180-day action plans ⚙️ Technical Requirements | Service | Cost | Purpose | |-------------|----------|-------------| | SerpAPI | Free tier (100 searches/month) | Google Maps data extraction | | Google Gemini | Free tier available | AI-powered analysis | | Gmail | Free | Report delivery | | n8n | Cloud or self-hosted | Workflow automation | 🚨 Important Notes API Limits:** Free tiers have monthly limits - monitor usage Data Accuracy:** Results depend on Google Maps data availability Processing Time:** Analysis may take 2-5 minutes depending on data volume Language Support:** Works with multiple languages (update language_code) 🔧 Troubleshooting | Issue | Solution | |-----------|--------------| | No results found | Check coordinates format and search query | | API errors | Verify API keys are correctly configured | | Email not received | Check Gmail credentials and recipient address | | Slow processing | Normal for large datasets (20+ businesses) | 🚀 Pro Tips 🎯 Be Specific:** Use targeted search queries like "vegan restaurants" vs "restaurants" 📅 Schedule Runs:** Set up recurring analysis to track market changes 🌍 Multi-Location:** Run for multiple cities to compare markets 📱 Mobile-First:** Reports are mobile-responsive for on-the-go reading 🔄 Iterate:** Refine search parameters based on initial results Ready to unlock your market insights? Configure your parameters and execute the workflow!
by Robert Breen
This n8n workflow automates bulk AI image generation using Freepik's Text-to-Image API. It reads prompts from a Google Sheet, generates multiple variations of each image using Freepik's AI, and automatically uploads the results to Google Drive with organized file names. This is perfect for content creators, marketers, or designers who need to generate multiple AI images in bulk and store them systematically. Key Features: Bulk image generation from Google Sheets prompts Multiple variations per prompt (configurable duplicates) Automatic file naming and organization Direct upload to Google Drive Batch processing for efficient API usage Freepik AI-powered image generation Step-by-Step Implementation Guide Prerequisites Before setting up this workflow, you'll need: n8n instance (cloud or self-hosted) Freepik API account with Text-to-Image access Google account with access to Sheets and Drive Google Sheet with your prompts Step 1: Set Up Freepik API Credentials Go to Freepik API Developer Portal Create an account or sign in Navigate to your API dashboard Generate an API key for Text-to-Image service Copy the API key and save it securely In n8n, go to Credentials → Add Credential → HTTP Header Auth Configure as follows: Name: "Header Auth account" Header Name: x-freepik-api-key Header Value: Your Freepik API key Step 2: Set Up Google Credentials Google Sheets Access: Go to Google Cloud Console Create a new project or select existing one Enable Google Sheets API Create OAuth2 credentials In n8n, go to Credentials → Add Credential → Google Sheets OAuth2 API Enter your OAuth2 credentials and authorize with spreadsheets.readonly scope Google Drive Access: In Google Cloud Console, enable Google Drive API In n8n, go to Credentials → Add Credential → Google Drive OAuth2 API Enter your OAuth2 credentials and authorize Step 3: Create Your Google Sheet Create a new Google Sheet: sheets.google.com Set up your sheet with these columns: Column A: Prompt (your image generation prompts) Column B: Name (identifier for file naming) Example data: | Prompt | Name | |-------------------------------------------|-------------| | A serene mountain landscape at sunrise | mountain-01 | | Modern office space with natural lighting | office-02 | | Cozy coffee shop interior | cafe-03 | Copy the Sheet ID from the URL (the long string between /d/ and /edit) Step 4: Set Up Google Drive Folder Create a folder in Google Drive for your generated images Copy the Folder ID from the URL when viewing the folder Note: The workflow is configured to use a folder called "n8n workflows" Step 5: Import and Configure the Workflow Copy the provided workflow JSON In n8n, click Import from File or Import from Clipboard Paste the workflow JSON Configure each node as detailed below: Node Configuration Details: Start Workflow (Manual Trigger) No configuration needed Used to manually start the workflow Get Prompt from Google Sheet (Google Sheets) Document ID**: Your Google Sheet ID (from Step 3) Sheet Name**: Sheet1 (or your sheet name) Operation**: Read Credentials**: Select your "Google Sheets account" Double Output (Code Node) Purpose**: Creates multiple variations of each prompt JavaScript Code**: const original = items[0].json; return [ { json: { ...original, run: 1 } }, { json: { ...original, run: 2 } }, ]; Customization**: Add more runs for additional variations Loop (Split in Batches) Processes items in batches to manage API rate limits Options**: Keep default settings Reset**: false Create Image (HTTP Request) Method**: POST URL**: https://api.freepik.com/v1/ai/text-to-image Authentication**: Generic → HTTP Header Auth Credentials**: Select your "Header Auth account" Send Body**: true Body Parameters**: Name: prompt Value: ={{ $json.Prompt }} Split Responses (Split Out) Field to Split Out**: data Purpose**: Separates multiple images from API response Convert to File (Convert to File) Operation**: toBinary Source Property**: base64 Purpose**: Converts base64 image data to file format Upload Image to Google Drive (Google Drive) Operation**: Upload Name**: =Image - {{ $('Get Prompt from Google Sheet').item.json.Name }} - {{ $('Double Output').item.json.run }} Drive ID**: My Drive Folder ID**: Your Google Drive folder ID (from Step 4) Credentials**: Select your "Google Drive account" Step 6: Customize for Your Use Case Modify Duplicate Count: Edit the "Double Output" code to create more variations Update File Naming: Change the naming pattern in the Google Drive upload node Adjust Batch Size: Modify the Loop node settings for your API limits Add Image Parameters: Enhance the HTTP request with additional Freepik parameters (size, style, etc.) Step 7: Test the Workflow Ensure your Google Sheet has test data Click Execute Workflow on the manual trigger Monitor the execution flow Check that images are generated and uploaded to Google Drive Verify file names match your expected pattern Step 8: Production Deployment Set up error handling for API failures Configure appropriate batch sizes based on your Freepik API limits Add logging for successful uploads Consider webhook triggers for automated execution Set up monitoring for failed executions Freepik API Parameters Basic Parameters: prompt: Your text description (required) negative_prompt: What to avoid in the image guidance_scale: How closely to follow the prompt (1-20) num_inference_steps: Quality vs speed trade-off (20-100) seed: For reproducible results Example Enhanced Body: { "prompt": "{{ $json.Prompt }}", "negative_prompt": "blurry, low quality", "guidance_scale": 7.5, "num_inference_steps": 50, "num_images": 1 } Workflow Flow Summary Start → Manual trigger initiates the workflow Read Sheet → Gets prompts and names from Google Sheets Duplicate → Creates multiple runs for variations Loop → Processes items in batches Generate → Freepik API creates images from prompts Split → Separates multiple images from response Convert → Transforms base64 to binary file format Upload → Saves images to Google Drive with organized names Complete → Returns to loop for next batch Contact Information Robert A Ynteractive For support, customization, or questions about this workflow: 📧 Email: rbreen@ynteractive.com 🌐 Website: https://ynteractive.com/ 💼 LinkedIn: https://www.linkedin.com/in/robert-breen-29429625/ Need help implementing this workflow or want custom automation solutions? Get in touch for professional n8n consulting and workflow development services.
by Satva Solutions
Automated QuickBooks Invoice to Custom PDF & Email This n8n workflow automates the entire QuickBooks invoicing process — from creation to delivery. When a new invoice is generated in QuickBooks Online, it automatically fetches the data, applies your company branding, converts it into a professional multi-page PDF via Gotenberg, and emails it directly to your client. Key Features: ⚡ Fully Automated: Triggers instantly on new QuickBooks invoices. 🧾 Custom Branding: Adds your logo and signature from public URLs. 🎨 Modern PDF Design: Clean, professional multi-page layout with smart totals and “Page X of Y” footers. 📧 Automatic Emailing: Sends the final PDF in a formatted email to your customer. Requirements: QuickBooks Online, n8n instance, Gotenberg (HTML→PDF converter), and public URLs for logo/signature.
by AppUnits AI
Generate Invoices and Send Reminders for Customers with Jotform and QuickBooks This workflow automates the entire process of receiving a product/service order, checking or creating a customer in QuickBooks Online (QBO), generating an invoice, emailing it — all triggered by a form submission (via Jotform), and sending invoice reminders. How It Works Receive Submission Triggered when a user submits a form. Collects data like customer details, selected product/service, etc. Check If Customer Exists Searches QBO to determine if the customer already exists. If Customer Exists:* *Update** customer details (e.g., billing address). If Customer Doesn’t Exist:* *Create** a new customer in QBO. Get The Item Retrieves the selected product or service from QBO. Create The Invoice Generates a new invoice for the customer using the item selected. Send The Invoice Automatically sends the invoice via email to the customer. Store The Invoice In DB Stores the needed invoice details in the DB. Send Reminders Every day at 8 AM, the automation checks each invoice to decide whether to: send a reminder email, skip and send it later, or delete the invoice from the DB (if it's paid or all reminders have been sent). Who Can Benefit from This Workflow? Freelancers** Service Providers** Consultants & Coaches** Small Businesses** E-commerce or Custom Product Sellers** Requirements Jotform webhook setup, more info here QuickBooks Online credentials, more info here Email setup, update email nodes (Send reminder email & Send reminders sent summary) Create data table with the following columns: invoiceId (string) remainingAmount (number) currency (string) remindersSent (number) lastSentAt (date time) Update Add reminders config node so update the data table id and intervals in days (default is after 2 days, then after 3 days and finally after 5 days ) LLM model credentials
by Annie To
This workflow automatically processes customer support requests from emails and web forms, uses AI to classify and either auto-resolve simple issues or intelligently route complex ones to the right team members with proper JIRA tickets and SLA tracking. Key Benefits Multi-channel support (email + web forms) Smart routing to qualified agents based on expertise Consistent ticket creation with full context in JIRA Perfect For Support teams handling 50+ requests/day SaaS companies with tiered customer support Organizations wanting to scale support without hiring Teams needing consistent ticket classification Requirements Microsoft Outlook (email monitoring) OpenAI API (AI classification) JIRA Cloud (ticket management) n8n instance with AI nodes
by Oneclick AI Squad
This workflow automates the generation of a daily stock market report, identifying the top gainers and losers among the top 100 stocks. It fetches real-time stock data, processes it to highlight significant price movements, and delivers formatted alerts via WhatsApp and email. Quick Notes Ensure the Twelve Data API key and stock symbols are correctly configured. Verify recipient lists for WhatsApp and email alerts are up-to-date. Confirm the workflow triggers at 5:00 PM (IST) from Monday to Friday. Process Flow Trigger the workflow daily at 5:00 PM (IST) with the Daily Market Change Trigger node. Configure API key, stock symbols, and alert recipients using the Configuration Variables node. Fetch stock data from Twelve Data API with the Fetch Stock Data from Twelve Data node. Process stock data to identify top gainers and losers with the Process Stock Movements node. Format WhatsApp messages with the Format WhatsApp Message node. Send WhatsApp alerts with the Send WhatsApp Alert node. Format email content with the Format Email Content node. Send email alerts with the Send Email Alert node. Output Getting Started Import the workflow into n8n and configure Twelve Data API credentials. Set up WhatsApp and email service integrations. Run a test execution to ensure data fetching and alert delivery work as expected. Tailored Adjustments Adjust the Process Stock Movements node to change the number of top gainers/losers. Modify the Configuration Variables node to include additional stock symbols or recipient lists.
by Oneclick AI Squad
This workflow automates the generation of a daily crypto market report, identifying the top 24-hour gainers and losers among the top 100 cryptocurrencies. It fetches real-time data, processes it to highlight significant price movements, and delivers formatted alerts via WhatsApp and email. Quick Notes Ensure the CoinGecko API key is correctly configured. Verify phone numbers and email addresses for alert recipients. Confirm the workflow triggers at 00:00 UTC daily. Process Flow Trigger the workflow daily at 00:00 UTC with the Daily Crypto Trigger node. Configure phone numbers, email addresses, and API key with the Set Configuration Variables node. Fetch crypto data from CoinGecko API with the Fetch Crypto Data from CoinGecko node. Process crypto data to rank top 24-hour movements with the Process Crypto Movements node. Format WhatsApp messages with the Format WhatsApp Message node. Send WhatsApp alerts with the Send WhatsApp Alert node. Format email content with the Format Email Content node. Send email alerts with the Send Email Alert node. Output Getting Started Import the workflow into n8n and set up CoinGecko API credentials. Configure WhatsApp and email service integrations. Run a test execution to verify data fetching and alert delivery. Tailored Adjustments Adjust the Process Crypto Movements node to change the number of top gainers/losers. Modify the Set Configuration Variables node to include additional recipient contacts or API parameters.
by Lukman
This n8n workflow lets you delegate inbox management to an AI agent. It automatically replies to emails when a suitable response is found in your knowledge base. If no match is found, the message is forwarded to a human for review. This ensures all replies follow company guidelines and prevent misinformation or misrepresentation. Use Case Ideal for businesses that receive frequent inquiries about products or services and want to automate responses, freeing up time to focus on core operations. How It Works Polls your inbox for new incoming emails Cleans HTML to reduce token usage and filters spam Categorizes emails for better organization Retrieves conversation history from Supabase (if available) to give the AI proper context Uses the AI agent to query your FAQ database for relevant answers Replies automatically if a suitable answer is found Sends a placeholder email and forwards to a human if no accurate answer exists Ingests all processed emails into Supabase to retain conversation history and improve future AI accuracy Customization You can connect any email provider or LLM model. The workflow can also be expanded to let the AI schedule meetings, answer availability questions, or handle other inbox tasks. If you'd like help tailoring this workflow to your business, feel free to reach out: Upwork Profile
by AppUnits AI
Generate Invoices and Send Reminders for Customers with Jotform and Xero This workflow automates the entire process of receiving a product/service order, checking or creating a customer in Xero, generating an invoice, emailing it — all triggered by a form submission (via Jotform), and sending invoice reminders. How It Works Receive Submission Triggered when a user submits a form. Collects data like customer details, selected product/service, etc. Create/Update The Customer Creates/Updates the customer. Create The Invoice Generates a new invoice for the customer using the item selected. Send The Invoice Automatically sends the invoice via email to the customer. Store The Invoice In DB Stores the needed invoice details in the DB. Send Reminders Every day at 8 AM, the automation checks each invoice to decide whether to: send a reminder email, skip and send it later, or delete the invoice from the DB (if it's paid or all reminders have been sent). Who Can Benefit from This Workflow? Freelancers** Service Providers** Consultants & Coaches** Small Businesses** E-commerce or Custom Product Sellers** Requirements Jotform webhook setup, more info here Xero credentials, more info here Make sure that products/services values in Jotform are exactly the same as your item Code in your Xero account Email setup, update email nodes (Send email & Send reminder email & Send reminders sent summary) Create data table with the following columns: invoiceId (string) remainingAmount (number) currency (string) remindersSent (number) lastSentAt (date time) Update Add reminders config node so update the data table id and intervals in days (default is after 2 days, then after 3 days and finally after 5 days ) LLM model credentials
by Hyrum Hurst
Who this workflow is for Law firms in corporate, litigation, or family law needing streamlined case and contract management. What this workflow does Automatically analyzes contracts using AI, extracts key clauses, logs cases in Google Sheets, routes cases to attorneys, sends client summaries, generates PDFs, and schedules follow-ups. How the workflow works Webhook triggers on new case or contract AI analyzes contract Case routed by type Logs case info in Google Sheets Notifies attorney via Slack Sends client email summary Generates PDF report Schedules follow-up events Optional integration with practice management software Author: Hyrum Hurst, AI Automation Engineer Company: QuarterSmart Contact: hyrum@quartersmart.com
by Hyrum Hurst
Who this workflow is for Door-to-door HVAC companies seeking automated lead capture and appointment scheduling. What this workflow does AI classifies incoming leads, routes them by service type, logs lead info in Google Sheets, notifies team via Slack, sends confirmations, schedules appointments, and optionally sends SMS reminders. How the workflow works Lead submission triggers workflow AI classifies lead Route lead based on service type Log in Google Sheets Notify team via Slack Send confirmation email Schedule appointment in calendar Send SMS reminder (optional) Optional CRM/dispatch integration Author: Hyrum Hurst, AI Automation Engineer Company: QuarterSmart Contact: hyrum@quartersmart.com