You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Martin JahanMJ

Martin Jahan

🚀Expert Excel VBA / Data Scraping / Google Sheet

€280/day
Nantes, FR
3-7 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Martin

Martin, a data engineering graduate, specializes in web scraping, automation, and creating management tools on Excel, Google Sheets, and Google Apps Script.

◉ I regularly intervene... ⤵︎

Scraping | Automation | Data Cleaning

• Scraping | Automation | Data Cleaning
• Extraction of competitor prices from Amazon, Etsy...
• Retrieval and enrichment of leads from directories and professional sites
• Collection of real estate listings from SeLoger, Leboncoin...
• Scraping product images from marketplaces for e-commerce catalogs
• Extraction of customer reviews from Trustpilot, Google Reviews...
• Retrieval of product sheets (references, specs, availability) from B2B sites
• Collection of Instagram hashtags/images (#your_brand) for competitive intelligence
• Bypassing anti-bot protections (Cloudflare, CAPTCHA, rate limiting)
• Use of rotating proxies (4G/fixed IPs) for large volumes
• Automatic cleaning after scraping
• Setting up real-time alerts (low prices, available stock, new items)

Excel | Google Sheets | VBA | Google Apps Script

• VBA macros to automate repetitive tasks (copy-paste, formatting, imports)
• Creation of interactive Excel dashboards (Power Query + Power Pivot)
• Google Apps Script scripts to synchronize Sheets with the Google ecosystem (Sheet, Calendar, Gmail)
• Connection of external APIs to Google Sheets (JSON parsing, automatic imports)
• Custom VBA UserForms (user interface for data entry/consultation)
• Automatic data validation (consistency checks, anomaly alerts)
• PivotTables/VBA for multi-source consolidation (several Excel files)
• VBA protection/hidden sheets for secure business tools
• Looker Studio connected to Google Sheets for real-time BI dashboards

Available 7 days a week via Malt messaging, quotes in < 24 hours after initial contact.
Response in less than an hour
  • French

    Native or bilingual

  • English

    Conversational

Can work on-site
Nantes (up to 50km)

Experience

  • Galliance
    IT Project Manager
    AGRICULTURE
    January 2026 - Today (5 months)
    Ancenis, France

    Project manager for ERP integration


    ERP integration project management (historical data migration, field mapping, acceptance testing)

    Coordination of business/IT teams for purchasing/inventory/production module configuration

    Retrieval, analysis, and cleaning of large data volumes


    Processing 500k+ Excel/VBA/Python lines (suppliers, inventory, production)

    Automated cleaning of duplicates/anomalies → clean ERP databases (saving 20h/week)

    Data Reporting


    Power BI/Excel dashboards connected to ERP (revenue, margins, supplier backlog)

    Automation of management reports (PDF → Outlook, daily sync...)
    Data Scraping VBA Project Management Automation Python Programming
  • Concept 3D
    Founder
    E-COMMERCE
    December 2022 - Today (3 years and 6 months)
    Nantes, France
    Complete automation of e-commerce processes: product cataloging, dynamic pricing, logistics, Etsy/Amazon sales ETL.

    •Development of Python scrapers (Selenium/BeautifulSoup) for 20k+ products/day (Etsy, Amazon, AliExpress): competitor prices, stock levels, logistics costs → intelligent catalog with automatic matching of 3D references.

    •Implementation of a complete ETL pipeline: scraped data → cleaning → optimal price calculation (margin + logistics + competition) → automatic import into Google Sheets + WooCommerce API (90% time saving, 15h → 1h/week).

    •Creation of Excel VBA macros + Google Apps Script for catalog management: product photos, auto-generated SEO descriptions, categories/tagging, synchronization of Etsy/Amazon/Colissimo APIs (live package tracking).

    •Automation of logistics processes: calculation of shipping costs via Colissimo/Chronopost API, stockout alerts, forecasts/replenishment via Python pandas.

    •Construction of live e-commerce dashboards (Power BI + API): revenue by product/category, average order value, conversion rate, logistics ROI, pricing, A/B testing.

    Technical stack: Python scraping (Scrapy/Selenium, BeautifulSoup), Excel VBA, Google Apps Script, e-commerce APIs (Etsy/Amazon/WooCommerce/Colissimo), catalog ETL, Power BI, Google Sheets API.
    Scraping Google Apps Script Google Sheets Python Excel VBA Macro
  • L2C TECHNOLOGIES
    Data Engineer
    DIGITAL AND IT
    September 2022 - December 2025 (3 years and 3 months)
    Design and industrialization of data pipelines for the automation of the company's marketing and BI processes.

    •Developed advanced Excel VBA macros and Google Apps Script to automate the processing of 10,000+ B2B leads/month, reducing qualification time by 75% (10h → 2.5h/week).

    •Implemented REST/JSON API connectors (Google Workspace ↔ internal CRM) for real-time synchronization of acquisition data, generating +4,000 app users via multichannel campaigns.

    •Created dynamic Power Query/Power Pivot dashboards with live KPIs (CAC, LTV, conversion), used by the marketing team to optimize campaign performance on Google/Facebook Ads by +40%.

    •Automated massive data ETL (CSV/XLSX imports via VBA + API), audit and performance optimization of 50+ critical Excel files (performance gain x3).

    •Python Scraping: BeautifulSoup/Selenium for data extraction.
    Excel VBA Macro Google Apps Script Python Pandas Selenium

Recommendations

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Master Data Analyst & Business Intelligence
    Euridis Business School
    2025
    Ce Master forme aux métiers de Data Analyst, Data Engineer et Business Intelligence Consultant, avec focus sur l'automatisation des flux de données en entreprise.

Skill set

Categories