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
- google sheets, search and replace for next colum
- AppScript to replace image in google slides
- Regex to match repeated substring in Google Sheets
- How to append row to specific columns with gspread?
- Find a value in a range of cells (multiple rows and columns)
- Create date column based on range
- Look up a value using month of the date
- Data recovery based on other data
- Gsheet - Automatically send an email using a date & time in a Cell
- google sheet script to convert the Scientific notation in the selected area to number
- How can I limit the number of dropdown entries in a column in Google Sheets
- Parse tag in html via Google Sheets (importxml)
- Why is the background color of my google sheet web app not being applied?
- Google Sheets script that automatically locks a sheet 24 hours after a cell is edited
- My Google Sheets formulas mysteriously break as time passes, fix themselves when refreshed
Related Questions in PHILIPS-HUE
- Philips Hue API is unable to detect lights and scenes
- How to manage Hue wall switch actions from API?
- How to disable Arduino WiFiNINA ssl certificate verification
- How to configure SSL certificates on Android App with Philips Hue Bridge for API calls?
- Activating a scene for a room or a zone using Philips Hue API V2
- Ptyhon DTLS v1.2 handshake with PSK
- Integrating Philips Hue with Home Assistant via Zigbee
- Triggering a Philips Hue button event by the Hue API
- Phillips hue color change during set time
- Make Requests to IP on Client's private network from the browser?
- philips hue "xy" color value to hex value in node.js
- Philips Hue API V2 - CORS Error "No 'Access-Control-Allow-Origin' header"
- Trust anchor for certification path not found Hue Certificate
- Change entertainment area via Hue Sync Box API
- How to fix Philips Hue API v2 404 Not Found Error
Related Questions in IFTTT
- IFTTT Applet for post linkedin share a link have a issue with image in linkedin post
- How to produce the right output of the special character, & in json?
- wrong notifications from my applet ( IFTTT ) (Python trading script)
- Trigger IFTTT event when GCalendar event is X days from due or when a notification is triggered
- reply markup Telegram in webhoock ifttt
- ifttt webhook returns 403 (it works with curl)
- AWS Lambda function in Step function returns "Runtime.HandlerNotFound"
- Passing values from Powershell using IFTTT Webhooks
- What is the fastest way to get my alexa to read a web page?
- Problem sending message with my ESP8266 using IFTTT
- How to use Crow on Raspberry Pi
- Google Assistance Web URL request and get speaker reply IFTTT?
- Adding javascript code instead of api endpoint for action in IFTTT service
- Can I define custom ingredients for an IFTTT applet triggered by Webhook?
- Get answer from local script
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 # Hahtags
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