This workflow automates the daily process of importing new contacts from a NocoDB table into Brevo (formerly Sendinblue), ensuring data quality and avoiding spam. It uses scheduling to trigger every day, fetches new user records, validates essential fields, filters disposable email addresses, and then creates contacts in Brevo. The workflow also updates record statuses in NocoDB at each step to keep track of processing stages, reducing duplicate efforts and maintaining data integrity.
Step-by-step, the process begins with a scheduled trigger that activates once a day. It retrieves new user data from a specified NocoDB table where those records are marked as not yet imported (status 0). It then checks if key fields like first name, last name, and email are filled. Records missing this information are tagged with status 1 (empty fields). Next, it verifies whether email addresses are from disposable or temporary providers by matching against a blacklist regex. Disposable email entries are marked with status 2 (disposal email). For valid records, it processes each individually to avoid load issues, creates a new contact in Brevo with the user’s details, and subsequently updates the corresponding NocoDB record to reflect successful contact creation (status 3).
This workflow is particularly useful for marketing teams or CRM managers who want to automate the onboarding of new leads while maintaining high data quality and avoiding invalid or disposable email addresses. It ensures a smooth, error-resistant process of keeping contact databases updated efficiently.
Reviews
There are no reviews yet.