![]() ![]() These apps have helped me become more productive at work by automating manual tasks. Since then, I've built a fairly large number of "micro apps" using Apps Script and other G Suite products. I started learning Apps Script a few years ago because I wanted to automate a few reports tasks that I was putting together manually at that time. I'm a product manager, teacher and a self-taught programmer. Along the way, I will also teach you “the other things” that are important for building successful products. I’m not going to teach you every single coding concept but I'll teach you enough to build simple applications. I am going to teach you to code using Google Sheets and Apps Script. This scripting language is similar to JavaScript, but it has access to various Google services, such as Google Docs and Google Sheets.Learn coding using Google Sheets and Apps Script I ended up using Google Apps Script to create a fairly simple API for this task. ![]() I decided to look into how I could build my own Google Sheets API that my Ruby script could use, giving me a bit more flexibility for any other Ruby scripts I might create. I needed my script to see these notes and know not to overwrite these cells. Unfortunately, the gem I usually use did not support access to these notes. From time to time, I would have to manually edit the hours on the spreadsheet, so I left a note on those cells to remind myself that I changed the values. For a recent project, I wrote a Ruby script to upload my team’s hours to a Google Spreadsheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |