Louis
🚀 Business & tech consultant specialized in No Code automation and AI. I help SMEs, startups, and independents save time and cut costs with scalable workflows in n8n and other tools. Passionate about making automation simple, useful, and human-centered. 👉 Also sharing automation insights on YouTube Find all my links here : https://linktr.ee/cashflows.routine And my AI Agency here : https://agence-alain.fr
Templates by Louis
📂 Automatically update stock portfolio from OneDrive to Excel
Seamlessly Sync and Update Data from a csv in OneDrive to Excel with n8n This workflow is perfect for users who need a reliable, automated way to transfer and organize data from OneDrive into Excel—especially for tasks like portfolio tracking, inventory management, and record-keeping. By monitoring your OneDrive folder for new CSV files, it performs data cleaning, transformation, and real-time updates in an Excel sheet, ensuring only new or changed records are added. --- How it Works Automated Monitoring: Every minute, the workflow scans a designated OneDrive folder for new files. File Verification: It checks if the detected file is in CSV format; if not, the process stops with an error message. Data Extraction and Cleaning: CSV data is loaded, and irrelevant headers are removed before mapping to specified columns in Excel. Excel Update: The workflow maps data to your Excel sheet, updating only new or modified entries based on a unique identifier ("Ticker/ISIN"). Cleanup: To keep your OneDrive organized, processed files are deleted after updating Excel. --- Setup Steps Connect OneDrive and Excel Accounts: Link your Microsoft OneDrive and Excel accounts in n8n. Designate Folder and Worksheet: Specify the OneDrive folder for monitoring and the Excel sheet for data updates. Configure Sync Frequency and CSV Validation: Set the monitoring frequency to every minute and ensure the workflow identifies CSV files accurately. Once configured, this workflow offers a hands-free, efficient solution to keep your OneDrive and Excel data synchronized effortlessly.
By Louis🎵 Sync YouTube and Spotify music playlists
Workflow Overview This workflow automates the process of updating a Spotify playlist with tracks from a YouTube playlist, ensuring no duplicates are added. Key Components Manual Trigger: Starts the workflow when you click ‘Test workflow’. Spotify Integration: Retrieves tracks from a specified Spotify playlist. YouTube Integration: Fetches tracks from a designated YouTube playlist. Batch Processing: Processes tracks in batches to handle multiple items efficiently. Track Search: Searches for YouTube tracks on Spotify to find corresponding IDs. Comparison: Compares existing Spotify tracks with YouTube tracks to identify which ones to add. Track Addition: Adds new Spotify tracks to the playlist that are not already included. If you have any questions or need clarification, feel free to ask!
By LouisFetch live ETF metrics from JustETF to Excel with one-click updates
Automate Your ETF Comparison: Real-Time Data & Analysis Automate ETF research in Excel with one click. This n8n workflow pulls live data from justetf.com using ISIN codes from your Excel table, extracts key metrics (dividends, fees, 5-year performance), and updates your “Div study” sheet instantly — all triggered by a button in Excel. Perfect for dividend investors, ETF screeners, or portfolio trackers who want fresh, accurate data without manual copy-paste. --- How it works Trigger: Click “Update Table” in Excel → calls n8n via webhook Excel: Logs current time (GMT-2) and reads all rows from “DivComp” table HTTP Request: Fetches ETF profile page from justetf.com using ISIN HTML Extraction: Parses page with CSS selectors to grab dividends, fees, 5Y performance Code Node: Cleans & structures data (e.g., last 5 years of dividends, yield, growth) Update Excel: Writes clean values back to your table (fees, yield, performance, name) --- Setup steps In Excel: Add a button → assign macro that calls your n8n webhook URL (path: /ETF) Ensure table “DivComp” has: ISIN, Dernière mise à jour, Frais, Performance depuis 5 ans, etc. In n8n: Connect Microsoft Excel (OneDrive) credential Update workbook/worksheet/table references if needed Test with 1–2 ISINs first Click “Update Table” → watch data refresh in real time! --- Tags: ETF, Excel, Web Scraping, Investing, Finance, Automation, justetf, Dividend Tracking
By Louis📑 Anonymize & reformat CVs with Gemini AI, Google Sheets & Apps Script
🧾 CV Anonymization & Reformatting Automation An advanced N8N workflow to anonymize and reformat resumes for internal or external distribution 🔍 Overview This template automates the anonymization, structuring, and reformatting of CVs/resumes using a combination of AI, PDF parsing, and Google Apps Script. It’s ideal for companies or teams that need to showcase their workforce—while ensuring candidate privacy and presenting the information in a standardized format. 👥 Who it's for HR departments Consulting agencies Project managers needing anonymized candidate profiles Any enterprise team required to share CVs in a consistent, brand-compliant, and privacy-conscious way ⚙️ What it does Watches a Folder for new PDFs (CVs) Extracts Content from the PDF 2.Uses Gemini Flash 2.0 to intelligently structure the resume content Stores the structured data in a Google Sheet Generates a New CV from a customizable template via Google Apps Script Anonymizes Names (e.g. “John Doe” → “J. D.”) (Optional) Sends or downloads the final anonymized version 🛠️ Setup Requirements To use this workflow, you’ll need to configure: Your input/output folders Field mappings (e.g. what to extract) A Google Apps Script endpoint for PDF generation A Google Sheet acting as your structured data database A Gemini API key and access (or any other LLM) 💡 Templates are customizable: you can define your own layout as long as the placeholders match your database field names. ✨ Customization Ideas Automatically email the anonymized CV to a recipient Use conditional logic to switch templates (e.g. for different roles or departments) Add a second formatting layer for internal vs external audiences
By LouisLatest tailored economic news for business 🌍💼✨
📬 What this workflow does Every morning → fetch 3 French economy RSS feeds → keep fresh items → AI rewrites into short summaries → send a nice HTML email newsletter. --- 🔄 Flow (high level) ⏰ Trigger at 07:00 📰 Fetch RSS (Le Monde, Usine Nouvelle, Le Figaro) ⛔ Filter → keep only recent items 🔢 Sort newest first ✂️ Limit 2 per source ➕ Merge 🤖 AI summary (title + paragraph) 🏷 Normalize fields (title, source, link…) 📦 Aggregate arrays 📧 Send via Outlook (HTML template) --- 🧩 Node notes Trigger → 07:00 daily (check timezone). RSS Read → feeds OK, but UsineNouvelle is http (redirects fine). If nodes → ❗ currently after $today → keeps only future dates. Fix: For today only: after $today.startOf('day') For last 24h: after $now.minus({ hours: 24 }) Sort + Limit → newest 2 per feed. Merge → combine up to 6 items. AI agent → prompt uses <article> … needs closing </article> ✅ Edit Fields → maps source domains → nice labels (“Le Monde” etc). Aggregate → arrays for email template. Outlook email → HTML newsletter (mobile-friendly). --- ⚡ Quick wins 🕒 Fix the date filter logic (today/24h). 📝 Fix closing tag in AI prompt (</article>). 🌍 Add User-Agent header in RSS nodes (avoid 403). 🔁 Remove duplicates on link. ⏳ Mind the server timezone vs your audience. ---
By LouisAutomated job scraping with SerpAPI, Gemini AI filter & email notifications
🛜 Daily Notification on Specific Latest Job Offers 🛜 🌟 Overview: Never miss a job offer again! This n8n workflow automates daily job scraping from LinkedIn, Indeed, Welcome to the Jungle, and more, using Google Dorks and SerpAPI. It filters offers with a Gemini AI agent, stores them in Google Sheets, and sends a sleek HTML newsletter to your inbox or subscribers—all manageable from your phone! 💼 Use Cases: Students hunting for M&A, valuation, or transaction services internships (6+ months). Career switchers seeking automated, curated job alerts. Content creators building a job newsletter to monetize their audience. ⚙️ How It Works: Scrape: Uses SerpAPI with a tailored Google Dork to fetch fresh job listings daily from top platforms. Filter: A Gemini AI agent validates offers to ensure they match corporate finance criteria. Store: Saves new offers in Google Sheets, marking duplicates to avoid spam. Notify: Generates an email/newsletter notification and sends it via Outlook 🛠️ Setup Instructions: Import the JSON workflow into n8n. Add credentials: SerpAPI (API key), Google Sheets (OAuth2), Microsoft Outlook (OAuth2) Customize the Google Dork in the "Edit Fields" node for specific job criteria. Schedule to run daily at 7 AM. Test and tweak the AI prompt for precision. 🔑 Required Credentials & Nodes: Credentials: SerpAPI, Google Sheets OAuth2, Microsoft Outlook OAuth2 Nodes: Schedule Trigger, HTTP Request, Google Sheets, AI Agent (Gemini), Microsoft Outlook 🔗 Creator: Louis Delahaye | n8n.io/creators/louisdl 🎥 YouTube @cash-routine My AI Agency : https://agence-alain.fr
By Louis🔥 X & Reddit tech trend analysis with Gemini AI for Notion & Telegram
🔥 X & Reddit Trending Topics Finder 📝 Overview This n8n workflow helps YouTubers like @cash-routine 🚀 find trending AI, n8n, and automation topics on X and Reddit. It runs daily at 8 AM, using AI to spot hot discussions, debates, and monetization ideas 💰. Results are sent to Telegram 📩 and saved in Notion 📚, perfect for creating viral videos or paid services that blend value with trending buzz. Benefits: 🕒 Daily trend alerts 🤖 AI-driven insights with quotes & opportunities 📲 Telegram + Notion outputs 💸 Video ideas + business levers 🎯 Use Cases YouTubers: Create videos like "Build a Micro-SaaS with n8n" 📹 Marketers: Sell lead-gen automations 💼 Analysts: Track AI debates for content ideas 🧠 ⚙️ How It Works ⏰ Trigger: Runs daily at 8 AM. ✍️ Prompt: Sets AI focus on AI/n8n trends. 🌐 Data: Fetches top 10 posts from r/n8n, r/Automate, r/OpenAI, r/grok + X "Automation" tweets. 🤖 AI Analysis: Gemini Pro finds 5 trends with: 📈 Trend summary 💬 Debate/quote 💰 Video + monetization ideas 📋 Output: JSON-structured results. 📤 Delivery: Markdown chunks to Telegram (<4096 chars) + Notion page with random emoji. 🛠️ Setup 📥 Import JSON into n8n. 🔑 Add credentials: Reddit OAuth2 X OAuth2 Google Gemini API (Pro + Flash) Telegram API Notion API (parent page: Notion URL) ⚙️ Customize: Adjust trigger time Edit prompt for new subreddits/keywords Update Notion page ID ✅ Test & activate. 🔗 Nodes & Credentials Nodes: Schedule Trigger, Set, AI Agent, Reddit Tool (x4), Twitter Tool, Structured Output Parser, Code (x2), Telegram, Notion (x2) Credentials: Reddit, X, Gemini, Telegram, Notion 🚀 Enhancements Add Slack/email alerts 📧 Expand sources (e.g., Discord) 🌐 Sell as a premium setup on @cash-routine for $49 💸 Note: Not free! Optimized for n8n cloud/self-hosted. Runtime: ~1-2 min. Check n8n forums for support. 🛠️
By Louis