Hello I have a automation I have been trying and failinng . I am pulling new orders from Shopify and updating a spreadsheet rows with order details . I want to summarise the orders for the day and send it to mail. Like if I am getting 10 order I should send the 10 order at the. End of the day . If the next day I get 20 order I want to send those details to email.
How do I send daily Shopify order summaries to an email?
Hey
Yes, this is possible to automate on Zapier. You can create reports in multiple ways.
How can you guide
Hi
If you log the date (only the date) of the Shopify order into the GSheet, then you can use a GSheets Lookup Row(s) Zap action to find the details of multiple rows.
can it be done it with digest by zpaier it logs the entry in sheet and send it to me onece day ?
Digest is one approach that can work: https://zapier.com/apps/digest/help
can it total the revenue of the orders in the week if i sechulde it weekly or do i have perform it in gsheet ?
This is my table format, i am trying to calculate the total and send the weekly revenue to mail . Still confused what to do any help ? Should i use digest, is my flow correct ?
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/94802e0b-1ac6-454d-abdb-b1ee0e976b67.png)
To keep a running total, you would need to use Storage:
https://zapier.com/apps/storage/integrations#triggers-and-actions
https://zapier.com/apps/storage/help
Logic
Get Value
Formatter > Numbers > Perform Math Operation (Add)
Set Value
Then Reset value after the email is sent
It's confusing for me can I do the calculation in sheet and send it to email
It’s possible to use GSheets to do calculations, but you would need to somehow lookup a row that has the SUM for the other rows matching the date you want the data for.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.