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.”

MakeUseOf: 6 Google Spreadsheet Tricks That Are Easy to Learn and Remember

MakeUseOf: 6 Google Spreadsheet Tricks That Are Easy to Learn and Remember. “Google Sheets is a popular Microsoft Excel alternative. As with other Google tools, the Sheets is a core part of Google Drive. In this article, we have taken the liberty to dive deep and unearth a handful of super useful Google Sheets tricks that you may have never heard before.”