Gabriel Santos
Workflows by Gabriel Santos
Route equipment requests to Procurement with manager approval via Gmail
This workflow streamlines how employees request **equipment/items** and how those requests reach the **Procurement** team. It validates the employee by enrollment number, detects whether a **manager** exists, and then either requests approval (if the requester has a manager) or routes the request **directly to Procurement** (if the requester is a manager). All messages are written in a professional tone using an LLM, and emails are sent via Gmail with a built-in **approve/deny** step for managers. ## Who’s it for HR/IT/Operations teams that handle equipment requests, need a lightweight approval flow, and want clean, professional emails without manual drafting. ## How it works 1. Employee submits their **enrollment number**. 2. Workflow fetches employee (and manager, if any). 3. Employee describes the requested item(s). 4. If a manager exists → an **approval email** (double opt-in) is sent to the manager. * Approved → notify employee and forward a polished request to **Procurement**. * Denied → notify employee. 5. If the requester is a **manager** → skip approval and send directly to **Procurement**. 6. End pages confirm the outcome. ## Requirements * MySQL (or compatible DB) with an `employees` table (`id, name, email, enrollment_number, manager`). * Gmail credentials (OAuth) in n8n. * LLM provider (OpenAI or compatible) for message polishing. ## How to customize * Replace the Procurement **NoOp** nodes with your email, helpdesk, or ERP integration. * Adjust email copy and tone in the LLM prompt nodes. * Add tracking IDs, SLA text, or CCs for auditing. * Style the forms with your brand (CSS blocks provided).
Automate HR Q&A sessions with AI question clustering and Google Calendar integration
This workflow helps HR teams run smoother **monthly Q\&A sessions** with employees. * **Who’s it for** HR teams and managers who want to centralize employee questions, avoid duplicates, and keep meetings focused. * **How it works** 1. Employees submit questions through a styled form. 2. Questions are stored in a database. 3. HR selects a date range to review collected questions. 4. An AI Agent deduplicates and clusters similar questions, then generates a **meeting script** in Markdown format. 5. The Agent automatically creates a **Google Calendar event** (with a Google Meet link) on the **last Friday of the current month at 16:00–17:00**. 6. The script is returned as a downloadable `.txt` file for HR to guide the session. * **Requirements** * MySQL (or compatible DB) for storing questions * Google Calendar credentials * OpenAI (or another supported LLM provider) * **How to customize** * Adjust meeting day/time in the `Set` node expressions * Change database/table name in MySQL nodes * Modify clustering logic in the AI Agent prompt * Replace the form styling with your company’s branding This template ensures **no repeated questions**, keeps HR **better prepared with a structured script**, and **automates meeting scheduling** in just one click.
Extract meeting tasks from transcripts with AI and sync to Trello
## Who’s it for Teams and project managers who want to turn meeting transcripts into actionable Trello tasks automatically, without worrying about duplicate cards. ## What it does This workflow receives a transcript file in `.txt` format and processes it with AI to extract clear, concise tasks. Each task includes a short title, a description, an assignee (if mentioned), and a deadline (if available). The workflow then checks Trello for duplicates across **all lists**, comparing both card titles (`name`) and descriptions (`desc`). If a matching card already exists, the workflow returns the existing Trello card ID. If not, it creates a new card in the predefined default list. Finally, the workflow generates a **user-friendly summary**: how many tasks were found, how many already existed, how many new cards were created, and how many tasks had no assignee or deadline. ## Requirements - A Trello account with API credentials configured in n8n (no hardcoded keys). - An OpenAI (or compatible) LLM account connected in n8n. ## How to customize - Adjust similarity thresholds for title/description matching in the Trello Sub-Agent. - Modify the summary text to always return in your preferred language. - Extend the Trello card creation step with labels, members, or due dates.