# Glide | Google Sheets 502 Errors? **URL:** \ **Category:** Ask for Help\ **Created:** [October 2, 2024, 6:09pm UTC](https://community.glideapps.com/t/glide-google-sheets-502-errors/76773 "2024-10-02T18:09:34Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Myles\_Chaput](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/myles_chaput/32/62176_2.png) [@Myles\_Chaput](https://community.glideapps.com/u/Myles_Chaput)\ **Post date:** [October 2, 2024, 6:09pm UTC](https://community.glideapps.com/t/glide-google-sheets-502-errors/76773/1 "2024-10-02T18:09:34Z")
Hey Everyone, I don’t use google sheets for my apps, but I do use it for mathematics to send to different endpoints. But for those that do use it as a database for your apps are you experiencing any issues? Since sept 23 I have been experiencing tons of 502 errors on automation platforms like [make.com](http://make.com) and zapier google has a issue tracker here, but its been more than a week of manual work arounds etc, and I wanted to see how widespread the issue is: Google - [Google Issue Tracker](https://issuetracker.google.com/u/1/issues/369670473) Zapier - [https://community.zapier.com/troubleshooting-99/google-sheets-integration-error-502-server-error-1-43266/index2.html](https://community.zapier.com/troubleshooting-99/google-sheets-integration-error-502-server-error-1-43266/index2.html) Make - [Hundreds of Google Sheets errors! - #13 by Jim\_Baxley - Features - Make Community](https://community.make.com/t/hundreds-of-google-sheets-errors/56547/13) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 3, 2024, 12:33am UTC](https://community.glideapps.com/t/glide-google-sheets-502-errors/76773/2 "2024-10-03T00:33:31Z")
This originates from Google. They have this hiccup once in a while, and it affects especially when I need to use the Search Rows module (which usually takes a bunch of time). ---
**Author:** ![Myles\_Chaput](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/myles_chaput/32/62176_2.png) [@Myles\_Chaput](https://community.glideapps.com/u/Myles_Chaput)\ **Post date:** [October 3, 2024, 9:17pm UTC](https://community.glideapps.com/t/glide-google-sheets-502-errors/76773/3 "2024-10-03T21:17:22Z")
I switched over all my make scenarios that were dependent on google sheets, to datastores instead. This was alot of work (maybe 12 hours) or so of crushing till 2 am. But the results are that my scenarios are WAY faster, there is less outsourcing and relying on services. and its just a cleaner interface. One draw back is that it uses more operations, I haven’t figured out how to batch insert into data stores, each line takes one operation… ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 4, 2024, 12:39am UTC](https://community.glideapps.com/t/glide-google-sheets-502-errors/76773/4 "2024-10-04T00:39:36Z")
Yeah seems like you have to iterate through the rows to add… I wonder if they will ever support a JSON array for example. ---
**Author:** ![Myles\_Chaput](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/myles_chaput/32/62176_2.png) [@Myles\_Chaput](https://community.glideapps.com/u/Myles_Chaput)\ **Post date:** [October 4, 2024, 1:41pm UTC](https://community.glideapps.com/t/glide-google-sheets-502-errors/76773/5 "2024-10-04T13:41:44Z")
On another note, do you know how to clear the value of a cell in a glide table from [make.com](http://make.com)? If I go to edit row and that value is currently “blank” it will leave it alone, but how to do i push a delete cell value from make? ---
**Author:** ![HeartwoodTreeCo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/heartwoodtreeco/32/8150_2.png) [@HeartwoodTreeCo](https://community.glideapps.com/u/HeartwoodTreeCo)\ **Post date:** [October 4, 2024, 2:03pm UTC](https://community.glideapps.com/t/glide-google-sheets-502-errors/76773/6 "2024-10-04T14:03:01Z")
> [@Myles\_Chaput](#): > > I switched over all my make scenarios that were dependent on google sheets, to datastores instead. I’ve been having the same issue - I assumed it was from some changes I made to Zaps, but nice to know that doesn’t seem to be the case! It is a bother. Could you give more detail or an example about switching to datastores? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 4, 2024, 2:09pm UTC](https://community.glideapps.com/t/glide-google-sheets-502-errors/76773/7 "2024-10-04T14:09:53Z")
Try using the null value, if I recall right. ---
**Author:** ![Myles\_Chaput](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/myles_chaput/32/62176_2.png) [@Myles\_Chaput](https://community.glideapps.com/u/Myles_Chaput)\ **Post date:** [October 4, 2024, 2:31pm UTC](https://community.glideapps.com/t/glide-google-sheets-502-errors/76773/8 "2024-10-04T14:31:54Z")
Yes, so I used the datastores as a “working table” which processes all the data and then deletes the dataset after processing. Zapier has tables that work similar, although I don’t use zapier, its too expensive, in my opinion [make.com](http://make.com) is superior for this purpose. One amazing thing about datastores in [make.com](http://make.com) is that it gives the rows a key as well, its much more robust than a google sheet row number in my opinion. I was just struggling with getting some complex formulas working inside the datastore, but I figured out some work arounds by doing the math directly inside [make.com](http://make.com) when I add the row, they have powerful in scenario capacity. ---
**Author:** ![Myles\_Chaput](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/myles_chaput/32/62176_2.png) [@Myles\_Chaput](https://community.glideapps.com/u/Myles_Chaput)\ **Post date:** [February 26, 2025, 10:39pm UTC](https://community.glideapps.com/t/glide-google-sheets-502-errors/76773/9 "2025-02-26T22:39:36Z")
Bringing this to the top again, as I can’t seem to delete cell contents from [make.com](http://make.com), I want to clear a value in a cell in the glide table. Can anyone have success doing this? EDIT SOLUTION: I figured it out, under text/binary functions, select emptystring (pink) that works!