How to Add Mailerlite Subscribers to Microsoft Excel Using Pabbly Connect

Learn how to seamlessly integrate Mailerlite subscribers into Microsoft Excel using Pabbly Connect with this step-by-step tutorial. This comprehensive guide reveals exactly how to connect your applications and automate repetitive tasks — accessible for professionals of all technical backgrounds.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Mailerlite Integration

To begin the process of adding Mailerlite subscribers to Microsoft Excel, first, access Pabbly Connect by visiting Pabbly.com/connect. This platform allows you to automate the integration of Mailerlite with Excel seamlessly.

Once on the Pabbly Connect page, you can either sign in if you are an existing user or sign up for a free account. New users will receive 100 free tasks upon signing up. After logging in, navigate to the dashboard where you can create a new workflow.

2. Creating a Workflow in Pabbly Connect

After accessing your dashboard in Pabbly Connect, click on the ‘Create Workflow’ button. You will be prompted to name your workflow. For this integration, name it something relevant, such as ‘Mailerlite to MS Excel’.

Once named, you will see options for selecting a trigger and action. Here, select Mailerlite as the trigger application and choose the trigger event as ‘New Subscriber Created’. This event will initiate the workflow every time a new subscriber is added in Mailerlite.

• Click on ‘Connect’ to link your Mailerlite account.
• Add a new connection by entering your Mailerlite API key.
• Test the connection to ensure it is working properly.

After setting up the trigger, save the configuration to proceed with the workflow.

3. Setting Up Mailerlite in Pabbly Connect

Next, you need to configure the Mailerlite connection within Pabbly Connect. To retrieve your API key, log into your Mailerlite account, click on your profile picture, and select ‘Integrations’. Here, you will find the ‘Developer API’ option, where you can copy your API key.

Once you have the API key, return to Pabbly Connect and paste it into the designated field. Click on ‘Save’ to establish the connection. After saving, you will need to perform a test submission to capture subscriber data.

• Go back to Mailerlite and add a test subscriber.
• Fill in the subscriber details and click on ‘Add Subscriber’.
• Return to Pabbly Connect to receive the API response.

Upon receiving the response, you will see the subscriber’s details reflected in Pabbly Connect, confirming that the integration is ready.

4. Formatting Data for Microsoft Excel

Once the subscriber data is captured, the next step is to format this data for Microsoft Excel using Pabbly Connect. Select the ‘DateTime Formatter’ feature to adjust the date format as necessary.

Map the created date from the Mailerlite response to the DateTime Formatter. Set the desired output format you want for your Excel sheet. Once configured, click on ‘Save and Send Test Request’ to ensure the data is formatted correctly.

Select the input format from the Mailerlite data. Choose the output format that suits your Excel requirements. Test the formatted output to confirm it meets your expectations.

Once the data is formatted, you can proceed to set up the action step to add this data to your Excel sheet.

5. Adding Subscriber Data to Microsoft Excel

Now, with the formatted data ready, it’s time to add it to Microsoft Excel. In Pabbly Connect, select Microsoft Excel as the action application and choose the action event as ‘Add Row’.

Connect your Microsoft Excel account by selecting ‘Add New Connection’ and authorizing access. Once connected, select the specific workbook and worksheet where you want to add the subscriber details.

Choose the workbook that contains your Excel sheet. Select the worksheet where the data will be added. Map the fields from Mailerlite to the corresponding columns in Excel.

After mapping, click on ‘Save and Send Test Request’ to add the subscriber information to your Excel sheet. Refresh your Excel to see the newly added subscriber data confirmed in the spreadsheet.

Conclusion

In this tutorial, we demonstrated how to effectively use Pabbly Connect to add Mailerlite subscribers to Microsoft Excel automatically. This integration streamlines the process and ensures that your subscriber data is always up-to-date in your Excel sheets. By following the steps outlined, you can leverage the power of Pabbly Connect for efficient data management.