Skip to content
FREN
← All work

AutomationNo. 04

Objectif Bachata

n8n automations for a dance association: sign-up lists, importing members into Brevo and fact sheets for guest artists

n8n · HelloAsso · Google Sheets · Google Docs · Brevo · Automation

The two n8n flows for the artist sheets: watch the three forms, then create the sheet

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

  1. 01

    Duplicates

    “Stéphane” and “Stephane”: one and the same person

  2. 02

    Couples

    the partner counts too

  3. 03

    Members

    matched by email or by name

  4. 04

    Tickets

    the party ticket and the workshop option kept apart

n8n workflow “Workshop list · workshop and party”
n8n workflow “Import new members into Brevo”

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

  1. 01

    The event

    you pick the session

  2. 02

    The template

    copied into the Drive folder

  3. 03

    HelloAsso

    members and tickets

  4. 04

    The script

    duplicates, couples, members

  5. 05

    The sorting

    workshop on one side, party on the other

  6. 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

  1. 01

    The schedule

    starts automatically

  2. 02

    The spreadsheet

    the session’s sign-ups

  3. 03

    Brevo

    does the email already exist?

  4. 04

    New contacts

    logged in a spreadsheet

  5. 05

    The import

    added to the mailing list

  6. 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

  1. 01

    The answers

    French, Spanish, English

  2. 02

    The watch

    every 5 min, and every morning

  3. 03

    The language

    the right template, the right fields

  4. 04

    Duplicates

    sheet already done? skip it

  5. 05

    The sheet

    template copied then filled in

  6. 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

Let’s book 30 min

We’ll go over your project, no strings attached.

shall we talk?