Business Operations & ERPs Workflows
Enterprise resource planning and operations
Automate Upwork Job Aggregation and Notification with AI Summaries
This workflow automates the aggregation of Upwork job postings based on your criteria, logs them in Google Sheets, generates AI-based summaries, and sends notifications via email.
n8n$9.99Auto-Renew AWS Certificates with Slack Approval Workflow
# AWS Certificate Manager (ACM) Auto-Renew with Slack Notify & Approval ## **Who's it for** - SRE/DevOps teams managing many ACM certs. - Cloud ops who want **hands-off renewals** with an **approval step in Slack**. - MSPs that need auditable reminders and renewals on schedule. ## **How it works / What it does** 1. **Schedule Trigger** - runs daily (or your cadence). 2. **Get many certificates** - fetches ACM certs (paginate if needed). 3. **Filter: expiring in next 7 days** - keeps items where: - `NotAfter` **before** `today + 7d` - `NotBefore` **before** `today` (already valid) 4. **Send message and wait for response (Slack)** - posts a certificate summary and **pauses** until Approve/Reject. 5. **Renew a certificate** - on **Approve**, calls the renew action for the item. ## **How to set up** 1. **Credentials** - **AWS** in n8n with permissions to list/read/renew certs. - **Slack** OAuth (bot in the target channel). 2. **Schedule Trigger** - Set to run once per day (e.g., `09:00` local). 3. **Get many certificates** - Region: your ACM region(s). - If you have several regions, loop regions or run multiple branches. 4. **Filter (IF / Filter node)** - Add these two conditions (AND): - `{{ $json.NotAfter.toDatetime(s) }}` **is before** `{{ $today.plus(7,days) }}` - `{{ $json.NotBefore.toDatetime(s) }}` **is before** `{{ $today }}` 5. **Slack – Send & Wait** - Message (text input): ``` :warning: *ACM Certificate Expiry Alert* :warning: *Domain:* {{ $json.DomainName }} *SANs:* {{ $json.SubjectAlternativeNameSummaries }} *ARN:* {{ $json.CertificateArn }} *Algo:* {{ $json.KeyAlgorithm }} *Status:* {{ $json.Status }} *Issued:* {{ $json.IssuedAt | toDate | formatDate(YYYY-MM-DD HH:mm) }} *Expires:* {{ $json.NotAfter | toDate | formatDate(YYYY-MM-DD HH:mm) }} Approve to start renewal. ``` - Add two buttons: **Approve** / **Reject** (the node will output which was clicked). 6. **Renew a certificate** - Map the **CertificateArn** from the Slack Approved branch. ## **Requirements** - n8n (current version with Slack *Send & Wait*). - AWS IAM permissions (read + renew ACM), e.g.: - `acm:ListCertificates`, `acm:DescribeCertificate`, `acm:RenewCertificate` (plus region access). - Slack bot with permission to post & use interactivity in the target channel. ## **How to customize the workflow** - **Window size:** change `7` to `14` or `30` days in the filter. - **Catch expired**: add an OR path `{{ $json.NotAfter.toDatetime(s) }} is before {{ $today }}` – send a **red** Slack alert. - **Auto-renew w/o approval:** bypass Slack and renew directly for low-risk domains. - **Multiple regions/accounts:** iterate over a list of regions or assume roles per account. - **Logging:** add a Google Sheet/DB append after Slack click with `user`, `time`, `result`. - **Escalation:** if no Slack response after N hours, ping `@oncall` or open a ticket. ## **Notes** - The Slack node **pauses** execution until a button is clicked—perfect for change control. - Time conversions above assume `NotAfter`/`IssuedAt` are Unix seconds (`s`). Adjust if your data differs.
n8n$9.99Streamline Quote Requests with Tally, Airtable, Slack, and Gmail Automation
Automate your quote request process by capturing form submissions, notifying your sales team, storing leads in Airtable, and sending email confirmations—all seamlessly integrated in one n8n workflow.
n8n$9.99Automate Supply Chain Risk Monitoring with AI Alerts via Slack and Email
This workflow automates the monitoring of supply chain risks by using AI to analyze supplier health and industry news, providing real-time alerts and daily reports to procurement teams via Slack and email.
n8n$14.99ERP AI Chatbot for Odoo Sales Module with OpenAI
## Who is this for? This workflow is for everyone who wants to have easier access to their Odoo sales data without complex queries. ## Use Case To have a clear overview of your sales data in Odoo, you typically need to extract data from it manually to analyze it. This workflow uses OpenAI's language models to create an intelligent chatbot that provides conversational access to your Odoo sales opportunity data. ## How it works - Creates a summary of all Odoo sales opportunities using OpenAI - Uses that summary as context for the OpenAI chat model - Keeps the summary up to date using a schedule trigger ## Set up steps: - Configure the Odoo credentials - Configure OpenAI credentials - Toggle "Make Chat Publicly Available" from the Chat Trigger node.
n8n$14.99Automate Incident Reporting & Alerts with Forms, Google Sheets, and Gmail
# Incident Reporting & Management Workflow (Form + Google Sheets + Email) This workflow automates incident reporting and management for operations teams by connecting a public reporting form with real-time logging in Google Sheets and instant alert emails to your support team. Whenever an incident is reported via the n8n form/webhook, all details are saved securely and immediately, and the right people are notified the moment issues occur. It's a fast, scalable solution for reliable incident handling. ## Who's It For - Renewable energy operators (solar/wind/green energy). - Facility and plant managers. - Environmental, EHS, and safety teams. - Technical support and incident response crews. - Maintenance & field operations teams. - Anyone aiming for compliance-ready, audit-friendly digital issue reporting. ## How It Works 1. **Form Submission**: An n8n-powered form (or webhook endpoint) receives incident reports, capturing all key details: reporter info, contact, location, date/time, type, severity, actions taken, photos, and more. 2. **Log to Google Sheets**: Each report is instantly appended as a new row in a secure Google Sheet, creating a searchable, timestamped audit trail. 3. **Email Alert (Gmail)**: An automatic email with incident summary and critical details lands in the support team's inbox seconds after submission, ensuring your response is always prompt. 4. **Workflow Automation**: These nodes are linked in n8n, enabling no-code/low-code back-end automation for complete visibility and control. ## How to Set Up 1. **Import Workflow**: In n8n, use Import from File to upload the workflow JSON provided. 2. **Edit Configuration**: - Update form fields as needed (label, validations, options for severity/category). - Enter your Google Sheet ID and sharing settings. - Configure Gmail/SMTP credentials and recipient address (example: `supportteam@mailinator.com` or your own team). 3. **Deploy Webhook**: Copy your n8n webhook URL and connect it to your reporting interface (form, app, device, etc.). 4. **Activate**: Enable the workflow in n8n. Submissions are now handled in real-time. 5. **Test**: Submit a sample incident to make sure data logs in Google Sheets and the alert email arrives as expected. ## Requirements | Tool | Purpose | |-----------------|-----------------------------------| | n8n Instance | Orchestrates the workflow | | Google Account | To access/use Google Sheets | | Gmail/SMTP | For sending incident alerts | | Incident Source | n8n Form, webhook, app, or device| ## How to Customize - **Form Fields**: Add/remove fields or validations in the n8n form for organization-specific needs (e.g., add photos, custom categories). - **Alert Routing**: Use IF nodes to send critical alerts via Slack, SMS, or escalate to on-call teams based on severity/type. - **Backend**: Replace Google Sheets with Notion, Airtable, PostgreSQL, or other databases. - **Reporting**: Add PDF nodes to auto-generate and send report summaries. - **Integrations**: Push incidents to ticketing, asset tracking, or calendar scheduling workflows. ## Add-Ons (Optional Extensions) | Feature | Description | |------------------|------------------------------------------------------| | Slack Alerts | Instantly notify Slack channels on critical issues | | Database Logging | Store reports in SQL/NoSQL systems | | PDF Generation | Email ready-to-use incident reports as PDFs | | Calendar Events | Schedule follow-ups or deadline reminders | | AI Categorization | Auto-classify incidents by severity/type | | Task Creation | Open tickets in Jira, Trello, ClickUp, or Asana | ## Use Case Examples - Field engineers report solar inverter faults with mobile forms. - Security personnel log site intrusions, with photos and severity. - IoT sensors auto-post equipment failures as incidents. - Compliance or EHS teams capture safety observations in real-time. - Technicians submit maintenance or post-repair issues instantly. ## Common Troubleshooting | Issue | Possible Cause | Solution | |--------------------------|---------------------------------------|----------------------------------------------------------| | Form not triggering | Webhook URL incorrect | Double-check webhook endpoint and method (POST) | | Email not delivered | Wrong SMTP/Gmail credentials | Re-enter credentials or verify SMTP access | | Google Sheets not updated | Sheets ID wrong/missing permissions | Use correct ID, share sheet with service account or make accessible | | Missing report fields in log | Form field names or types mismatch | Align JSON/form data keys with workflow node mappings | | Attachments not saved | Field not set for file type | Review form field definitions and adjust as needed | ## Need Help? Want a tailored setup, advanced automations, or powerful add-ons (AI, SLAs, PDF logs, ticketing integration)? Our n8n workflow experts at WeblineIndia are ready to help you engineer seamless incident management for any industry. ☎️ Contact WeblineIndia - Your Automation
n8n$4.99Create Notes and Comments on Any Odoo Model Record
## Introduction This workflow is designed to create and attach notes or comments to any record in your Odoo instance. It acts as a sub-workflow that can be triggered by a main workflow to log messages or comments in a centralized manner. By leveraging the powerful Odoo API, this template ensures that updates to records are handled efficiently, providing an organized way to document important information related to your business processes. ## Setup Instructions Import the Workflow: Import the provided JSON file into your n8n instance. ## Odoo Credentials: Ensure you have valid Odoo API credentials (e.g., Odoo's Odoo Automation Account) configured in n8n. ## Node Configuration: Verify that the Odoo node (consider renaming it to Odoo Record Manager for clarity) is set up with your server details and authentication parameters. Check that the workflow trigger (When Executed by Another Workflow) is configured to receive input parameters from the parent workflow. ## Execution Trigger: This workflow is designed to be initiated by another workflow. Make sure the main workflow supplies the required inputs. ### Workflow Details Trigger Node: The workflow begins with the When Executed by Another Workflow node, which accepts three inputs: - rec_id: A numeric identifier for the Odoo record. - message: The text of the comment or note. - model: The specific Odoo model (e.g., rs.deployment.action.log) where the note should be attached. ### Odoo Node: The second node in the workflow calls the Odoo API to create a new log message. It maps the inputs as follows: - message_type is set to comment. - model is assigned the provided model name. - res_id is assigned the record ID (rec_id). - body is assigned the message content. ## Additional Information: A sticky note node is included to provide a brief overview of the workflow's purpose directly within the interface. ### Input Parameters Record ID (rec_id): The unique identifier of the record in Odoo where the note will be added. ### Message (message): The content of the comment or note that is to be logged. ### Model (model): The Odoo model name indicating the context in which the note should be created (e.g., rs.deployment.action.log). ## Usage Examples ### Internal Logging: Use the workflow to attach internal comments or logs to specific records, such as customer profiles, orders, or deployment logs. ### Audit Trails: Create a comprehensive audit trail by documenting changes or important events in Odoo records. ### Integration with Other Workflows: Link this workflow with other automation processes in n8n (like email notifications, data synchronization, or reporting) to create a seamless integration across your systems. ### Pre-conditions The Odoo instance must be accessible and correctly configured. API permissions and user roles should be validated to ensure that the workflow has the necessary access rights. The workflow expects inputs from an external trigger or parent workflow. ## Customization & Integration This template offers several customization options to tailor it to your needs: - Field Customization: Modify or add new fields to match your logging or commenting requirements. - Node Renaming: Rename nodes for better clarity and consistency within your workflow ecosystem. - **Integration Possibilities**: Easily integrate this workflow with other processes in n8n, such as triggering notifications or synchronizing data across different systems. This sub-workflow receives data from a main workflow (for example, a record ID, a message, and the Odoo model) and creates a new note (or comment) in the corresponding Odoo record. Essentially, it acts as a centralized point for logging comments or notes in a specific Odoo model, ensuring that the information remains organized and easy to track. Your model must inherit from _inherit = ['portal.mixin', 'mail.thread', 'mail.activity.mixin']
n8n$3.99Automate Trello Card Deletion for Specific Labels
Streamline your Trello board management by automatically deleting cards labeled 'Mark for Deletion'. This workflow efficiently identifies and removes these cards, ensuring your boards remain organized without manual intervention.
n8n$9.99Automatically Send Monthly Sales Reports from Square via Gmail
## Automatically Send Monthly Sales Reports from Square via Gmail ## What It Does This workflow automatically connects to the Square API and generates a **monthly** sales summary report for all your Square locations. The report matches the figures displayed in **Square Dashboard > Reports > Sales Summary**. It's designed to run monthly and pull the **previous month's** sales into a CSV file, which is then sent to a manager/finance team for analysis. This workflow builds on my previous template, which allows users to automatically pull data from the Square API into n8n for processing. (See here: https://n8n.io/workflows/6358) ## Prerequisites To use this workflow, you'll need: - A Square API credential (configured as a Header Auth credential) - A Gmail credential ## How to Set Up Square Credentials: - Go to **Credentials > Create New** - Choose **Header Auth** - Set the **Name** to `Authorization` - Set the **Value** to your Square Access Token (e.g., `Bearer <your-api-key>`) ## How It Works 1. **Trigger:** The workflow runs on the **1st of every month at 8:00 AM** 2. **Fetch Locations:** An HTTP request retrieves all Square locations linked to your account 3. **Fetch Orders:** For each location, an HTTP request pulls completed orders for the **previous calendar month** 4. **Filter Empty Locations:** Locations with no sales are ignored 5. **Aggregate Sales Data:** A Code node processes the order data and produces a summary identical to Square's built-in Sales Summary report 6. **Create CSV File:** A CSV file is created containing the relevant data 7. **Send Email:** An email is sent using Gmail to the chosen third party ## Example Use Cases - Automatically send monthly Square sales data to management for forecasting and planning - Automatically send data to an external third party, such as a landlord or agent, who is paid via commission - Automatically send data to a bookkeeper for entry into QuickBooks ## How to Use - Configure both HTTP Request nodes to use your Square API credential - Set the workflow to **Active** so it runs automatically - Enter the email address of the person you want to send the report to and update the message body - If you want to remove the n8n attribution, you can do so in the last node ## Customization Options - Add pagination to handle locations with more than 1,000 orders per month - Adjust the date filters in the HTTP node to cover the full calendar month (e.g., use Luxon or JavaScript to calculate `start_date` and `end_date`) ## Why It's Useful This workflow saves time, reduces manual report pulling from Square, and enables smarter automation around sales data - whether for operations, finance, or performance monitoring.
n8n$14.99Automate QuickBooks Invoice Notifications to Slack
This n8n workflow automatically sends detailed Slack alerts whenever a new invoice is created or updated in QuickBooks, ensuring real-time financial visibility for your team.
n8n$9.99AI Multi-Stop Planner for Circular Logistics with GPT-4o & Open Route API
**Tags**: AI Agent, Supply Chain, Logistics, Circular Economy, Route Planning, Transportation, GPS API ### Context Hi! I'm Samir, a Supply Chain Engineer and Data Scientist based in Paris, and founder of [LogiGreen Consulting](https://logi-green.com). I help logistics teams reduce operational workload and errors by combining **AI automation**, **route optimization APIs**, and **workflow automation**. This workflow is part of a **circular economy project**, where stores return **reusable packaging** (bins, crates, containers) to a central warehouse. > Let's support circular economies with AI-powered automation using n8n! For business inquiries, you can find me on [LinkedIn](https://www.linkedin.com/in/samir-saci) ### Who is this template for? This workflow is designed for logistics teams participating in **circular economy loops**. Let us imagine your transportation company receives this **pickup request**:  The two **AI Agent nodes** connected to **Openroute Service API** will process the information and reply with the **detailed route plan**.  The results include **driving time** and the **optimal sequence** of stops generated by the multi-stop optimization endpoint of the API. ### How does it work? This workflow automates the end-to-end processing of **multi-stop pickup requests for reusable packaging**: - A Gmail trigger listens for collection request emails - AI Agent parses the email into structured data (store ID, address, date) - Each stop is geocoded into GPS coordinates - OpenRouteService **optimizes the stop sequence** using truck-specific routing - A second AI Agent formats a **confirmation email in HTML** with the ordered pickup plan - The reply is sent back with all details including duration and route ### Steps: 1. Trigger on a new Gmail message 2. Extract data using AI Agent (e.g., stores, addresses, times) 3. Store raw and processed data in Google Sheets 4. Enrich with GPS coordinates 5. Optimize route using OpenRouteService (truck profile) 6. Format the confirmation using an AI Agent 7. Send reply to requester with route and timing  ### What do I need to get started? You'll need: - A **Gmail account** to receive collection requests - A **Google Sheet** to store and review data - A free [OpenRouteService API key](https://openrouteservice.org/dev/#/signup) - Access to OpenAI for using AI Agent nodes - Sample pickup request emails to test ### Next Steps - Use the sticky notes inside the n8n canvas to: - Plug in your Gmail and OpenRouteService credentials - Try with a sample store collection email - Validate the confirmation format and route accuracy *This template was built using n8n v1.93.0* *Submitted: June 7, 2025*
n8n$14.99Automate ClickUp Time Tracking Sync to HubSpot Projects
This workflow automates the synchronization of time tracked on ClickUp tasks with HubSpot projects, ensuring accurate and up-to-date project metrics without manual effort.
n8n$9.99Extract Data from Trip Receipts with GPT-4.1-mini, Google Sheets & Email Notifications
# Automated Expense Reporting Workflow With GPT-4.1-mini ## ☀ Who's it for This workflow is designed for employees who need to submit expense claims for business trips. It automates the process of extracting data from receipts/invoices, logging it to a Google Sheet, and notifying the finance team via email. Ideal users: - Employees submitting business trip expense claims - HR or Admins reviewing travel-related reimbursements - Finance teams responsible for processing claims ## ℹ How it works / What it does 1. **Employee submits a form** with trip information (name, department, purpose, dates) and uploads one or more receipts/invoices (PDF). 2. **Uploaded files are saved to Google Drive** for record-keeping. 3. Each PDF is passed to a **DocClaim Assistant agent**, which uses GPT-4.0 and a structured parser to extract structured invoice data. 4. The data is **transformed and formatted** into a standard JSON structure. 5. Two parallel paths are followed: - Invoice records are appended to a **Google Sheet** for centralized tracking. - A detailed **HTML email** summarizing the trip and expenses is generated and sent to the **finance department** for claim processing. ## ✅ How to set up 1. **Create a form** to capture: - Employee Name - Department - Trip Purpose - From Date / To Date - Receipt/Invoice File Upload (multiple PDFs) 2. **Configure file upload node** to store files in a specific Google Drive folder. 3. **Set up DocClaim Agent** using: - GPT-4.0 or any LLM with document analysis capability - Output parser for standardizing extracted receipt data (e.g., vendor, total, tax, date) 4. **Transform extracted data** into a structured claim record (Code Node). 5. **Path 1**: Save records to a Google Sheet (one row per expense). 6. **Path 2**: - Format the employee + claim data into a dynamic **HTML email** - Use `Send Email` node to notify the finance department (e.g., `finance@yourcompany.com`) ## 📋 Requirements - n8n running with access to: - Google Drive API (for file uploads) - Google Sheets API (for logging expenses) - Email node (SMTP or Gmail for sending) - GPT-4.0 or equivalent LLM with document parsing ability - PDF invoices with clear formatting - Shared Google Sheet for claim tracking - Optional: Shared inbox for finance team ## © How to customize the workflow - **Add approval steps**: route the email to a manager before finance - **Attach original PDFs**: include uploaded files in the email as attachments - **Localize for other languages**: adapt form labels, email content, or parser prompts - **Sync to ERP or accounting system**: replace Google Sheet with QuickBooks, Xero, etc. - **Set limits/validation**: enforce max claim per trip or required fields before submission - **Auto-tag expenses**: add categories (e.g., travel, accommodation) for better reporting
n8n$14.99Automate Contact Form Submission On Company Website
This automation starts when a new company is added in HubSpot. It then uses AI to draft a contact message and requests human approval via Slack. Once approved, it runs a task to submit the companys contact form. After an eight-minute delay, it checks if the task is completed and updates the Sales Properties: Lead Status field in HubSpot to Attempted to Contact.
Activepieces$2.99Automate Trello Board Creation from New Zoho Projects Tasklists
Automatically create Trello boards whenever new tasklists are added in Zoho Projects, streamlining project management across platforms.
MakeFreeTransform Old Photos to Animated Videos with FLUX & Kling AI
Automates colorizing and animating vintage photos using FLUX and Kling AI, then posts engaging videos to Facebook, Instagram, YouTube, and X (Twitter). Ideal for content creators and social media managers.
n8n$24.99Automate Grist Row Creation on Confirmation
Automatically create a new row in a Grist table when a row is marked as confirmed in another table, ensuring no duplicate entries.
n8n$4.99Automate Client Email Logging with AI and Google Sheets
Streamline your client communication management by automatically logging emails into Google Sheets. This workflow identifies client names using AI and organizes email data for easy access and analysis.
Activepieces$2.99Automatically Create Trello Cards from New Poptin Leads
Streamline your lead management by automatically creating Trello cards for each new lead generated in Poptin. This workflow ensures that your team can quickly access and act on new leads.
Make$2.99Extract & Enrich LinkedIn Comments to Leads with Apify → Sheets/CSV
Automates scraping LinkedIn post comments via Apify (no login needed), enriches profiles with detailed data, and exports leads to Google Sheets or CSV for easy CRM integration.
n8n$24.99Restore n8n Credentials from Google Drive Backups w/ Dupe Protection
Restores n8n credentials from Google Drive backups with intelligent duplication checks to prevent overwrites. Essential for self-hosted disaster recovery and migrations.
n8n$14.99Create new Colligso TextIn customers from Typeform responses
Every time a new Typeform response is submitted, Make will automatically create a new Colligso TextIn customer.
MakeFreeExtract Driver License Data from Google Drive Uploads to Sheets
Monitors Google Drive for driver license image uploads, extracts key data like name, DOB, and license number using VLM Run AI OCR, then saves to Google Sheets for easy access.
n8n$14.99SEO Content Generator: 2500-Word Posts with Perplexity & Auto-Publish
Automates generation of 2000+ word SEO-optimized blog posts using Perplexity for trends and GPT, then publishes to GitHub every 8 hours. Ideal for consistent content without manual effort.
n8n$24.99
Related categories
Custom AI Systems & Services
Our team of experienced AI builders will help build custom AI systems, workflows, and solutions.
Request Custom Work