Create an automated workitem(incident/bug/userstory) in azure devops
Who is this template for?
This template can be used by any automator who wants to create a workitem(incident/user story/bugs) in azure devops whenever an alert raised by systems.
How it works
- Each time an alert raised in system( for ex: Elastic raises an alert for missing host or domain).
- Workflow reads an alert and creates a workitem in azure devops
- Workflow can be customized to send any required information as possible in azure devops
Setup Instructions
- Azure DevOps Organization and Project: Make sure you have access to an Azure DevOps organization and a project where the work item will be created.
- Personal Access Token (PAT): You need a Personal Access Token with permissions to create work items. You can generate a PAT from the Azure DevOps user settings.
n8n Workflow: Scheduled Data Retrieval and Conditional Processing
This n8n workflow demonstrates a basic scheduled process that retrieves data, then conditionally routes it based on a simple check. It's a foundational example for building more complex data processing and automation tasks.
What it does
This workflow performs the following steps:
- Triggers on a Schedule: The workflow starts automatically at predefined intervals using a Cron trigger.
- Retrieves Data: It makes an HTTP request, likely to an API endpoint, to fetch some data.
- Applies Conditional Logic: It evaluates the retrieved data using an If node.
- Routes Data (No Operation):
- If the condition in the
Ifnode evaluates totrue, the data is passed to aNo Operation, do nothingnode, effectively ending that branch of the workflow without further action. - If the condition in the
Ifnode evaluates tofalse, the data is passed to anElasticsearchnode, indicating an intention to interact with an Elasticsearch instance.
- If the condition in the
Prerequisites/Requirements
To use this workflow, you will need:
- n8n Instance: A running n8n instance.
- HTTP Endpoint: An accessible HTTP endpoint that the
HTTP Requestnode can query to retrieve data. - Elasticsearch Account/Instance: If the
Ifcondition evaluates to false, the workflow is configured to interact with an Elasticsearch instance. You would need credentials and configuration for this.
Setup/Usage
- Import the Workflow:
- Copy the provided JSON code.
- In your n8n instance, go to "Workflows" and click "New".
- Click the "Import from JSON" button and paste the JSON code.
- Click "Import".
- Configure the Cron Trigger:
- Open the
Cronnode. - Adjust the schedule to your desired frequency (e.g., every hour, daily).
- Open the
- Configure the HTTP Request Node:
- Open the
HTTP Requestnode. - Set the
URLto the API endpoint you wish to query. - Configure any necessary
Authentication(e.g., API Key, OAuth2) orHeaders.
- Open the
- Configure the If Node:
- Open the
Ifnode. - Define the
Conditionsbased on the data you expect from theHTTP Requestnode. For example, you might check if a specific field exists or has a certain value.
- Open the
- Configure the Elasticsearch Node (if applicable):
- Open the
Elasticsearchnode. - Select or create an
Elasticsearchcredential. - Configure the desired
Operation(e.g., Index, Get, Search) andIndexbased on your needs.
- Open the
- Activate the Workflow:
- Once configured, save the workflow and activate it by toggling the "Active" switch in the top right corner of the workflow editor.
This workflow provides a flexible starting point for automating tasks that involve scheduled data retrieval, conditional logic, and integration with Elasticsearch.
Related Templates
Generate verified job offer letters with OpenAI, Gmail and Slack
π 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. β¨ ---
Track meal nutrition from meal photos with LINE, Google Gemini and Google Sheets
AI Meal Nutrition Tracker with LINE and Google Sheets Who's it for This workflow is designed for health-conscious individuals, fitness enthusiasts, and anyone who wants to track their daily food intake without manual calorie counting. It is best suited for users who want a simple, AI-powered meal logging system that analyzes food photos one at a time and provides instant nutritional feedback via LINE. What it does This workflow processes a single meal photo sent via LINE, analyzes it using Google Gemini AI to identify foods and estimate nutritional content, and stores the data in Google Sheets for tracking. The workflow focuses on simplicity and encouragement: it receives a meal image, performs AI-based food recognition, estimates calories and macronutrients, calculates a health score, provides personalized advice, and replies with a detailed nutritional breakdown on LINE. How it works A single meal photo is sent to the LINE bot. The workflow is triggered via a LINE webhook. The image file is downloaded and sent to Google Gemini AI for food analysis. The AI identifies foods and estimates nutritional values (calories, protein, carbs, fat, fiber). A health score (1-10) is calculated with personalized improvement tips. The data is appended to Google Sheets for meal history tracking. The image is uploaded to Google Drive for reference. A formatted nutritional report with advice is sent back as a LINE reply. This workflow is intentionally designed to handle one image per execution. Requirements To use this workflow, you will need: A LINE Messaging API account A Google Gemini API key A Google account with access to Google Sheets and Google Drive A Google Sheets document with the following column names: Date Time Meal Type Food Items Calories Protein (g) Carbs (g) Fat (g) Fiber (g) Health Score Advice Image URL Important limitations This workflow does not support multiple images sent in a single message. Sending images in quick succession may trigger multiple executions and lead to unexpected results. Only the first image in an event payload is processed. Nutritional values are AI estimates based on visual analysis and typical serving sizes. Accuracy depends on image quality, lighting, and food visibility. This tool should not replace professional dietary advice. These limitations are intentional to keep the workflow simple and easy to understand. How to set up Create a LINE Messaging API channel and obtain a Channel Access Token. Generate a Google Gemini API key. Update the Config node with your LINE token, Google Sheets ID, Google Drive folder ID, and daily calorie goal. Configure credentials for LINE, Google Gemini, Google Sheets, and Google Drive. Register the n8n webhook URL in your LINE channel settings. Activate the workflow in n8n and test it with a single meal photo. How to customize Modify the AI prompt in the "Analyze Meal with AI" node to support different languages or dietary frameworks (keto, vegan, etc.). Adjust the daily calorie goal in the Config node to match individual needs. Add additional nutritional fields such as sodium, sugar, or vitamins. Replace Google Sheets with a fitness app API or database. Integrate with other services to send daily/weekly nutrition summaries. --- Note: This workflow was tested using real meal photos sent individually via the LINE Messaging API. Nutritional estimates are approximations and may vary from actual values. For accurate dietary tracking, consult a registered dietitian.
Track free Udemy courses automatically with RapidAPI and Google Sheets
This workflow fetches free Udemy courses hourly via the Udemy Coupons and Courses API on RapidAPI, filters them, and updates a Google Sheet. It sends alerts on errors for smooth monitoring. --- Node-by-Node Explanation Schedule Trigger: Runs the workflow every hour automatically. Fetch Udemy Coupons: Sends POST request to the Udemy Coupons and Courses API on RapidAPI to get featured courses. Check API Success: Verifies if the API response is successful; routes accordingly. Filter Free Courses: Selects only courses with sale_price of zero (free courses). Send Error Notification: Emails admin if API fetch fails for quick action. Sync Courses to Google Sheet: Appends or updates the filtered free courses into Google Sheets. --- Google Sheets Columns id name price sale_price image lectures views rating language category subcategory slug store sale_start --- Google Sheets Setup & Configuration Steps Create Google Sheet: Create or open a Google Sheet where you want to sync courses. Set Headers: Add columns headers matching the fields synced (id, name, price, etc.). Enable Google Sheets API: Go to Google Cloud Console, enable Google Sheets API for your project. Create Service Account: In Google Cloud Console, create a Service Account with editor access. Download Credentials: Download the JSON credentials file from the service account. Share Sheet: Share your Google Sheet with the Service Account email (found in JSON file). Configure n8n Google Sheets Node: Use the service account credentials, set operation to βAppend or Updateβ, provide Sheet URL and sheet name or gid. Match Columns: Map the course fields to your sheet columns and set id as the unique key for updates. --- How to Obtain RapidAPI Key & Setup API Request Sign up/Login: Visit RapidAPI Udemy Coupons and Courses API and create an account or log in. Subscribe to API: Subscribe to the Udemy Coupons and Courses API plan (free or paid). Get API Key: Navigate to your dashboard and copy your x-rapidapi-key. Configure HTTP Request: In your workflowβs HTTP Request node: Set method to POST. URL: https://udemy-coupons-and-courses.p.rapidapi.com/featured.php Add headers: x-rapidapi-host: udemy-coupons-and-courses.p.rapidapi.com x-rapidapi-key: your copied API key Set content type to multipart/form-data. Add body parameter: page=1 (or as needed). Test API: Run the node to ensure the API responds with data successfully before continuing workflow setup. --- Use Cases & Benefits Automates daily updates of free Udemy courses in your sheet using the Udemy Coupons and Courses API on RapidAPI. Saves manual effort in tracking coupons and deals. Enables quick error alerts to maintain data accuracy. Ideal for course aggregators, affiliate marketers, or learning platforms needing fresh course data. --- Who This Workflow Is For Content curators and edtech platforms tracking free courses. Affiliate marketers promoting Udemy deals. Anyone needing real-time access to updated free Udemy coupons.