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

Joao Fernandes Lopes

Expert Google Apps Script | Automation & AI

€400/day
1 project
Bordeaux, FR
3-7 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Joao

Are you spending too much time on repetitive tasks in Google Sheets, Gmail, or Drive? I automate them cleanly, sustainably, without disrupting your organization.

Graduated engineer (Master's degree, highest honors), I design tailor-made solutions within your existing environment. I use what you already have, with no new tools to learn.

WHAT I DO
Google Workspace automation with interconnected Sheets, Gmail, Drive, Calendar, Forms, eliminating manual tasks.

Multi-tool integrations with n8n, Make, Zapier, REST APIs, webhooks, and AI model integration (OpenAI, Claude, Gemini).
Interfaces & back-office with forms, dashboards, online booking, automatic PDF generation, and regulatory documents. AppSheet and Notion for maintainable no-code.

Data & visualization with Airtable, Looker Studio, advanced Sheets. Your data structured, readable, actionable.

Invoicing & compliance with support for the 2026 electronic invoicing transition, selection and setup of certified platforms, and automation of invoicing flows with Google Workspace.

ACHIEVEMENTS
CEFTI (Qualiopi certified organization) — Complete CPF certification management system: online booking, automatic confirmations, generation of PDF invitations and diplomas, event-triggered email sending, automated attendance sheets, export to Google Calendar. Several hundred trainees managed automatically.

Form'Annonce (formannonce.fr) — B2B SaaS founded and deployed alone. Platform connecting training organizations and independent trainers. 80+ users in less than a month.

TECHNICAL ENVIRONMENT
Google Workspace: Apps Script, Sheets, Gmail API, Calendar API, Drive API, Forms, Looker Studio
Automation: n8n, Make, Zapier, REST API, Webhooks, OpenAI API, AppSheet, Airtable, Notion API
Web: HTML5, CSS3, JavaScript, Firebase
Data: Python, Pandas, Excel/VBA, ETL
  • English

    Native or bilingual

  • Portuguese

    Native or bilingual

  • French

    Native or bilingual

  • Spanish

    Conversational

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

Experience

  • AD SPACE SOLUTIONS
    Malt logoOn Malt
    Training and consulting - Getting started with Front/Zapier and multi-Gmail account management
    HEALTH AND WELLNESS
    April 2026 - April 2026
    Training and consulting: Multi-Gmail account management with Front and Zapier
    Assisted a professional managing 50 client Gmail accounts in setting up a centralized and automated communication architecture.

    The session covered getting started with Front as a shared inbox, connecting and organizing multiple Gmail accounts within a unified interface, creating native automation rules (automatic tagging, assignment, priority management), using internal comments to contextualize exchanges without the client seeing them, and best practices for managing statuses (Open, Snoozed, Archived) to ensure no conversation is left unaddressed.

    Regarding Zapier, presented the Trigger/Action logic applied to this use case: detecting incoming emails with specific criteria, triggering automatic actions in Front or towards third-party tools (notifications, task creation, archiving).

    Recommendations were also made on choosing the appropriate Front plan for the number of accounts, alternatives to consider based on evolving needs (Missive for a reduced budget), and priority setup steps for quick and effective adoption.
    Zapier Front Automation Consulting
  • I2M
    R&D Internship
    RESEARCH
    April 2025 - September 2025 (5 months)
    33400 Talence, France
    Developed an electronic component identification algorithm achieving 91% accuracy across 8 distinct component types (including cables). Trained on a custom-built dataset and integrated with a robotic arm, the system leveraged Industry 4.0 technologies (X-RAY, LiDAR, IR) to drive circular economy automation within a robotic disassembly cell.
    Process Automation Artificial Intelligence Robotics R&D Python
  • LibNGo
    Web Developer
    MEDICAL
    June 2022 - July 2022 (1 month)
    33400 Talence, France
    Contributed to the development of the official company website by creating 12 new pages and migrating the application to a new framework (Svelte to React). Also helped building some of the pages working with the graphic designer, and improved client relations when interaction with the various medical workers.
    Web App Development Front-End Development React.js

Reviews

5.0

Out of 1 rating

A

Ad

FRONT - AD SPACE SOLUTIONS

Reviewed on 4/16/2026

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

  • MSc in Computer Science / Computer Science Master's Degree
    University Of Bordeaux
    2025
    Specialized in Autonomous Systems, Robotics and Drones

Skill set

Categories