any tutorial on how to use the component spreadsheet?

[Ollavo_Sousa]

insert data into google spreadsheet. I already know how to use the API. I'm in doubt on how to use the component's blocks.

[SteveJG]

Spreadsheet component. Example. Google Sheets

In order to utilize this component, one must first have a Google Developer Account. Then, one must create a new project under that Google Developer Account, enable the Google Sheets API on that project, and finally create a Service Account for the Sheets API. How to create the Service Account, here: http://ai2.appinventor.mit.edu.ezproxy.canberra.edu.au/reference/other/googlesheets-api-setup.html At the end of the whole process we will obtain a file of the form: app-inventor-338017-8c72fd465555.json We must upload…

[ABG]

Browse Google Sheets in YAML format

This tutorial is meant to show an alternative way to display wide table data in portrait mode. It uses YAML. YAML is a data serialization language that is often used for writing configuration files. Depending on whom you ask, YAML stands for yet another markup language or YAML ain't markup language (a recursive acronym), which emphasizes that YAML is for data, not documents. This tutorial is browse-oriented, and centers around a value procedure that can take a table (row of rows) with a heade…

Logging Marathon Runner Checkpoints in Google Sheets

This sample is intended to show how to use Google Sheets aggregation functions like MAXIFS to summarize multirow log data into single line summaries. This sample uses the New York City Marathon as a base, though it probably can't scale to the 53,000 runners. It is based on three sheets: Checkpoints, a list of locations each runner must cross on his route Mileposts, a detail list of runner checkpoint timestamps Runners, a master list of runners, with identifying bar codes and stats Checkpoin…