Which automation workflow will send an email to a marketing manager with previous day's submissions as a CSV attachment?

The answer is based on the requirement of sending an email with the previous day's submissions attached as a CSV file. A scheduled automation is best suited for this task because it allows for the execution of a workflow at a specific time on a recurring basis, such as daily.

In this context, starting with a SQL query is essential because this step will retrieve the relevant data for the previous day's submissions from the database. After the data is extracted, the next step is the Data Extract, which formats this data into a CSV file. Once the file is ready, the Transfer File process ensures that this CSV is appropriately prepared for the email, followed by sending it via email to the designated marketing manager.

This sequence ensures that the data obtained is timely and relevant, adhering to the specific requirement of collecting total submissions from the previous day and delivering them in a consumable format. The correct answer aligns perfectly with the systematic approach required for the workflow, demonstrating a clear understanding of the automation process and the necessity of each step in the sequence.