# Logging to spreadsheet - best strategy

**URL:** <https://community.homey.app/t/logging-to-spreadsheet-best-strategy/59288>\
**Category:** Questions & Help\
**Created:** [January 28, 2022, 1:00am UTC](https://community.homey.app/t/logging-to-spreadsheet-best-strategy/59288 "2022-01-28T01:00:36Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Johan\_Karlsson](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/johan_karlsson/32/16493_2.png) [@Johan\_Karlsson](https://community.homey.app/u/Johan_Karlsson)\
**Post date:** [January 28, 2022, 1:00am UTC](https://community.homey.app/t/logging-to-spreadsheet-best-strategy/59288/1 "2022-01-28T01:00:37Z")

</div>

Hi,

I’ve been using IFTTT to log from the BMW App(brilliant app btw) but as I understand it the IFTTT app will stop shortly.

So wanted to check how what your best strategy is for logging, I wish to log about 5-10 parameters several times a day to an spreadsheet (or csv) that is stored outside the Homey space (Google drive, Onedrive, Dropbox etc). I’ve tried SimpleLog but it seems to crash every time I’'m exporting + it mixes all logs in one spreadsheet.

Any suggestions or ideas?

Johan

---

<div class="post-metadata">

**Author:** ![Peter\_Kawa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/peter_kawa/32/173848_2.png) [@Peter\_Kawa](https://community.homey.app/u/Peter_Kawa)\
**Post date:** [January 28, 2022, 4:00pm UTC](https://community.homey.app/t/logging-to-spreadsheet-best-strategy/59288/2 "2022-01-28T16:00:49Z")

</div>

Search for ‘insights’ and ‘export’ in the app store, maybe there’s something useful.

---

<div class="post-metadata">

**Author:** ![Johan\_Karlsson](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/johan_karlsson/32/16493_2.png) [@Johan\_Karlsson](https://community.homey.app/u/Johan_Karlsson)\
**Post date:** [January 29, 2022, 8:55am UTC](https://community.homey.app/t/logging-to-spreadsheet-best-strategy/59288/3 "2022-01-29T08:55:39Z")

</div>

Thanks, for your suggestion.

However It seems I can get to the data I want to expose, what I need to log is not exported and some i need to export it at a certain time/date (i.e. when i drive is finished i want to log mileage but also start address and end address and a few other things).

Been looking for if I could create my own datapoints/diagrams in Insights and select what type of diagrams I would like but so far no luck.

---

<div class="post-metadata">

**Author:** ![Peter\_Kawa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/peter_kawa/32/173848_2.png) [@Peter\_Kawa](https://community.homey.app/u/Peter_Kawa)\
**Post date:** [January 29, 2022, 5:06pm UTC](https://community.homey.app/t/logging-to-spreadsheet-best-strategy/59288/4 "2022-01-29T17:06:49Z")

</div>

All NumVars are available in Insights

 ![Screenshot_20220129-175106_Chrome](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/d/9/d9942f054b0a0791a2427e6005dc7081156efa73.jpeg)  
So, if you somehow can create numeric data from Bool or String data, it’s a start.

---

<div class="post-metadata">

**Author:** ![Johan\_Karlsson](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/johan_karlsson/32/16493_2.png) [@Johan\_Karlsson](https://community.homey.app/u/Johan_Karlsson)\
**Post date:** [January 31, 2022, 11:50am UTC](https://community.homey.app/t/logging-to-spreadsheet-best-strategy/59288/5 "2022-01-31T11:50:31Z")

</div>

Thanks,

Should be able to do something with it…need to figure out how make it into something that makes sense though. Will dive a little deeper, again thanks!
