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:
- Check your existing Google Sheets projects. If there are any projects that are no longer needed, please delete or deactivate them.
- 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.