How to Save Sendinblue Campaign Details to MS Excel Using Pabbly Connect

Learn how to integrate Sendinblue with MS Excel using Pabbly Connect. Automate saving campaign details effortlessly with this step-by-step tutorial. Build sophisticated automated workflows in less time than you think. This guide translates complex integrations into straightforward steps for immediate implementation.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To save Sendinblue campaign details to MS Excel, you first need to access Pabbly Connect. Open your browser and search for Pabbly Connect. Click on the ‘Sign Up Free’ button to create a new account or log in if you already have one.

Once logged in, you will reach the Pabbly Connect dashboard. Here, click on ‘Create Workflow’ and name your workflow, for example, ‘Sendinblue to MS Excel’. This sets the stage for automating the process of saving campaign details.

2. Setting Up the Schedule Trigger in Pabbly Connect

In this section, we will set up the schedule trigger in Pabbly Connect. The trigger is essential as it determines when the automation will run. Select ‘Schedule’ as the trigger type and choose how often you want the workflow to execute.

• Select ‘Every Day’ from the dropdown.
• Set the time for execution, e.g., 10 AM.

After setting the schedule, click on ‘Save’. This will ensure that your automation runs daily at the specified time, fetching campaign details from Sendinblue.

3. Fetching Campaign Details from Sendinblue

Next, we will configure the action step to fetch campaign details from Sendinblue using Pabbly Connect. In the action window, search for ‘Sendinblue’ and select it. Choose the action event as ‘Get Email Campaign Information’.

Click on ‘Connect’ and then select ‘Add New Connection’. To connect your Sendinblue account, you will need an API key. Go to your Sendinblue dashboard, click on your username, and select ‘SMTP & API’. Generate a new API key and copy it.

• Paste the API key back in Pabbly Connect.
• Select the campaign you want to track from the dropdown.

After saving the connection, click on ‘Save and Send Test Request’. This will retrieve the campaign details which will be used in the next steps.

4. Adding Current Date to the Workflow

Now that we have the campaign details, we need to add the current date to our workflow using Pabbly Connect. This is important for tracking when the data was fetched. Add a new action step and search for ‘Date Time Formatter’.

Select the action event as ‘Current Date’ and click on ‘Connect’. You will need to specify the format for the date. Choose a format such as ‘D Month Year’ and set the option to include time as false.

Click on ‘Save and Send Test Request’ to confirm. The current date will now be available for mapping in the next step.

This date will accompany the campaign details when they are added to Microsoft Excel.

5. Sending Campaign Data to Microsoft Excel

In the final step, we will configure Pabbly Connect to send the campaign details into Microsoft Excel. Add another action step and search for ‘Microsoft Excel’. Choose the action event ‘Add Row to Worksheet’.

Click on ‘Connect’ and authorize your Microsoft Excel account. Once connected, select the workbook where you want to save the campaign details. Map the data retrieved from Sendinblue and the current date into the respective columns in Excel.

Map the date to Column A. Map total emails sent, delivered emails, unique views, and unsubscribed numbers to the respective columns.

After mapping all necessary data, click on ‘Save and Send Test Request’. You should see a positive response indicating that the data has been successfully added to your Excel sheet.

Conclusion

In this tutorial, we have successfully integrated Sendinblue with Microsoft Excel using Pabbly Connect. By following the steps outlined, you can automate the process of saving campaign details, ensuring your data is always up to date. This integration simplifies your workflow and enhances productivity.