Amit Agarwal: Make your own Saregama Carvaan with YouTube and Google Sheets. “Saregama Carvaan, a digital music player that looks like an old-fashioned transistor radio and targets the non-millennial generation, has become a huge hit in India…. Like a radio station, Saregama Carvaan mixes nostalgia with an element of surprise – the player’s algorithm plays music in a random sequence so the listener would never know which song is coming up next. Can the Carvaan experience be recreated with YouTube? Let’s find out.”
MakeUseOf: How to Automate Repetitive Tasks in Google Sheets With Macros . “While Google Sheets has long allowed users to write their own Apps Script functions, macros open up this kind of functionality to all Google Sheets users—no coding experience required. Macros are particularly useful if you find yourself dealing with multiple sheets over and over with similar data or information. For instance, any kind of monthly trackers with elaborate functions to collate data will benefit from the of macros.”
HubSpot: 12 Google Sheets Add-Ons to Streamline Reporting. “Google Sheets can be used for a lot more than just storing and organizing your data. With the right add-ons, you can streamline your reporting process, collect big-picture data predictions and analysis, and even send emails — all from your spreadsheets.”
MakeUseOf: How to Use Google Sheets to Keep Every Part of Your Life Organized. “You don’t need shiny new apps and websites if you’re looking to get your life organized. All you need is the trusty spreadsheet. With Google Sheet’s sharing capabilities and some solid, easy-to-use templates, you can stay on top of your budget, schedule, to-do list, and more.”
Google Blog: Think macro: record actions in Google Sheets to skip repetitive work. “We’ve been focused on making Google Sheets better for businesses for this reason, which is why we’ve recently added new features to help teams analyze and visualize their data. Today we’re adding more updates to Sheets, including a way to record macros in the cloud to automate repetitive tasks, as well as more formatting options.”
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.