# Google Analytics pull date range from google sheet or other widgets **URL:** \ **Category:** Ask a question\ **Tags:** Using-APIs\ **Created:** [March 19, 2022, 9:17pm UTC](https://community.parabola.io/t/google-analytics-pull-date-range-from-google-sheet-or-other-widgets/2312 "2022-03-19T21:17:49Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Kareem\_Abukhadra](https://avatars.discourse-cdn.com/v4/letter/k/c4cdca/32.png) [@Kareem\_Abukhadra](https://community.parabola.io/u/Kareem_Abukhadra)\ **Post date:** [March 19, 2022, 9:17pm UTC](https://community.parabola.io/t/google-analytics-pull-date-range-from-google-sheet-or-other-widgets/2312/1 "2022-03-19T21:17:50Z")
Hi team, Is there a way to send date ranged to Google Analytics integrations widget from a google sheet or other date widgets? I want to enter custom date ranges in a google sheet that can be referenced by Parabola flow and be used as input for Google Analytics integration widget. Thanks ---
**Author:** ![Emory\_Stainbrook](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/emory_stainbrook/32/1772_2.png) [@Emory\_Stainbrook](https://community.parabola.io/u/Emory_Stainbrook)\ **Post date:** [March 21, 2022, 4:35pm UTC](https://community.parabola.io/t/google-analytics-pull-date-range-from-google-sheet-or-other-widgets/2312/2 "2022-03-21T16:35:30Z")
Hi @Kareem_Abukhadra - happy to help! How are you choosing this date range? Is it pattern based (pull the last week/month)? If the date range that you’re looking to pull is relative to the current date, you could use a [Compare dates](https://parabola.io/transform/compare-dates) step. You would use this to find the difference between the dates that you’re pulling over as compared to today’s date. You would then use a “Filter rows” step to keep the rows that are within the range that you are trying to pull.