Skip to main content


Stores key-value pairs over a specified time period. To query stored values use TIMEQUERY. This function only stores data in memory. As soon as the app stops and restarts again the data collection starts over. To store data persistent use a Stream function connecting to a data base (e.g. TimescaleDB).


TIMESTORE(Json, [Period, TimeSerial, Limit])


JsonA JSON object which contains the key-value pairs to store.
PeriodOptional. The time period in seconds over which data is collected. Older data is dropped. Defaults to 60 seconds.
TimeSerialOptional. A serial number to use as key for each stored value. Note: data is always sorted according to its corresponding timestamp. Defaults to now.
LimitOptional. Specifies the maximum number of values stored. If limit is reached the function returns a #LIMIT error. Defaults to 1000.

Return Value

TRUE, if successful.

Example Sheet

1v1=A1 + 1
2v2=RANDBETWEEN(0, 100)


=TIMESTORE(JSON(A1:B2))Stores the values for v1 and v2 on each step.
=TIMESTORE(JSON(A1:B2), 100, , 10)Same as before but stores only over a period of 100 seconds and limits number of stored values to 10

Storing data from Berlin, Paris and London. Now a TIMEQUERY can be used to access the stored values