How can I automatically send the AQS data to an external table

Question & Answer
,
1

Hello,

I want to automatically send emails to a customer list from a dashboard that can be updated every hour, with for example “all customers who subscribed in the last hour”.
I can easily create the table.
But then I’d like my mailer (Brevo) to automatically retrieve the data and send the email campaign.

How can I automatically send the AQS data to an external table (for example a google sheet)?

Thanks for your help.

2

Hi @Antoine

One solution I could think of is by using QuickSight Paginated report API to programatically download the data in csv/excel and send it to S3 bucket . Once the file placed in S3 bucket lambda function can be invoked to process it further to send email / feed data to Brevo. Please refer the blogs for additional information.

Thanks
Vinod