Hi @jtek

So, with those zaps that trigger on each sale, you should keep a sales total tally using a "Zapier Storage->Increment Value" step, creating a value key for each store.

Storage by Zapier Integrations | Connect Your Apps with Zapier Then you'd have another zap with a "Schedule by Zapier" trigger. It would run daily, get the values for all the stored keys, then create/update a row on the Google Sheet, and then (crucially) reset all the storage keys back to zero, read for the new day's sales.

Does that make sense?

Hmmm...I see. It does make sense, thank you @AndrewJDavison_Luhhu .

So 2 Zaps. One that conducts the tally and another that posts the update.

Interesting. I'm assuming this is the most cost efficient method?

@jtek - It will be one zap for each sales source, then one single daily zap that retrieves the tally.

@AndrewJDavison_Luhhu

Lets say I have 5 marketplaces and each has 10 orders on a given day.

1 Zap for all 10 sales (x 5 marketplaces) = 50 Zaps + 1 Tally

or

1 Zap for each marketplace = 5 Zaps + 1 Tally

So @jtek - there would be:

1x Amazon orders zap (for all orders)

1x Walmart orders zap (for all orders)

1x eBay orders zap (for all orders)

etc...

Then just 1x daily tally zap... it would have "Storage->Get Value" steps for each marketplace and then then one "Google Sheets->Create Row" step, followed by a steps to reset all the values for each marketplace back to 0.

Got it. Thank you!