I have a Google Spreadsheet that I update daily with sales data from a variety of marketplaces (ie, Amazon, eBay, Walmart, etc). I'm trying to figure out a way that once a day, Zapier will pull the previous days sales and place them in their respective columns.
I've watched a read a few of the provided tutorials but the best I've been able to do is a triggered event for individual sales on any given marketplace. I'd need them added up and separated by day.
Best answer by AndrewJDavison
Hi
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?
+11Hi
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
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?
+11Lets 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
+11So
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
