Any current & easy way to send Hubitat Data to Google Sheets?

[calinatl]

As posted last July (and a few years prior to that) I REALLY want to collect long term data from two of my devices and be able to log them in Google Sheets. I tried numerous methods in the past that were unsuccessful as I'm not a programmer.

With all the new capabilities of Hubitat in the last year, I'm posting again to find out if there is some easy way to do this, or if someone has even written an app for this that I've missed.

Any suggestions?

[Sebastien]

Yes, it can be done by using Rule Machine. I have a spreadsheet that I use to track my power production (solar), usage for home and for my EV. It sends data to a Google Sheet every 30 minutes. Works well, though the spreadsheet is getting rather large…

See posts below:

HOWTO Add rows directly to Google Sheets

My use case is to share a record of when people unlock our front door with the rest of my family. Here's how I configured Rule Machine to log directly to Google Sheets without any other services involved. Hope it's useful, the other solutions I found involved third party services like IFFT and such, this is direct and fast. First, create a new sheet and create a form with short answer texts. [Screen Shot 2021-06-02 at 1.43.37 PM] Second, click the edit button when looking at the form, clic…

[Rxich]

Search for "Hubitat Logs" app not directly to Google sheets, but it does keep a long term log, which is easily exported

[calinatl]

Thanks. Looks like that requires manual exporting. Please tell me If I got that wrong.
I'd rather it just update itself in Google Sheets and show me the graph...

[Rxich]

Yes, manual export.

Maybe this ?? Haha That was you too ! Oops

Send data from Hubitat to Google Sheets?

Is anyone currently successfully sending data directly from Hubitat to Google Sheets without going through HA, influx/grafana or some other program, and if so, can you please share how you are doing it? I tried to follow the directions at the various links on the below post, but I think Google may have changed something, and I don't have enough knowledge to get this to work without some additional directions.

[marktheknife]

@calinatl

With all the new capabilities of Hubitat in the last year

It sounds like you’ve been having trouble implementing on the Google Sheets end of things.

Any solution (new or old) is likely to require some configuration from Google’s side.

[calinatl]

Yeah, at first I was hoping for an all Hubitat way - like a Hubitat app that does alot of the work for you. But then I decided to try to the Google method again. I detailed what I'm doing (or perhaps doing wrong) here:

HOWTO Add rows directly to Google Sheets

I have not yet gotten this working. However, in the hopes that someone who knows what they are doing can help, I wrote up a step by step set of directions, inferring what I could from @JMac original post, and @mjd1953 updates. I had to infer, because the Google interface has changed somewhat. Can anyone PLEASE tell me what I've done wrong? Create a new Google sheet and name the sheet Select Tools/ Create a new form.The form will open with the same name as the spreadsheet. Enter the form fie…

Suggestions and corrections welcome.

[CuriousB]

I have an energy log file (text file) in Hubitat that gets a new record at 11:59:55 each day with the energy usage for that day, date and time (see below). I formatted the new record with comma delimiters in my rule (RM) for later csv parsing. I just upload it to my PC and import it to excel as a csv file. Not completely seamless but easy enough for me.

This is the Energy Log File first created on 6/04/2026

2026-06-04, 11:59 PM, 43.5, kWh,
2026-06-05, 11:59 PM, 41.1, kWh,
2026-06-06, 11:59 PM, 59.4, kWh,
2026-06-07, 11:59 PM, 48.4, kWh,
2026-06-08, 11:59 PM, 46.9, kWh,
2026-06-09, 11:59 PM, 67.2, kWh,
2026-06-10, 11:59 PM, 64.1, kWh,
2026-06-11, 11:59 PM, 39.6, kWh,
2026-06-12, 11:59 PM, 44.7, kWh,
2026-06-13, 11:59 PM, 46.9, kWh,
2026-06-14, 11:59 PM, 25.8, kWh,
2026-06-15, 11:59 PM, 27.1, kWh,
2026-06-16, 11:59 PM, 22.6, kWh,
2026-06-17, 11:59 PM, 25.8, kWh,
...