RPC:

uRPC micro Remote Procedure Calls - 0.97

» news | search | translate

calc
cipher
decipher
crc
email
geoloc
get_ip
get_time
get_uuid4
hash
hibp
is_code
is_email
kv
mp3_wav
mqtt
ping
qrcode
qrdecode
render
sheet
speak
translate

sheet

reads and writes data to a remote spreadsheet.
You have to create a spreadsheet on Google docs and share it with the uRPC account:
saltlake71@saltlake71.iam.gserviceaccount.com

Arguments:

input                 data values
algo                  clear | read | write
sheet_id              the id of the Google spreadsheet
range                 sheet!range; the name of the sheet is sometimes localized in your language
fmt                   input/output format: separator | json | msgpack | raw...

For testing you can omit sheet_id, this spreadsheet is used.
Input / output: 2D array. Each row is mapped to a row in the sheet.
See the documentation on data formats

Example:

http[s]://saltlake71.eu/urpc?function=sheet&algo=write&fmt=,&range=Sheet1!A1:C1&input=1,2,3