
01The context
Objectif Bachata runs bachata workshops and parties, with guest artists. The association did everything by hand: the sign-up lists for each session, adding members to the mailing list, the artist sheets. A single list took 30 to 45 minutes
The challenge
Accurate lists for every session, without spending the whole evening on them
02The approach
I started from the HelloAsso tickets and the cases that caused trouble. Then I built one automation per task. For the lists, the script handles four cases
- 01
Duplicates
“Stéphane” and “Stephane”: one and the same person
- 02
Couples
the partner counts too
- 03
Members
matched by email or by name
- 04
Tickets
the party ticket and the workshop option kept apart


03The system
First automation: the sign-up lists. You pick the event. n8n copies the spreadsheet template into the session folder, then reads the members and the tickets on HelloAsso. The script sorts the attendees and fills two tabs: Workshop and Party
- 01
The event
you pick the session
- 02
The template
copied into the Drive folder
- 03
HelloAsso
members and tickets
- 04
The script
duplicates, couples, members
- 05
The sorting
workshop on one side, party on the other
- 06
The spreadsheet
two tabs filled in
Second automation: the Brevo import. It runs on its own, at regular intervals. It reads the sign-up spreadsheet and checks whether each email already exists in Brevo. New ones are logged, then added to the mailing list with their first name, three at a time, with a pause to stay within Brevo’s limits
- 01
The schedule
starts automatically
- 02
The spreadsheet
the session’s sign-ups
- 03
Brevo
does the email already exist?
- 04
New contacts
logged in a spreadsheet
- 05
The import
added to the mailing list
- 06
In batches
three contacts, then a pause
Third automation: the artist sheets. Guest artists fill in a form, in French, Spanish or English: accommodation, meals, allergies, music, style taught. Two flows work together. The first one watches the three forms. The second creates the sheet in Google Docs, from the template in the right language. Every morning, a catch-up run rereads the month’s answers, without creating duplicates. And if a sheet fails, the empty copy gets deleted
- 01
The answers
French, Spanish, English
- 02
The watch
every 5 min, and every morning
- 03
The language
the right template, the right fields
- 04
Duplicates
sheet already done? skip it
- 05
The sheet
template copied then filled in
- 06
Tracking
the answer is marked as processed
04The result
A list that took 30 to 45 minutes now takes 3. It’s accurate and sorted by name. New members land in Brevo on their own. Every artist has a sheet, whatever their language
- 3 min
- instead of 30 to 45 per list
- 2 lists
- workshop and party, for every session
- 3
- automations: sign-ups, Brevo, artists