I’ve created base and table, to which all new orders from my Woocommerc shop are imported through Zapier.
I wanted to create an automation (through Airtable, not Zapier) that would send me an e-mail with the number of orders and their sum at the end of the day. I’ve created automation to run every day, and search for orders which day is “today”. Unfortunately, I cannot find a way, to sum order amount and insert it into an e-mail.
Do you have any tips on how to do that? Do you think it is even possible?
Thanks in advance!