Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

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.

Hey @panda992 ,

 

Yes, this is possible to automate on Zapier. You can create reports in multiple ways.

How can you guide

Hi @panda992 

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.

 

  1. Trigger: Schedule
  2. Action: GSheets - Lookup Row(s)
  3. Action: Formatter > Utilities > Line Items to Text
    1. Used to format the data for the email
  4. Action: Gmail - Send Email

can it be done it with digest by zpaier    it logs the entry in sheet and send it to me onece day ?

 

@panda992 

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 ?

@panda992 

You’d likely have to do the calculation in a Zap step.

 

OPTIONS

 

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  ?

 

@panda992 

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

@panda992 

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.

Hi there, @panda992 👋

Were you able to get the total weekly revenue of the orders calculated and sent out in the email?

Let us know if you’re still stuck or need any further help on this! 🙂

Terms & Conditions