Digital Inspiration: How to Email Spreadsheets Automatically on a Recurring Schedule

Amit Agarwal strikes again! From Digital Inspiration: How to Email Spreadsheets Automatically on a Recurring Schedule. “Introducing Email Spreadsheets, a Google Sheets add-on that lets you automate the reporting of spreadsheet data and dashboards by email. If you are an office worker who has been emailing spreadsheets to colleagues manually, this add-on will save you a ton of time. And because it runs on the Google Cloud, your spreadsheet reports will be delivered even while you are offline or on vacation.”

In Development: A Google Spreadsheet of Alternative Bands and Musical Acts in Louisiana

In development: a Google Spreadsheet of alternative bands and musical artists in Louisiana. I know this seems like kind of an odd topic, but there are already over 250 bands listed. From the Welcome tab: “Here, you will find an up-to-date directory of alternative bands and artists in Louisiana, sorted by city. Please see the tabs at the bottom to see each city’s list, or view all bands at once in the ‘All’ tab.”

How-To Geek: How to Automate Google Sheets With Macros

How-To Geek: How to Automate Google Sheets With Macros. “When you record a macro in Google Sheets, it automatically creates an Apps Script with all the code to replicate your actions for you. This means you can create complex macros without knowing how to write code. The next time you run it, Sheets will do everything you did when you recorded the macro. Essentially, you’re teaching Google Sheets how to manipulate a document to your liking with a single command.”

The Verge: Google Docs, Sheets, and Slides can now be edited and shared within Dropbox

The Verge: Google Docs, Sheets, and Slides can now be edited and shared within Dropbox. “Dropbox Business now integrates directly with Google Docs, Sheets, and Slides within G-Suite, letting you create and collaborate on files directly from within the file-sharing service’s interface.”

OPEnS Hub: Real-time Data Logging, Connecting Field Sensors to Google Sheets (ScholarsArchive@OSU)

ScholarsArchive@OSU: OPEnS Hub: Real-time Data Logging, Connecting Field Sensors to Google Sheets. “In Earth science, we must often collect data from sensors installed in remote locations. Retrieving these data and storing them can be challenging. Present options include proprietary commercial dataloggers, communication devices, and protocols with rigid software and data structures that may require ongoing expenses. While there are open-source solutions that include telemetry, such as EnviroDIY’s Mayfly, none presently generate real-time, remotely accessible workbooks (EnviroDIY, 2018). The Openly Published Environmental Sensing (OPEnS) Lab developed the OPEnS Hub, a new approach to using low-power, open-source hardware and software to achieve real-time data logging from the field to the web.”

Lifehacker: How to Translate Languages With Google Sheets

Lifehacker: How to Translate Languages With Google Sheets. “There are more efficient ways of keeping track of important foreign language vocabulary than a hand-held dictionary. If you’re learning a new language or making basic translations, try using the Google Translate formula in Google Sheets for an easy access list of what you know—or want to know.”