Skip to content

Latest commit

 

History

History
108 lines (67 loc) · 3.87 KB

Gdrive.md

File metadata and controls

108 lines (67 loc) · 3.87 KB
title tags layout description excerpt
gdrive elements
Element
Network
WIP
page.njk
...
...

The gdrive elements enables communication with a Google Spreadsheets by using scripted services on the sheets...

Element Description
GDriveLog append data to a Google Spreadsheet
GDriveState save the latest data or status information in a Google Spreadsheet
GDriveAction read actions from a Google spreadsheet that will be executed on a device.
  • Https Get or post command to retrieve the next action from the sheet for a specific device.

Log data into spreadsheet

curl -L https://script.google.com/macros/s/AKfycbwFzGN7xwsATEigwcxOts63uYJWLVvmWyBI8sm0nU1FhoneTOi_JEu8MedJ2Ze_GFCmRw/exec?time=24.09.2024+07:08:09&device=devding&log=HelloFromCurl

text AKfycbymZ8-MO6uwv3TO-hMgMEK7jwHibLYl1QZXTYJ_iavFzksyTayD-6Wy0R34NzoWQx7YZA

guide

Head Links

// Head version (only in browser, not in CURL) https://script.google.com/macros/s/AKfycbyDoNBtRA2M6Qz70eqLA4U0859FZu2nNIS1bXIezoN1/dev

?device=devding&log=HelloCU

https://script.google.com/macros/s/AKfycbyDoNBtRA2M6Qz70eqLA4U0859FZu2nNIS1bXIezoN1/dev?device=devding/dht&data=12.5

Deployed Links

// a deployed version (anonymous, in browser and CURL) https://script.google.com/macros/s/AKfycbwezP1pKBKnRtC44_4uLVKMZIB68WH0NrN8ZcUrE2MPx3345XOJrZYt9IOyVt2s0ey5MA/exec

https://script.google.com/macros/s/AKfycbwezP1pKBKnRtC44_4uLVKMZIB68WH0NrN8ZcUrE2MPx3345XOJrZYt9IOyVt2s0ey5MA/exec?device=devding&log=HelloCU

https://script.google.com/macros/s/AKfycbwezP1pKBKnRtC44_4uLVKMZIB68WH0NrN8ZcUrE2MPx3345XOJrZYt9IOyVt2s0ey5MA/exec?device=devding/dht&data=12.7

To log any probe or status data values the gdrivelog element can be configured to send data over the network to a google spreadsheet.

On the device the gdrivelog element will receive values by actions from sensors or other elements. The timestamp for the data is automatically provided and the sensor type and local id can be given an an option or inside the action.

Element Configuration

  • sourceName -- //devicename/sourcename
  • url -- full qualified url including the ? for parameters
  • Same as log
  • retry

Google Sheet implementation and configuration

With some help of a embedded script the data will be added to the end of a table in the sheet by passing the given parameters and limitting the number of rows to avoid ever growing files.

These parameters can be canged in the script.

The sheet must be confirming to the following structure:

First line sets the names of the colums

  • ts -- the timestamp of the data.
  • id -- the full name of the device+sensor+localID using the format for addressing elements.
  • d -- the captured data.

Example URL:

ID, ts, data1, data2,...4 ?ts=20240201-12:54:30&id=//device/type/id&d=d1,d2,d3,d4

See Also

[[log]]

See also: