# Log Data to Google Sheets **URL:** \ **Category:** Cloud\ **Tags:** argon\ **Created:** [February 6, 2020, 2:38am UTC](https://community.particle.io/t/log-data-to-google-sheets/54545 "2020-02-06T02:38:08Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Apeds](https://avatars.discourse-cdn.com/v4/letter/a/3da27b/32.png) [@Apeds](https://community.particle.io/u/Apeds)\ **Post date:** [February 6, 2020, 2:38am UTC](https://community.particle.io/t/log-data-to-google-sheets/54545/1 "2020-02-06T02:38:09Z")
All, So I am trying to interface a couple of temperature and humidity sensors. I can read the value of the sensors every 3 minutes. I created particle variables to push those values to the cloud. I am also publishing the values to the clouds. I can see the sensor readings on particle cloud as expected. I am trying to achieve the following: 1.) Log the data in google spreadsheets. I have seen online tutorials explaining how to log to google drive. They use Javascript to read data from the cloud, that I manually need to add in a spreadhseet at the time of creation. However, I want to create a new spreadsheet every day at midnight. I am not sure how to do that automatically. 2.) I want to create a dashboard that displays several parameters and plots data. I am thinking to have a webpage (that can be easily created with widgets) that can be accessed from anywhere. I do not want to pay for live dashboard services. 3.) I would ideally like to get SMS/text message or push notifications on cell phone; in case certain events were to happen. For example, temperature change above/below threshold. I appreciate your time and would appreciate for all suggestions and resources that you can provide. Thanks! ---
**Author:** ![Fragma](https://avatars.discourse-cdn.com/v4/letter/f/5fc32e/32.png) [@Fragma](https://community.particle.io/u/Fragma)\ **Post date:** [February 22, 2020, 11:11pm UTC](https://community.particle.io/t/log-data-to-google-sheets/54545/2 "2020-02-22T23:11:06Z")
1. Have you looked into IFTTT integrations? There are recipes to log published events to google drive. I’ve been using one of those but it won’t create a new sheet per day. It will create new sheets as needed, when the the main one fills up, which I believe is after 2000 entries. So you’ll end up with [Sheet Name], [Sheet Name] (1), [Sheet Name] (2), etc. I forget exactly how and the terminology but you can create a trigger on a sheet so when new data is added you can copy/move that data to your own sheets. So presumably you could programatically create a new sheet per day, move the IFTTT triggered data to that sheet and then the main sheet would never fill up. I’ve used something like that years ago before I discovered [Tinamous](http://www.tinamous.com/). 2. [Tinamous](http://www.tinamous.com/) integrates directly and can pull variables and/or listen to events. It’ll graph them, giving you a bunch of options, give you a dashboard, and even let you export your data to a spreadsheet (manually). One of the key features I like is that it can notify you if your device stops reporting or goes offline for a period of time you specify. 3. IFTTT is what I used for this but the IFTTT trigger is a bit slow for published events. If getting a message within about 15-30min is acceptable then just connect a Particle publish to an SMS or IFTTT push service. ---
**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/particle/original/3X/6/4/64635adccc35238caa19e9b553ec3e98b163d026.png) [@system](https://community.particle.io/u/system)\ **Post date:** [April 22, 2020, 11:11pm UTC](https://community.particle.io/t/log-data-to-google-sheets/54545/3 "2020-04-22T23:11:16Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.