# Weekly report from Google sheet based on rows added in the last 7 days

**URL:** <https://community.parabola.io/t/weekly-report-from-google-sheet-based-on-rows-added-in-the-last-7-days/1421>\
**Category:** Ask a question\
**Tags:** Building-Flows\
**Created:** [December 22, 2020, 2:44pm UTC](https://community.parabola.io/t/weekly-report-from-google-sheet-based-on-rows-added-in-the-last-7-days/1421 "2020-12-22T14:44:55Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Thomas\_Christensen](https://avatars.discourse-cdn.com/v4/letter/t/34f0e0/32.png) [@Thomas\_Christensen](https://community.parabola.io/u/Thomas_Christensen)\
**Post date:** [December 22, 2020, 2:44pm UTC](https://community.parabola.io/t/weekly-report-from-google-sheet-based-on-rows-added-in-the-last-7-days/1421/1 "2020-12-22T14:44:56Z")

</div>

I’m trying to work on some data from a Google sheet that we’re sending feedback to.

We have two columns in the sheet:  
rating | submitted at  
ie. 4 | 2020-12-13

So every Monday morning I’d like to take only the rows submitted in the last 7 days, run some math on it, and post those results in a slack channel.

Now, I’ve tried using the filter method to do that, but I can’t get that to filter out based on dynamic dates like “Last 7 days”.

Anyone knows of a solution to this?

Thank you!

---

<div class="post-metadata">

**Author:** ![daniel](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/daniel/32/732_2.png) [@daniel](https://community.parabola.io/u/daniel)\
**Post date:** [December 22, 2020, 7:15pm UTC](https://community.parabola.io/t/weekly-report-from-google-sheet-based-on-rows-added-in-the-last-7-days/1421/2 "2020-12-22T19:15:16Z")

</div>

Hey @Thomas_Christensen 👋

Welcome to the community!

Try using a [Compare dates](https://parabola.io/transform/compare-dates) step after pulling in your data from Google Sheets. By default, this step creates a new column called `Difference` and finds the number of `Hours` between an auto-selected column.

Just be sure to select the number of `Days` between your `submitted at` column and the `current time`.

Using a [Filter rows](https://parabola.io/transform/filter-rows) step, you can keep rows that have a value less than or equal to `-7` in the `Difference` column.

---

<div class="post-metadata">

**Author:** ![Thomas\_Christensen](https://avatars.discourse-cdn.com/v4/letter/t/34f0e0/32.png) [@Thomas\_Christensen](https://community.parabola.io/u/Thomas_Christensen)\
**Post date:** [December 22, 2020, 7:51pm UTC](https://community.parabola.io/t/weekly-report-from-google-sheet-based-on-rows-added-in-the-last-7-days/1421/3 "2020-12-22T19:51:19Z")

</div>

Sounds like that should do it. Ill try that and let you know Daniel!