don't you have to code in a language accepted by android devices when you work with google sheets? I think I have them pre-installed on my phone, as I have a samsung android device. but no, I don't use them.
I posted this example because I thought it might be of interests to MS Access programmers. It shows you how to do a query on a Google sheet. I recommend you sign up to Ben's newsletter, there's always something interesting coming through and it's at a reasonable comprehension level "interesting"
Please note some of his articles are a bit dated and have been affected by Google's discontinuation policy eg.. scriptDB has been discontinued...
Bruce Mcpherson did have a nice forum running on G+ but again, Google G+ closed down and left him in the lurch. At the time I mentioned that I could talk to Jon about him moving his forum here, but he wasn't interested.... Shame really because I thought he could take advantage of the moderators expertise here to moderate the forum, prevent spamming and Jon would gain a nice future proofing section to the forum.
It was about this time I realised that Google was no different than Microsoft, or anyone else, and would just do what they liked. They didn't care about the individuals that created them... I mean, if you have a problem or a suggestion to posse to Google, you just try it, it's a brick wall! Absolutely disgusting.... Anyway I better get off my soapbox now!
I implemented the use of google forms with our Volunteer FD to input run information. That in turn is auto downloaded to Access and parsed, queried. No longer worried who did the run paperwork or if it was turned in, Now trying to upload it to ESO solutions for the National Fire Information tracking
So Google Sheets is for the ease for firefighters to enter calls
Access so I can track calls firefighter ran on (along with FD inventory)
ESO, for national tracking. This is my next step, to upload our info to their database. So far no authorization to them other than normal input line by line data entry.
That's cool Falcone203. The only significant work I've done with Google Sheets is for integration into AppSheet, which is a great mobile app building service. They aren't as "free" now as they were when I used them, but it's reasonable, and you can get quite a bit of mileage out of their free/almost-free categories of usage. They also integrate with SQL Server. No longer is a mobile developer required for relatively simple mobile apps.