I did one of these threads several months ago, when the site was new, and thought now was a good time to do another.

Message me if you

  • Want to try installing Linux for the first time
  • Want to try Linux but don't want to install it
  • Have some Linux-related problem you want another pair of eyeballs on
  • Want to learn a programming language
  • Want to build a computer
  • Want tutoring in any of the above
  • Need help with any old technical problem

(also play Arma with me)

  • tofunaut [he/him]
    ·
    4 years ago

    I figured it out. I used some code from this project: https://spreadapi.com/ and figured out the quirks with google web apps. A big one was kinda dumb, you have to publish as a "New" version if you want you updated code to run, you can't just save your script in their web app.

    I haven't figured out the shared drive, but basically I think it'll end up being the shared sheet pointing to a sheet on my personal company drive.

    Anyway now I have sort of a REST api working with google sheets, which is very limited but good for non-techies who mostly just use spread sheets to format and sanitize a bunch of columns and rows to show to the boss.