{"name":"PSN Devis Lead → Brevo + Sheets + Email [CORRIGÉ]","flow":[{"id":1,"module":"gateway:CustomWebHook","version":1,"parameters":{"hook":2571793,"maxResults":1},"mapper":{},"metadata":{"designer":{"x":0,"y":0},"restore":{"parameters":{"hook":{"label":"PSN Devis Lead","data":{"editable":"true"}}}},"parameters":[{"name":"hook","type":"hook:gateway-webhook","label":"Webhook","required":true},{"name":"maxResults","type":"number","label":"Maximum number of results"}]}},{"id":3,"module":"sendinblue:UpsertContactV2","version":2,"parameters":{"__IMTCONN__":5581041},"mapper":{"email":"{{1.email}}","attributes":[{"name":"PRENOM","value":"{{1.firstName}}"},{"name":"NOM","value":"{{1.lastName}}"},{"name":"SMS","value":"{{1.phone}}"},{"name":"TYPE_SERVICE","value":"{{1.service}}"},{"name":"LOCALISATION","value":"{{1.location}}"},{"name":"SURFACE","value":"{{1.surface}}"},{"name":"FREQUENCE","value":"{{1.frequency}}"},{"name":"SOURCE","value":"Formulaire site Web"},{"name":"DATE_CONTACT","value":"{{formatDate(now; \"DD/MM/YYYY\")}}"}],"listIds":["8"],"unlinkListIds":[],"updateEnabled":true},"metadata":{"designer":{"x":300,"y":0},"restore":{"parameters":{"__IMTCONN__":{"label":"PURE SPACE NETT Brevo","data":{"scoped":"true","connection":"sendinblue2"}}},"expect":{"attributes":{"mode":"chose","items":[null,null,null,null,null,null,null,null,null]},"listIds":{"mode":"chose","items":[null]},"unlinkListIds":{"mode":"chose"},"updateEnabled":{"label":"Yes"}}},"parameters":[{"name":"__IMTCONN__","type":"account:sendinblue2","label":"Connection","required":true}],"expect":[{"name":"email","type":"email","label":"Email","required":true},{"name":"attributes","type":"array","label":"Attributes","spec":[{"name":"name","type":"text","label":"Attribute Name","required":true},{"name":"value","type":"text","label":"Attribute Value","required":true}]},{"name":"listIds","type":"array","label":"Add to Lists","spec":{"type":"select","name":"value","label":"List ID"}},{"name":"unlinkListIds","type":"array","label":"Remove from Lists","spec":{"type":"select","name":"value","label":"List ID"}},{"name":"updateEnabled","type":"boolean","label":"Update existing contact","required":true}]}},{"id":4,"module":"google-sheets:addRow","version":2,"parameters":{"__IMTCONN__":5581137},"mapper":{"mode":"fromAll","insertUnformatted":false,"valueInputOption":"USER_ENTERED","insertDataOption":"INSERT_ROWS","spreadsheetId":"1sT9p_Fhp6tiYdTDCBoHl490QUzSDOXVY0OuWFbfm1Fs","sheetId":"devis","includesHeaders":true,"useColumnHeaders":true,"values":{"Date et heure":"{{formatDate(now; \"DD/MM/YYYY HH:mm\")}}","Nom":"{{1.lastName}}","Prénom":"{{1.firstName}}","Email":"{{1.email}}","Téléphone":"{{1.phone}}","Service":"{{1.service}}","Type de lieu":"{{1.placeType}}","Localisation":"{{1.location}}","Surface (m²)":"{{1.surface}}","Fréquence ":"{{1.frequency}}","Détails":"{{1.details}}"}},"metadata":{"designer":{"x":600,"y":0},"restore":{"parameters":{"__IMTCONN__":{"label":"My Google connection (contact@purespacenett.com)","data":{"scoped":"true","connection":"google"}}},"expect":{"mode":{"label":"Select from all"},"insertUnformatted":{"mode":"chose"},"valueInputOption":{"mode":"chose","label":"User entered"},"insertDataOption":{"mode":"chose","label":"Insert rows"},"sheetId":{"mode":"edit"},"includesHeaders":{"label":"Yes"},"useColumnHeaders":{"nested":[{"name":"values","label":"Values in columns","type":"collection","spec":[{"name":"Date et heure","label":"Date et heure (A)","type":"text"},{"name":"Nom","label":"Nom (B)","type":"text"},{"name":"Prénom","label":"Prénom (C)","type":"text"},{"name":"Email","label":"Email (D)","type":"text"},{"name":"Téléphone","label":"Téléphone (E)","type":"text"},{"name":"Service","label":"Service (F)","type":"text"},{"name":"Type de lieu","label":"Type de lieu (G)","type":"text"},{"name":"Localisation","label":"Localisation (H)","type":"text"},{"name":"Surface (m²)","label":"Surface (m²) (I)","type":"text"},{"name":"Fréquence ","label":"Fréquence  (J)","type":"text"},{"name":"Détails","label":"Détails (K)","type":"text"}],"metadata":[[["Date et heure","Nom","Prénom","Email","Téléphone","Service","Type de lieu","Localisation","Surface (m²)","Fréquence ","Détails"]]]}],"label":"Yes"}}},"parameters":[{"name":"__IMTCONN__","type":"account:google","label":"Connection","required":true}],"expect":[{"name":"mode","type":"select","label":"Search Method","required":true,"validate":{"enum":["select","fromAll","map"]}},{"name":"insertUnformatted","type":"boolean","label":"Unformatted","required":true},{"name":"valueInputOption","type":"select","label":"Value input option","validate":{"enum":["USER_ENTERED","RAW"]}},{"name":"insertDataOption","type":"select","label":"Insert data option","validate":{"enum":["INSERT_ROWS","OVERWRITE"]}},{"name":"spreadsheetId","type":"text","label":"Spreadsheet ID","required":true},{"name":"sheetId","type":"select","label":"Sheet Name","required":true},{"name":"includesHeaders","type":"select","label":"Table contains headers","required":true,"validate":{"enum":[true,false]}},{"name":"useColumnHeaders","type":"select","label":"Use column headers as IDs of the columns","required":true,"validate":{"enum":[true,false]}},{"name":"values","type":"collection","label":"Values in columns","metadata":[[["Date et heure","Nom","Prénom","Email","Téléphone","Service","Type de lieu","Localisation","Surface (m²)","Fréquence ","Détails"]]],"spec":[{"name":"Date et heure","type":"text","label":"Date et heure (A)"},{"name":"Nom","type":"text","label":"Nom (B)"},{"name":"Prénom","type":"text","label":"Prénom (C)"},{"name":"Email","type":"text","label":"Email (D)"},{"name":"Téléphone","type":"text","label":"Téléphone (E)"},{"name":"Service","type":"text","label":"Service (F)"},{"name":"Type de lieu","type":"text","label":"Type de lieu (G)"},{"name":"Localisation","type":"text","label":"Localisation (H)"},{"name":"Surface (m²)","type":"text","label":"Surface (m²) (I)"},{"name":"Fréquence ","type":"text","label":"Fréquence  (J)"},{"name":"Détails","type":"text","label":"Détails (K)"}]}]}},{"id":5,"module":"sendinblue:SendEmail","version":2,"parameters":{"__IMTCONN__":5581041},"mapper":{"templateId":"1","to":[{"name":"{{1.firstName}} {{1.lastName}}","email":"{{1.email}}"}],"replyTo":{"name":"PURE SPACE NETT","email":"contact@purespacenett.com"},"sender":{"name":"PURE SPACE NETT","email":"contact@purespacenett.com"},"params":[{"name":"firstName","value":"{{1.firstName}}"},{"name":"lastName","value":"{{1.lastName}}"},{"name":"service","value":"{{1.service}}"},{"name":"location","value":"{{1.location}}"},{"name":"surface","value":"{{1.surface}}"},{"name":"frequency","value":"{{1.frequency}}"}]},"metadata":{"designer":{"x":900,"y":0},"restore":{"parameters":{"__IMTCONN__":{"label":"PURE SPACE NETT Brevo","data":{"scoped":"true","connection":"sendinblue2"}}},"expect":{"templateId":{"mode":"chose","label":"1"},"to":{"mode":"chose","items":[null]},"attachment":{"mode":"chose"},"bcc":{"mode":"chose"},"cc":{"mode":"chose"},"headers":{"mode":"chose"},"tags":{"mode":"chose"},"params":{"mode":"chose","items":[null,null,null,null,null,null]}}},"parameters":[{"name":"__IMTCONN__","type":"account:sendinblue2","label":"Connection","required":true}],"expect":[{"name":"templateId","type":"select","label":"Template"},{"name":"to","type":"array","label":"To","required":true,"spec":[{"name":"name","type":"text","label":"Name"},{"name":"email","type":"email","label":"Email","required":true}]},{"name":"subject","type":"text","label":"Subject"},{"name":"htmlContent","type":"text","label":"HTML body"},{"name":"textContent","type":"text","label":"Text body"},{"name":"replyTo","type":"collection","label":"Reply To","required":true,"spec":[{"name":"name","type":"text","label":"Name"},{"name":"email","type":"email","label":"Email","required":true}]},{"name":"attachment","type":"array","label":"Attachments","spec":[{"name":"type","type":"select","label":"Type","options":[{"label":"URL","value":"url","nested":[{"name":"fileName","type":"filename","label":"File name","required":true},{"name":"url","type":"url","label":"Image URL","required":true}]},{"label":"Data","value":"data","nested":[{"name":"fileName","type":"filename","label":"File name","required":true,"semantic":"file:name"},{"name":"data","type":"buffer","label":"Data","required":true,"semantic":"file:data"}]}],"required":true}]},{"name":"bcc","type":"array","label":"BCC","spec":[{"name":"name","type":"text","label":"Name"},{"name":"email","type":"email","label":"Email"}]},{"name":"cc","type":"array","label":"CC","spec":[{"name":"name","type":"text","label":"Name"},{"name":"email","type":"email","label":"Email"}]},{"name":"sender","type":"collection","label":"Sender","spec":[{"name":"name","type":"text","label":"Name"},{"name":"email","type":"email","label":"Email"}]},{"name":"headers","type":"array","label":"Headers","spec":[{"name":"name","type":"text","label":"Name","required":true},{"name":"value","type":"text","label":"Value","required":true}]},{"name":"tags","type":"array","label":"Tags","spec":{"type":"text","name":"value"}},{"name":"params","type":"array","label":"Params","spec":[{"name":"name","type":"text","label":"Name","required":true},{"name":"value","type":"text","label":"Value","required":true}]}],"advanced":true}}],"metadata":{"instant":true,"version":1,"scenario":{"roundtrips":1,"maxErrors":3,"autoCommit":true,"autoCommitTriggerLast":true,"sequential":false,"slots":null,"confidential":false,"dataloss":false,"dlq":false,"freshVariables":false},"designer":{"orphans":[]},"zone":"eu1.make.com","notes":[]}}