Spreadsheet readrange than addrow

[ABG]

I recently posted a tutorial on this at

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…

For more Sheets samples, see

FAQ Section: Google Sheets

Starter Guides Download a Google Sheet as CSV for the Media Folder and load it at startup - ABG AI2 Google Sheets Component AI2 Spreadsheet component help page - MIT Creating a Credential for Google Sheets - @Gordon_Lu Google link to service account creation May 2023 Peek inside a Service Account .json file - ABG Error reading credentials from stream, 'type' field no specified How To HowTO: Log DateTime Values - PU discussions HOWTO: Get A Range from a Google Sheet - TimAI2 (Also see Web…