Dennis M.

👉 Client Problem:

The sales team had an inefficient manual prospecting process with a very low response rate:

Sending generic emails → <3% response rate

Average time per personalized video: 20 minutes (writing, recording, sending)

Goal not met of 5 videos/day/person → 70% of leads not processed

No system to adapt the message to the target website or automatically capture video previews

👉 Solution:

Deployment of an automated n8n workflow that generates and sends ultra-personalized prospecting videos from a simple Airtable link containing the target website URL.

Technical achievements:

• Intelligent summary of website content with Claude AI → Savings: -100% of prior manual research

• Video script automatically generated by AI according to commercial guidelines → Savings: 20 minutes saved per video

• Dynamic creation of a video scroll-shot of the target site (via ScreenshotOne API) → Savings: +80% visual engagement

• Voice generation via ElevenLabs + integration into a personalized animated video (Creatomate) → Savings: 100% automated process, 1 click = 1 ready video

• Automatic sending of a stylized email with CTA to Calendly, professional signature, and integrated tracking → Savings: +65% open rate, +28% click rate

🎯 Overall Impact:

ROI: 580% in 3 months | Time saved: 40h/month | Savings: €12,000/year

👉 Client Problem:

The quote creation process for moving requests was entirely manual, time-consuming, and prone to errors:

An average of 35 minutes per quote was required (data entry, calculations, formatting, sending)

Over 150 quotes/month generated an estimated human cost of +85 hours monthly

Calculation errors (time, cost, distance estimates) occurred in 15% of cases, leading to costly adjustments or lost sales

No structured follow-up or quote history was centralized, hindering sales follow-up and analysis

👉 Solution:

Implementation of a 100% automated quote generator via n8n, connected to Google Maps, Google Docs, Sheets, Gmail APIs, and a GPT-4o AI model for intelligent interpretation of client requests.

Technical achievements:

• Intelligent parsing of forms via webhook + GPT to format client requests → Savings: -100% data entry errors

• Google Maps integration for automatic calculation of distance + travel costs → Savings: 10 min/quote, +12h/month

• Generative AI (LangChain + OpenAI) to extract, calculate, and structure a quote JSON from natural language messages → Savings: -85% of manual processing time

• Automatic PDF quote generation on Google Docs from a dynamic template → Savings: -90% writing time

• Automatic sending of quotes by email + structured saving in Google Sheets → Savings: +100% traceability & easier follow-up

• Validation and intelligent recalculation of amounts with encapsulated business logic (floor/access adjustments, time per item, labor threshold) → Savings: -100% pricing errors

🎯 Overall Impact:

ROI: 430% in 6 months | Time saved: 75 hours/month | Savings: €18,000/year

👉 Client Problem:

Viehe Industrie Solutions, a B2B supplier in the automotive, artisanal, and industrial sectors, faced manual and inefficient management of its sales routes. Sales representatives spent an average of 15 hours per week planning visits via Excel, with unbalanced geographic coverage and inconsistent daily visit rates (from 5 to 25 clients). This inaccuracy led to decreased field performance, a 35% non-visit rate on priority clients, and an estimated annual revenue loss of up to €12,000 due to poor prioritization.

👉 Solution:

We designed a custom n8n workflow connecting Google Sheets, Google Maps API, and an intelligent geographic clustering and distribution engine to automate monthly route planning based on zones, client revenue, and geographic proximity.

Technical achievements:

• Dynamic connection to Google Sheets for reading client data → Savings: 100% automation / 780h saved/year

• Filtering of authorized postal codes and Google Maps geocoding of addresses → Savings: 90% reduction in address errors / +8h/week

• Clustering into 20 zones + priority calculations based on client revenue & visit frequency → Savings: +40% field coverage / 260% ROI in 6 months

• Balanced planning of visits per week and day (15 visits max/day spread over 4 weeks) → Savings: Optimized travel time, -35% distance traveled

• Automatic writing into 4 weekly Google Sheets → Savings: Complete elimination of manual exports / +320h/year freed up for the sales team

🎯 Overall Impact:

ROI: 260% in 6 months | Time saved: 65h/month | Savings: €18,500/year