# IfThisThanThat App Question

**URL:** <https://community.tempest.earth/t/ifthisthanthat-app-question/15086>\
**Category:** Tempest Owners\
**Tags:** tempest\
**Created:** [October 2, 2021, 3:50am UTC](https://community.tempest.earth/t/ifthisthanthat-app-question/15086 "2021-10-02T03:50:25Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mrwilliamfarrell](https://avatars.discourse-cdn.com/v4/letter/m/b3f665/32.png) [@mrwilliamfarrell](https://community.tempest.earth/u/mrwilliamfarrell)\
**Post date:** [October 2, 2021, 3:50am UTC](https://community.tempest.earth/t/ifthisthanthat-app-question/15086/1 "2021-10-02T03:50:25Z")

</div>

Hello,

I am using IFTT to log data to Google sheets. It logs every one minute. Can this time be changed and if so, does anyone know how to do it. I was thinking like maybe every 30 minutes. The app i am using is the one Tempest recommended. Thanks, Bill

---

<div class="post-metadata">

**Author:** ![iladyman](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tempest.earth/iladyman/32/2305_2.png) [@iladyman](https://community.tempest.earth/u/iladyman)\
**Post date:** [October 3, 2021, 6:50am UTC](https://community.tempest.earth/t/ifthisthanthat-app-question/15086/2 "2021-10-03T06:50:09Z")

</div>

Hi @mrwilliamfarrell ,

Your title will hide your question. Your question relates to google sheets because that is where it can be done. The way I would do that is by using a script in the google sheets application. And you would need to include some formulas to combine the period that you wish to remove for the results to be accurate. I would write the script to run every 30 minutes or whatever period you like, to read and calculate the values and then paste those combined readings onto a new sheet. Then delete the rows from the first sheet because otherwise it will reach the 2000 row limit. I did document some formulas to convert the google sheet values, and a search in this forum will find those. I found problems using ifttt to google sheets and no longer use that method. I have resorted to getting my data from the API. You can download the data in csv format from the API which solves all the ifttt google sheets issues.  
Cheers Ian 🙂

---

<div class="post-metadata">

**Author:** ![mrwilliamfarrell](https://avatars.discourse-cdn.com/v4/letter/m/b3f665/32.png) [@mrwilliamfarrell](https://community.tempest.earth/u/mrwilliamfarrell)\
**Post date:** [October 3, 2021, 4:47pm UTC](https://community.tempest.earth/t/ifthisthanthat-app-question/15086/3 "2021-10-03T16:47:41Z")

</div>

Thank you Ian. Hope you are well down under! Unfortunately you are talking way above my level. I can manage to sort a list in Excel but that’s about it. When you are talking about the API, what are you referring to? Is it something I can access?

Best,  
Bill

---

<div class="post-metadata">

**Author:** ![eric](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tempest.earth/eric/32/13553_2.png) [@eric](https://community.tempest.earth/u/eric)\
**Post date:** [October 3, 2021, 4:57pm UTC](https://community.tempest.earth/t/ifthisthanthat-app-question/15086/4 "2021-10-03T16:57:03Z")

</div>

[api is open](https://weatherflow.github.io/Tempest) to all but you need some coding skills.

Maybe look into some [third party scripts](https://community.tempest.earth/c/developers/integrations/12) maybe ??