How to ensure complete data series in Google Sheets

With the Google Sheets actuator, users can easily track and archive all possible sensor readings by automatically writing them into a Google spreadsheet.

The respective actuator makes use of Google Sheets API. Please not that Google imposes a limit of 100 write requests per 100 seconds per user. Extending this limit will therefore result in incomplete data series.

The following measures help you stay within the said limits:

  1. Check your existing Google Sheets projects. If there are any projects that are no longer needed, please delete or deactivate them.
  2. Limit the execution frequency of the Google Sheets actuator in a meaningful way (e.g. only once per hour). Simply open your project in the editor, click on the actuator, then select the desired frequency limitation.
Limiting the execution frequency