Connexion Brevo pour LinkyFlow
LinkyFlow connecte Excel a Brevo pour consulter, modifier et publier les donnees e-commerce utiles depuis un tableur.
Ressources
55
Requetes de lecture
38
Actions ecriture
52
Champs documentes
449
Workflows a ramener dans Excel
Chaque ressource ci-dessous correspond a un workflow tableur concret. Les lectures ramenent des colonnes utiles dans Excel; les creations et modifications indiquent ce qui peut etre relu en lignes avant envoi.
Account
Account
The Brevo account this connection reaches: its organisation, its owner, its plans and credits.
- LectureAccount
GET /account1 entrée · 21 champs
Background Processes
The account’s imports and exports, each with its status: what an import or an export answered names one.
- LectureBackground Processes
GET /processes5 entrées · 6 champs
Sender Domains
The domains the account sends from, and whether each is verified and authenticated.
- LectureSender Domains
GET /senderDomains1 entrée · 10 champs
Senders
The addresses the account sends from, campaigns and transactional messages alike.
- LectureSenders
GET /senders3 entrées · 5 champs
Campaigns
Email Campaigns
The account’s email campaigns: their content, recipients, schedule, status and statistics.
- LectureEmail Campaigns
GET /emailCampaigns12 entrées · 6 champs - CreationCreate Email Campaign
POST /mutation/emailCampaigns43 entrées · 0 champs - ModificationUpdate Email Campaign
PATCH /mutation/emailCampaigns43 entrées · 0 champs - ModificationDelete Email Campaign
DELETE /mutation/emailCampaigns43 entrées · 0 champs
Export Campaign Recipients
Exports the recipients of this campaign to a file Brevo builds in the background.
- CreationExport Campaign Recipients
POST /mutation/emailCampaignExportRecipients3 entrées · 0 champs
Send Campaign Now
Sends this draft campaign to its recipients at once: it cannot be recalled.
- CreationSend Campaign Now
POST /mutation/emailCampaignSendNow1 entrée · 0 champs
Send SMS Campaign Now
Sends this draft SMS campaign to its recipients at once: it spends credits and cannot be recalled.
- CreationSend SMS Campaign Now
POST /mutation/smsCampaignSendNow1 entrée · 0 champs
Send Test Email
Sends this campaign to the test addresses named, or to the account’s test list.
- CreationSend Test Email
POST /mutation/emailCampaignSendTest2 entrées · 0 champs
Send Test SMS
Sends this SMS campaign to one test number.
- CreationSend Test SMS
POST /mutation/smsCampaignSendTest2 entrées · 0 champs
SMS Campaigns
The account’s SMS campaigns: their content, recipients, schedule, status and statistics.
- LectureSMS Campaigns
GET /smsCampaigns8 entrées · 25 champs - CreationCreate SMS Campaign
POST /mutation/smsCampaigns9 entrées · 0 champs - ModificationUpdate SMS Campaign
PATCH /mutation/smsCampaigns9 entrées · 0 champs - ModificationDelete SMS Campaign
DELETE /mutation/smsCampaigns9 entrées · 0 champs
Update Campaign Status
Suspends, cancels, archives, unarchives, duplicates a campaign or puts it back to draft.
- CreationUpdate Campaign Status
POST /mutation/emailCampaignUpdateStatus2 entrées · 0 champs
Update SMS Campaign Status
Suspends, cancels, archives, unarchives a campaign or puts it back to draft.
- CreationUpdate SMS Campaign Status
POST /mutation/smsCampaignUpdateStatus2 entrées · 0 champs
WhatsApp Campaigns
The account’s WhatsApp campaigns, their template, status and statistics.
- LectureWhatsApp Campaigns
GET /whatsappCampaigns7 entrées · 16 champs
WhatsApp Configuration
The WhatsApp Business account Brevo sends from: its phone number, quality and limits.
- LectureWhatsApp Configuration
GET /whatsappConfig1 entrée · 6 champs
WhatsApp Templates
The WhatsApp templates of the account and their approval by Meta.
- LectureWhatsApp Templates
GET /whatsappTemplates7 entrées · 6 champs
Contacts
Add Contacts to List
Adds existing contacts to this list, by their email, their id or their external id: one of the three.
- CreationAdd Contacts to List
POST /mutation/contactListAddContacts4 entrées · 0 champs
Consent Groups
The consent groups of the account, where Brevo enables them: what a contact agreed to receive.
- LectureConsent Groups
GET /consentGroups6 entrées · 8 champs
Contact Attributes
The attributes a contact may hold, standard and custom, with their type and category.
- LectureContact Attributes
GET /contactAttributes1 entrée · 6 champs
Contact Exports
Exports contacts to a CSV file Brevo builds in the background.
- CreationExport Contacts
POST /mutation/contactExports16 entrées · 0 champs
Contact Folders
The folders the account’s lists are filed in.
- LectureContact Folders
GET /contactFolders5 entrées · 5 champs - CreationCreate Contact Folder
POST /mutation/contactFolders1 entrée · 0 champs - ModificationUpdate Contact Folder
PATCH /mutation/contactFolders1 entrée · 0 champs - ModificationDelete Contact Folder
DELETE /mutation/contactFolders1 entrée · 0 champs
Contact Imports
Imports contacts from a file Brevo fetches, a CSV or JSON body: a background process.
- CreationImport Contacts
POST /mutation/contactImports13 entrées · 0 champs
Contact Lists
The account’s lists, with their subscribers and their folder.
- LectureContact Lists
GET /contactLists5 entrées · 6 champs - CreationCreate Contact List
POST /mutation/contactLists2 entrées · 0 champs - ModificationUpdate Contact List
PATCH /mutation/contactLists2 entrées · 0 champs - ModificationDelete Contact List
DELETE /mutation/contactLists2 entrées · 0 champs
Contacts
The account’s contacts, their attributes, the lists they belong to and whether they are blocklisted.
- LectureContacts
GET /contacts11 entrées · 11 champs - CreationCreate Contact
POST /mutation/contacts10 entrées · 0 champs - ModificationUpdate Contact
PATCH /mutation/contacts10 entrées · 0 champs - ModificationDelete Contact
DELETE /mutation/contacts10 entrées · 0 champs
Contacts of a List
The contacts one list holds.
- LectureContacts of a List
GET /listContacts6 entrées · 11 champs
Double Opt-In Contacts
Asks a person to confirm their subscription: Brevo emails them, and they join the lists once they confirm.
- CreationCreate Contact by Double Opt-In
POST /mutation/doubleOptinContacts7 entrées · 0 champs
Events
The custom events tracked on contacts, which can start an automation.
- LectureEvents
GET /events8 entrées · 7 champs - CreationTrack Event
POST /mutation/events12 entrées · 0 champs
Lists of a Folder
The lists one folder holds.
- LectureLists of a Folder
GET /folderLists5 entrées · 5 champs
Remove Contacts from List
Takes contacts out of this list, by their email or their id: the contacts stay in the account.
- CreationRemove Contacts from List
POST /mutation/contactListRemoveContacts3 entrées · 0 champs
Segments
The account’s segments: contacts chosen by a rule, kept up to date by Brevo.
- LectureSegments
GET /contactSegments4 entrées · 4 champs
CRM
Companies
The companies of the CRM, their attributes and the contacts and deals linked to them.
- LectureCompanies
GET /companies11 entrées · 15 champs - CreationCreate Company
POST /mutation/companies5 entrées · 0 champs - ModificationUpdate Company
PATCH /mutation/companies5 entrées · 0 champs - ModificationDelete Company
DELETE /mutation/companies5 entrées · 0 champs
Company Attributes
The attributes a company may hold, with their type.
- LectureCompany Attributes
GET /companyAttributes1 entrée · 6 champs
CRM Files
The files attached to contacts, companies and deals in the CRM.
- LectureCRM Files
GET /crmFiles8 entrées · 8 champs
Deal Attributes
The attributes a deal may hold, with their type.
- LectureDeal Attributes
GET /dealAttributes1 entrée · 6 champs
Deals
The deals of the CRM: their stage, amount, owner and the contacts and companies linked to them.
- LectureDeals
GET /deals14 entrées · 16 champs - CreationCreate Deal
POST /mutation/deals4 entrées · 0 champs - ModificationUpdate Deal
PATCH /mutation/deals4 entrées · 0 champs - ModificationDelete Deal
DELETE /mutation/deals4 entrées · 0 champs
Link Company
Links contacts and deals to this company, or unlinks them.
- CreationLink Company
POST /mutation/companyLinks5 entrées · 0 champs
Link Deal
Links contacts and companies to this deal, or unlinks them.
- CreationLink Deal
POST /mutation/dealLinks5 entrées · 0 champs
Notes
The notes of the CRM, on contacts, companies and deals.
- LectureNotes
GET /notes9 entrées · 8 champs - CreationCreate Note
POST /mutation/notes4 entrées · 0 champs - ModificationUpdate Note
PATCH /mutation/notes4 entrées · 0 champs - ModificationDelete Note
DELETE /mutation/notes4 entrées · 0 champs
Pipelines
The deal pipelines of the CRM and their stages.
- LecturePipelines
GET /pipelines1 entrée · 3 champs
Task Types
The kinds of task the CRM offers.
- LectureTask Types
GET /taskTypes1 entrée · 2 champs
Tasks
The tasks of the CRM: calls, meetings, emails, with their date, status and what they concern.
- LectureTasks
GET /tasks15 entrées · 12 champs - CreationCreate Task
POST /mutation/tasks13 entrées · 0 champs - ModificationUpdate Task
PATCH /mutation/tasks13 entrées · 0 champs - ModificationDelete Task
DELETE /mutation/tasks13 entrées · 0 champs
Transactional
Blocked Transactional Contacts
The contacts transactional emails no longer reach: unsubscribed, bounced, or blocked by hand.
- LectureBlocked Transactional Contacts
GET /blockedContacts7 entrées · 6 champs - ModificationUnblock Transactional Contact
DELETE /mutation/blockedContacts1 entrée · 0 champs
Email Templates
The account’s email templates, used by transactional emails and automations.
- LectureEmail Templates
GET /emailTemplates7 entrées · 16 champs - CreationCreate Email Template
POST /mutation/emailTemplates12 entrées · 0 champs - ModificationUpdate Email Template
PATCH /mutation/emailTemplates12 entrées · 0 champs - ModificationDelete Email Template
DELETE /mutation/emailTemplates12 entrées · 0 champs
Send Template Test
Sends this template to the test addresses named, or to the account’s test list.
- CreationSend Template Test
POST /mutation/emailTemplateSendTest2 entrées · 0 champs
SMS Templates
The account’s transactional SMS templates.
- LectureSMS Templates
GET /smsTemplates4 entrées · 15 champs
Transactional Email Events
What happened to each transactional email: delivered, opened, clicked, bounced, blocked, unsubscribed.
- LectureTransactional Email Events
GET /emailEvents12 entrées · 11 champs
Transactional Email Reports
The transactional email activity, summed per day.
- LectureTransactional Email Reports
GET /emailReports8 entrées · 16 champs
Transactional Email Sends
Sends one transactional email — an order, an account message —, from a template or its own content.
- CreationSend Transactional Email
POST /mutation/transactionalEmailSends15 entrées · 0 champs
Transactional Email Summary
The transactional email activity over a period, summed.
- LectureTransactional Email Summary
GET /emailSummary5 entrées · 16 champs
Transactional Emails
The transactional emails sent, found by recipient, template or message id.
- LectureTransactional Emails
GET /transactionalEmails9 entrées · 8 champs
Transactional SMS Events
What happened to each transactional SMS: sent, delivered, bounced, replied, unsubscribed.
- LectureTransactional SMS Events
GET /smsEvents10 entrées · 7 champs
Transactional SMS Reports
The transactional SMS activity, summed per day.
- LectureTransactional SMS Reports
GET /smsReports6 entrées · 11 champs
Transactional SMS Sends
Sends one transactional SMS to a mobile number: it spends credits.
- CreationSend Transactional SMS
POST /mutation/transactionalSmsSends8 entrées · 0 champs
Webhooks
The addresses Brevo notifies of the account’s events: deliveries, opens, clicks, unsubscriptions.
- LectureWebhooks
GET /webhooks4 entrées · 10 champs - CreationCreate Webhook
POST /mutation/webhooks10 entrées · 0 champs - ModificationUpdate Webhook
PATCH /mutation/webhooks10 entrées · 0 champs - ModificationDelete Webhook
DELETE /mutation/webhooks10 entrées · 0 champs
WhatsApp Events
What happened to each WhatsApp message: sent, delivered, read, replied, failed.
- LectureWhatsApp Events
GET /whatsappEvents9 entrées · 8 champs