Google Spreadsheet Plugin Version 0.1 - ALPHA

http://automagucally.weebly.com

Moderators: davka003, Telldus

Post Reply
KHolm
Posts: 163
Joined: Fri Mar 17, 2023 9:45 am

Google Spreadsheet Plugin Version 0.1 - ALPHA

Post by KHolm »

Hi,

A first experimental version of a Google Spreadsheet plugin is now released in it's early stages. It has a dependency to an external plugin (gspread), so not very likely that it will be included in Automagically's main trunk.

It takes the following (self-explanatory) settings:
googlespread.JPG
googlespread.JPG (21.19 KiB) Viewed 12270 times
It can successfully be used in combination with the Wireless Energy Meter Plugin Version 0.6 just provided in this post: http://www.telldus.com/forum/viewtopic. ... =15#p25178

Just add a transform as per below picture:
wem_to_googlespread.JPG
wem_to_googlespread.JPG (32.61 KiB) Viewed 12270 times
If you need a spreadsheet to work with, you can you can use this template:
https://docs.google.com/spreadsheet/ccc ... Gc&newcopy

Follow these steps after having updated to version 0.6 of the Wireless Energy Meter, as per instruction here: http://www.telldus.com/forum/viewtopic. ... =15#p25178

Code: Select all

$ sudo apt-get install wget
$ sudo apt-get install unzip
$ sudo pip install gspread
$ sudo service automagically stop
$ cd ~/downloads/
$ wget http://www.telldus.com/forum/download/file.php?id=439 -O googlespread.zip
$ unzip googlespread.zip
$ cp ~/download/googlespread.py ~/source/automagically/site/plugins/.
$ sudo service automagically start
The result will look like....(see next post, I'm limited to 3 attachements per post by forum admin).

Be careful with this, the data can quickly grow out of proportions and I don't know how Google Spreadsheet behaves.

Feel free to review the code and propose changes. For now, I'm satisfied with what it does; but someone else might want something more/something else.

Oh, by the way. Send "googlespread,addrow,Meaning,Of,Life,42" as a signal to try it out, before connecting it wo Wireless Energy Monitor. The more arguments in the list, the more will be written to the spreadsheet.

/Marcus
ps. The external plugin can be found here: https://github.com/burnash/gspread
Attachments
googlespread_ver_0.1.zip
(1.98 KiB) Downloaded 511 times
Last edited by KHolm on Tue Mar 04, 2014 10:09 pm, edited 1 time in total.
KHolm
Posts: 163
Joined: Fri Mar 17, 2023 9:45 am

Re: Google Spreadsheet Plugin Version 0.1 - ALPHA

Post by KHolm »

KHolm wrote: The result will look like....(see next post, I'm limited to 3 attachments per post by forum admin).
The next post with the screenshot from Google Spreadsheets:
google_automagically.JPG
google_automagically.JPG (49.6 KiB) Viewed 12269 times
/Marcus
Post Reply