I have a Google Sheet where data is recorded continuously. I want to create a scenario that checks each new row containing a person’s data, looks at the email column, and checks in Brevo if the email exists in the contacts. Then, it should provide two paths: one if the contact exists, in which case it updates their data and adds them to a list; and if the contact doesn’t exist, it creates a new contact and adds them to the list.
Hey Mohamed,
this sound entirely doable, what issues are you facing with it?
Welcome to the Make community!
Yes, that is possible. You’ll need a minimum of four modules:
Simply attempt to get the contact by email. If the user is not found, an error will be thrown. Attach an error handling route to it, and then you can create a new contact.
This is just an example. Your final solution may or may not look like this depending on your requirements.
Error directives can only be added to an error handler route.
1. Right click and select “Add error handler”
2. Error handlers will appear
For more information on error handling, see:
- Introduction to errors and warnings in Make
- Overview of error handling in Make
- Error handlers
- Overview of error handling in Make
- Watch these videos by Make - Learn all about error handling (YouTube playlist)
Hope this helps! Let me know if there are any further questions or issues. P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!
— @samliew