# Loss of messages between TTN and HTTP Google Sheet integration **URL:** \ **Category:** Application Development\ **Created:** [May 8, 2020, 7:52am UTC](https://www.thethingsnetwork.org/forum/t/loss-of-messages-between-ttn-and-http-google-sheet-integration/36834 "2020-05-08T07:52:41Z")\ **Posts on this page:** 1\ **Showing post:** 3
**Author:** ![arjanvanb](https://www.thethingsnetwork.org/forum/user_avatar/www.thethingsnetwork.org/arjanvanb/32/46626_2.png) [@arjanvanb](https://www.thethingsnetwork.org/forum/u/arjanvanb)\ **Post date:** [May 8, 2020, 8:54am UTC](https://www.thethingsnetwork.org/forum/t/loss-of-messages-between-ttn-and-http-google-sheet-integration/36834/3 "2020-05-08T08:54:29Z")
And apart from the abovementioned [TTN Fair Access Policy](https://www.thethingsnetwork.org/forum/t/limitations-data-rate-packet-size-30-seconds-uplink-and-10-messages-downlink-per-day-fair-access-policy-guidelines/1300) (and EU868 regional legal duty cycle limitations), you’re probably also running into problems with Google Sheets: - Your Apps Script is not using any lock to prevent concurrent access from overwriting data. - Your Apps Script is not telling you about any errors. - Aside: your script is using `SpreadsheetApp.openById` which is not needed nowadays, when creating the script through menu Tools, Script editor in Google Sheets. See [another script](https://github.com/avbentem/libelium-waspmote-lorawan/blob/master/src/google-sheets/README.md) as an example to handle that. That example will still not tell you about Google rate limiting, as when hitting that, Google returns 200 OK with a human-readable message, which is swallowed by the HTTP Integration. (Maybe Apps Script’s logging will tell you about that though.) But above all: don’t send that often. --- _[View the full topic](https://www.thethingsnetwork.org/forum/t/loss-of-messages-between-ttn-and-http-google-sheet-integration/36834)._