Backup all MailerLite subscribers to Google Sheet daily

I´m trying to create an scenario to backup all my subscribers from MailerLite into a Google Sheet daily.

I have created the scenario and added MailerLite “List Subscribers” module to retrieve the list of subscribers, and the Gooogle Sheets “Bulk Add Rows (Advance)” module to store them, but when I try to select the data for the Rows field of this module I can only select an array, and I would need to select all the bundles generated in the first module, how can I do that?

I´ve only been able to select a variable called “Fields” from the MailerLite module and that works, but it´s missing a lot of data that is not in “Fields” (for example the email address of the subscriber is missing).

1 Like

Hey @VictorA

Before google sheet module, add an array aggregator and select “target structure type” from google sheet module. Then map the data in aggregator. And then map the array from aggregator inside google sheet module.

Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation

2 Likes

It works like a charm, thanks!!

1 Like

Hi @VictorA

Glad to hear the issue is solved.

Best regards,

Msquare Automation
Platinum Partner of Make
@Msquare_Automation

1 Like