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.

  • Home
  • Get Help
  • How Do I
  • How do I total sales from a spreadsheet within the last 6 days from today’s date using Storage by Zapier?

Hi,

Please can someone assist. What is the best way to solve the following.

 

I want to sum total sales data from a spreadsheet thats within the last 6 days from todays date.

I want to store those values and sum them together and store them in a zapier storage. 

I need the Zapier storage to clear itself so that only the last 6 days worth of data is stored as a total.

 

Hope this makes sense.

Hi @AshleyB 

Good question.

This can easily be done in Airtable: https://zapier.com/apps/airtable/integrations

  1. Log each records
  2. Link records to a MASTER record in a different Table.
  3. Use a Rollup field with conditions to only include records within the last X days: https://support.airtable.com/hc/en-us/articles/360042807233-Rollup-field-overview

 

If you’re trying to use GSheets, then you can use another GSheet tab.

Formulas can be used to sum up the desired rows.

Try these functions:

FILTER: https://support.google.com/docs/answer/3093197?hl=en

or

QUERY: https://support.google.com/docs/answer/3093343?hl=en

 

Hi @AshleyB!

Do you think that Troy’s suggestion of using a Google Sheets function (or moving the data to Airtable and using the functions there) will do what you need it to? I think that they will likely be the easier options, but if they wont work for this specific use case let us know, and tell us why, and we’ll see if we can figure something out!

 

Thanks!

@Troy Tessalone Thank you for getting back. Unfortunately I only want to use Zapier.

@Danvers - Is it possible to do this without editing the google sheet / adding tabs. Just use Zapier standard tools.

 

  1. Sales Sheet
  2. User adds a sale
  3. Zapier Trigger Google Sheets row
  4. Zapier lookups all Rows for Matching date that is within 6 days
  5. Zapier sums total sales for the last 6 days
  6. Zapier Saves to Storage
  7. Zapier Storage removes data that is older than 6 days

Hope this makes senses. Thanks again for support

@AshleyB 

FYI: GSheets Zap app has limits of finding 10 or 20 rows MAX.

 

Terms & Conditions