Juan Sanchez
Experienced cloud solutions professional with a strong focus on Microsoft technologies, including Microsoft 365, Azure, Entra, and the Power Platform. Skilled in designing and implementing automation using Power Automate and PowerShell. Proven track record in sales, marketing, and delivering managed services for cloud environments. Passionate about digital transformation, AI integration, and streamlining business processes through low-code platforms.
Templates by Juan Sanchez
Extract and organize Colombian invoices with Gmail, GPT-4o & Google Workspace
🧾 Personal Invoice Processor This N8N workflow automates the extraction and organization of personal invoices in Colombia received via Gmail. It includes the following key steps: 🔁 Flow Summary Email Trigger Polls Gmail every 30 minutes for emails with .zip attachments (assumed to contain invoices). Expects ZIP file following DIAN standards. ZIP File Handling Extracts all files. Filters only PDF and XML files for processing. Data Extraction & Processing Uses LangChain Agent + OpenAI (GPT-4o-mini) to extract: Tipo de documento (Factura / Nota Crédito) Número de factura Fecha de emisión (YYYY-MM-DD) NIT emisor y receptor (sin dígito de verificación) Razón social del emisor Subtotal, IVA, Total CUFE Resumen de compra (max 20 words, formatted sentence) Validation Ensures Total = Subtotal + IVA using a calculator node. Storage Uploads the original PDF to Google Drive. Renames the file to: YYYY-MM-DD-NUMERO_FACTURA.pdf. Inserts or updates invoice details in Google Sheets using a unique Key (NITEmisor + NumeroFactura) to prevent duplication. --- > ⚙️ Designed for personal use with minimal latency tolerance and high automation reliability.
By Juan SanchezGet Colombian peso to USD exchange rate with Telegram bot and AI date recognition
📌 Request TRM (Colombian Peso to US Dollar exchange rate) 🎯 Objective Retrieve the TRM (Colombian Peso to US Dollar exchange rate) for a specific date provided by the user via Telegram. 🔄 Summary Flow 📨 Telegram Message The user sends a text or audio message to the Telegram Bot. 🧠 Date Extraction AI (OpenAI) is used to identify the date in YYYY-MM-DD format. 📅 Validation If the date is in the future, the user is notified that it is not valid. 📡 TRM Query The bot queries the open data API from the Colombian government. 📥 Result ✅ If TRM data exists for that date → The bot replies to the user. ❌ If not → It searches up to 10 previous days for available data. 📤 Final Response The most recent available value is sent, or a message indicating no information is available. 🔗 Data Source datos.gov.co – TRM
By Juan Sanchez