Hi all, I’ve set up new automations to gather daily metrics of sales and FB ad spend for clients in our agency, but I’m wanting to run a similar automation to pull in previosu data for the rest of this month.
AI help has added new modules to my scenario but it’s confused me more and I’m not sure it’s right.
My existing automation is
Gather list of orders > Filter by yesterday’s date > Number aggregator to sum the total order amount > Create a record in Airtable.
How can I do the same thing but give it a list of dates e.g. 1st October - 21st October and have it cycle through each date and create a new record without me having to manually change the date to match.
Thanks!