Is there an easy way to have my Philips Hue export all its activity as a log to a Google Sheet? I looked on ifttt but all I could see were triggers for activating Hue lights based on certain criteria. Is there any easy way to get bulb on/off times logged to a Google Sheet?
How to send Philips Hue activity data to a Google Sheet
2.7k Views Asked by tomh At
1
There are 1 best solutions below
Related Questions in GOOGLE-SHEETS
- Ignore #VALUE! error in SORT function
- Count Unique Values Repeated Dates
- Skyscanner Flights API and Google script
- Not able to access spreadsheet using google spreadsheet API
- SPLIT using " " delimiter in Google Sheets won't always preserve period following number
- union data in multiple tabs
- Google sheers: On edit event trigger
- Conditionally formatting multiple rows with the same conditions
- Authentication Error while using google SpreadSheet API
- Javascript on Google Sheets - Get Column Number from Prompt Input
- Apps Script, Count BG Color function on conditionally formatted cells
- Unable to authenticate with Google through the Java SDK for reading spreadsheet data
- Edit a google spreadsheet using javascript/client side code
- Google Spreadsheets, match/lookup in ALL rows, except the current one
- Google apps script for Spreadsheet - russian symbol substitute as a question mark
Related Questions in PHILIPS-HUE
- Philips Hue - "method, PUT, not available for resource, /scenes" (Java SDK)
- Controlling JavaFX GUI from Other Methods?
- Recurring lights Auto-off after 'x' minutes
- SyntaxError: Unexpected token u in JSON at position 0 Nodejs hue api
- How to get XY value from ct in Philips Hue?
- Sending a PUT request with an arduino
- How do I convert an RGB value to a XY value for the Phillips Hue Bulb
- How do I send json to Philips-Hue from Mac Terminal
- Blinking my philips hue lights
- Phillips HUE SDK in Swift
- Samsung Smart TV App to use HUE as Ambilight
- Integrating Philips Hue with Home Assistant via Zigbee
- Ptyhon DTLS v1.2 handshake with PSK
- Activating a scene for a room or a zone using Philips Hue API V2
- Solve boost.asio certificate failed error -without- access to source code, to find out what information Philips Hue Bridge shares
Related Questions in IFTTT
- Why doesnt IFTTT like my RSS feed?
- Receive a web request with IFTTT
- How does "If This Then That" implement access to third party user accounts (so called "Channels")?
- How can I push messages from WhatsApp to Twitter automatically
- Python flask server won't receive anything when called from ifttt webhook
- How to use IFTTT and Plivo to automatically send sms?
- How to make local area network HTTP request from Google Assistant?
- IFTTT realtime api
- How to produce the right output of the special character, & in json?
- IFTTT and Google Sheets: onChange trigger e.changeType returns 'EDIT' instead of 'INSERT_ROW' on insert
- So i cant figure out how to send my GPS data to the IFTTT server
- Is it possible to pull a native image (instead of a link) in IFTTT using webhooks and JSON?
- Can I define custom ingredients for an IFTTT applet triggered by Webhook?
- How to make a web request to a public PHP url with IFTTT
- How does Google Assistant's integration with IFTTT work?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
You will need to create a script that can do this. First start by reading the Philips Hue API, and then the Google Script documentation. Philips Hue has the ability to output to a JSON. You can program your script detect changes in the JSON and do something as a result of that change, in your case create a new entry based on the change.
Hue API
https://developers.meethue.com/documentation/core-concepts
Google Script
https://developers.google.com/sheets/api/reference/rest/
GS JSON Import
https://medium.com/@paulgambill/how-to-import-json-data-into-google-spreadsheets-in-less-than-5-minutes-a3fede1a014a