Coding is Love: The complete guide to using Google sheets as database. “Let’s talk about the mighty Google sheets. Mighty? Yes! It is one the best spreadsheet apps on par with Microsoft Excel. Actually, Google sheets is better than Excel in few cases because of its features like Apps script, Timed triggers, Form triggers, Google sheets API, importXML etc. Let’s talk about different advanced features of Google sheets, its limitations, alternate solutions and how to use those features and how to use google sheets as database!” The English is not 100% perfect but there’s a lot of information here.
New-to-me, not sure how long it’s been around, not too much documentation here yet but the walkthrough looks easy enough: https://www.sheet2site.com/. From the front page: “Generate a website from Google Sheets. No coding necessary. Build a site with pictures, text and links. Update it instantly by editing your sheet.” I have not played with it yet.
Useful for a given value of useful, but hey, weekend! From Amit Agarwal, who has just been fire this week: How to Make Pixel Paintings with Google Spreadsheets. “If you would like to create your own spreadsheet art but don’t have the time to carefully paint every cell manually, here’s a simple workaround for you. You can take any photograph, vector art, or any other image and use a Google Script to convert that bitmap image into spreadsheet art.”
Yahoo Entertainment: A Bunch Of TV Writers Are Building A Salary Transparency Database. ” In the continued pursuit of transparency, a Google spreadsheet has been created for TV professionals like writers, assistants, producers, and script coordinators to anonymously enter details about their salaries so people can see what their colleagues are making. There are columns devoted to criteria such as gender, whether or not a contributor is a person of color, network, job title, salary, and more, and while the data is a little dense for those not in the industry, it offers an interesting look for the casual viewer at the pay hierarchy behind the shows they mainline. ” I tried to open this spreadsheet and was told I’d need to ask permission to access, so maybe it’s been changed since the story was written.
Make Tech Easier: How to Use Google Sheets: Key Tips to Get You Started . “Ever since Windows’ inception, Microsoft Excel has been the go-to program for number-crunching, spreadsheets, invoices, and all the other things in life that you want organized into infinite grids of rows and columns. But since the Cloud came to prominence, Google Sheets has become the program of choice for many people. It may not be as feature-rich as Excel, but there’s a lot more to it than first meets the eye.” Nice set of “anything you want to do on Google Sheets will be easier if you learn this” tips.
Google Apps Blog: Improved accessibility for Google Sheets, Slides, and Drawings. “We want to make sure our products work well for everyone. That’s why, as part of our ongoing accessibility initiatives, we’re launching new features for Google Sheets, Slides, and Drawings. Specifically, we’re adding Braille support in Google Sheets, and screen magnifier support in Google Slides and Drawings.”
IFTTT has made some updates to its Google Docs and Google Drive service. “Historically, Applets that interact with Google Sheets or Google Docs have fallen under the umbrella of Google Drive. Today, we’re excited to introduce new, separate services for Google Sheets and Google Docs — and some big improvements to the original Google Drive service.”