How to Add Contacts from MS Excel to Sendinblue Using Pabbly Connect

Learn how to automate adding contacts from MS Excel to Sendinblue using Pabbly Connect with this detailed step-by-step tutorial. Follow this definitive guide to creating powerful automated workflows with straightforward, efficiency-focused solutions that save valuable time.

Watch Step By Step Video Tutorial Below

1. Introduction to Pabbly Connect for Excel and Sendinblue Integration

Pabbly Connect is an automation tool that allows you to integrate various applications seamlessly. In this tutorial, we will explore how to add contacts from MS Excel to Sendinblue using Pabbly Connect. This integration helps streamline your workflow by automating the process of transferring contact data.

By utilizing Pabbly Connect, you can eliminate the need for manual data entry, ensuring that your contacts are always up to date in Sendinblue. This tutorial will provide a step-by-step guide to setting up this integration effectively.

2. Setting Up Your Pabbly Connect Account

To begin, you need to create a free account on Pabbly Connect. Once you have your account set up, log in to access the dashboard. Click on the blue button labeled ‘Create Workflow’ to start the integration process. Name your workflow, for example, ‘MS Excel to Sendinblue Integration,’ and click ‘Create’.

• Visit the Pabbly Connect website.
• Create a free account or log in if you already have one.
• Click on ‘Create Workflow’ and name your workflow.

After creating your workflow, you will see two boxes for Trigger and Action. This is where you will connect MS Excel and Sendinblue using Pabbly Connect.

3. Connecting MS Excel with Pabbly Connect

In the Trigger box, select Microsoft Excel as the application. For the Trigger Event, choose ‘New Row in Worksheet’ to capture new contacts added to your Excel sheet. Click ‘Connect’ and then ‘Add New Connection’. You will need to log in to your OneDrive account where your Excel file is stored. using Pabbly Connect

Once connected, select the specific workbook containing your contact data. For example, if your workbook is named ‘All Lead Data’, select it from the list. After selecting the workbook, click ‘Save and Send Test Request’. This action will capture the most recent data added to the Excel sheet.

4. Adding Contacts to Sendinblue via Pabbly Connect

Next, you will set up the action to add contacts to Sendinblue. In the Action box, select Sendinblue and choose ‘Create or Update Contact’ as the Action Event. Click ‘Connect’ and then ‘Add New Connection’. You will need your Sendinblue API key, which can be found under your account settings.

After connecting to Sendinblue, map the fields from your Excel data to the corresponding fields in Sendinblue. For instance, map the email address and name from Excel to the email and first name fields in Sendinblue. Once all fields are mapped, click ‘Save and Send Test Request’ to add the contact.

• Select Sendinblue in the Action box.
• Choose ‘Create or Update Contact’ as the Action Event.
• Map Excel fields to Sendinblue fields.

Upon successful completion, you will receive a confirmation that the contact has been added to Sendinblue. This process illustrates how Pabbly Connect facilitates seamless integration between Excel and Sendinblue.

5. Automating Future Contacts with Pabbly Connect

Once the initial setup is complete, Pabbly Connect will check for new contacts in your Excel sheet every eight hours. This means that any new contacts added will automatically be uploaded to Sendinblue without any manual intervention.

To ensure a smooth experience, remember that you can always check your Sendinblue account to confirm that new contacts have been added. Additionally, you can revisit Pabbly Connect at any time to refine your workflow or make adjustments as needed.

This automation allows you to focus more on your business while Pabbly Connect handles the data transfer seamlessly in the background. You can also explore integrating other applications with Pabbly Connect to further enhance your workflow efficiency.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automate adding contacts from MS Excel to Sendinblue. By following the steps outlined, you can streamline your contact management process and ensure that your Sendinblue account is always up to date.