# Failed to Access Spreadsheet

**URL:** <https://community.glideapps.com/t/failed-to-access-spreadsheet/5423>\
**Category:** Report a Bug\
**Created:** [March 14, 2020, 4:35pm UTC](https://community.glideapps.com/t/failed-to-access-spreadsheet/5423 "2020-03-14T16:35:00Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Todd\_Peterson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_peterson/32/4202_2.png) [@Todd\_Peterson](https://community.glideapps.com/u/Todd_Peterson)\
**Post date:** [March 14, 2020, 4:35pm UTC](https://community.glideapps.com/t/failed-to-access-spreadsheet/5423/1 "2020-03-14T16:35:00Z")

</div>

Got an email that my Time Card app couldn’t access the spreadsheet. Any new entries are not being added to the sheet. The app seems to be fine there are no errors. Any help would be appreciated. Thanks

---

<div class="post-metadata">

**Author:** ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)\
**Post date:** [March 14, 2020, 4:59pm UTC](https://community.glideapps.com/t/failed-to-access-spreadsheet/5423/2 "2020-03-14T16:59:11Z")

</div>

Have you tried to force a sheet refresh in the app builder?

---

<div class="post-metadata">

**Author:** ![Todd\_Peterson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_peterson/32/4202_2.png) [@Todd\_Peterson](https://community.glideapps.com/u/Todd_Peterson)\
**Post date:** [March 14, 2020, 5:17pm UTC](https://community.glideapps.com/t/failed-to-access-spreadsheet/5423/3 "2020-03-14T17:17:50Z")

</div>

Yes. No luck.

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [March 14, 2020, 5:36pm UTC](https://community.glideapps.com/t/failed-to-access-spreadsheet/5423/4 "2020-03-14T17:36:29Z")

</div>

Could you share your app, please?

---

<div class="post-metadata">

**Author:** ![Todd\_Peterson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_peterson/32/4202_2.png) [@Todd\_Peterson](https://community.glideapps.com/u/Todd_Peterson)\
**Post date:** [March 14, 2020, 6:01pm UTC](https://community.glideapps.com/t/failed-to-access-spreadsheet/5423/5 "2020-03-14T18:01:57Z")

</div>

[ebtl9.glideapp.io](http://ebtl9.glideapp.io)

Thanks,  
Todd

> **[Todd Peterson Heating & Cooling Inc - Home](https://www.toddpetersonheatingcooling.com)**
>
> Todd Peterson Heating & Cooling Inc - Home

![112BCCDE868E4EAB93A40E6767A6AB59.jpeg](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/fff675356c5c93981098769db2715efaec713625.jpeg)

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [March 14, 2020, 6:15pm UTC](https://community.glideapps.com/t/failed-to-access-spreadsheet/5423/6 "2020-03-14T18:15:51Z")

</div>

This looks like a transient error. We sometimes have trouble with the Google Sheets API. I reloaded manually now, so it should be up-to-date.

---

<div class="post-metadata">

**Author:** ![Mauronic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mauronic/32/21726_2.png) [@Mauronic](https://community.glideapps.com/u/Mauronic)\
**Post date:** [December 8, 2020, 1:27am UTC](https://community.glideapps.com/t/failed-to-access-spreadsheet/5423/7 "2020-12-08T01:27:19Z")

</div>

I received an email reporting this error when I woke up and but it was running. Not if, when or how long it was down which is unsettling.

@Mark do you know what would happen to my app if the API broke? I’d like my website monitoring software to log and report this.

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [December 8, 2020, 2:23am UTC](https://community.glideapps.com/t/failed-to-access-spreadsheet/5423/8 "2020-12-08T02:23:55Z")

</div>

If the Google API broke, which it does on occasion, the app would not be able to update the G-sheet, nor the info from the Google Sheet get back to the app. The notification you received was a result of Glide not being able to connect to the sheet. Glide automatically retries, which appears to be what happened with success.

I guess you could periodically utilize Google’s API to access the sheet via some custom code if you wanted to, as some kind of redundant process and report and log it in anyway you wanted.

---

<div class="post-metadata">

**Author:** ![Mauronic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mauronic/32/21726_2.png) [@Mauronic](https://community.glideapps.com/u/Mauronic)\
**Post date:** [December 8, 2020, 3:08am UTC](https://community.glideapps.com/t/failed-to-access-spreadsheet/5423/9 "2020-12-08T03:08:44Z")

</div>

Thanks @George_B , that’s helpful!

As a first step I am using an integromat scenario to kick off a slack alert to my #DevOps channel when your warning email is received.

If your email is within ~15-30 minutes of the incident, then that should be totally cool.

Hopefully this won’t happen frequently.
