PROJECT / AUTOMATION / 2026

Nissan × Continente

I built an Excel and Google Apps Script solution for loading cards in a commercial campaign. The team now uses it every day.

CONTEXTNissan Portugal
YEAR2026
CONTRIBUTIONDeveloping the solution
TOOLSExcel and Google Apps Script
DELIVERABLEWorkflow supporting the process

01 / CONTEXT

A repetitive process needed to be simpler.

Within the Nissan × Continente partnership, loading customers' cards had problems: duplicate records, emails with important information that took too long to arrive, and cards that took too long to be loaded.

02 / SOLUTION

Excel to organise. Apps Script to execute.

BEFORE
  • Duplicate records
  • Delayed emails with important information
  • Cards slow to load
  1. INPUTLoading requests

    Campaign customers' cards.

  2. 01 / DATA · EXCELSpreadsheet

    I structured the necessary information in one place.

  3. 02 / ROUTINE · APPS SCRIPTAutomated tasks

    I programmed the repetitive tasks.

  4. 03 / CONTROL · TEAMMonitoring

    An accessible process that can be supervised.

  5. OUTPUTCard loaded

    No duplicates.

AFTER
  • Used every day by the team
  • 0% error rate
  • Information no longer depends on emails
Simplified diagram of the solution. It does not include campaign data.

03 / RESULT

Used every day. 0% error rate.

The team started using the solution daily. Duplicates stopped happening, information no longer depended on delayed emails, and card loading reached a 0% error rate. I present the logic of the solution without exposing campaign data.

ISSUE
NEXT PROJECT / CONTENTAfter-Sales Newsletter.