We’ve gone over the basics of App Maker, but now it’s time to explore the interface further. Alexandrina Garcia-Verdin goes over how to utilize and modify tools and widgets, in this episode of Sheets to Apps!
In my last post, I wrote about publishing device telemetry from Cloud IoT Core to Cloud SQL. The natural thing to want to do after this is to plot that data and I have found using Apps Script with Google Sheets to be a great way to get this working quickly.
In this post you’ll find some helpful advice on connecting to Google Cloud SQL server with Google Apps Script.
Coding Google Apps Script is easier than you think it is. Learning to code can increase your productivity significantly. One thing I frequently code is adding the same piece of information to multiple tabs in a spreadsheet…
This article presents the building blocks for performing the same action to each sheet in your workbook to eliminate time and mistakes.
This little tutorial is going to guide us through the steps that will allow us to work, push and pull Google Apps Script code from the online editor to Visual Studio Code.
Related to the clasp CLI from Google, this short guide gets you set up with clasp, installing an auto-completion library, and pushing a project from VS Code to your Apps Script project online.
It actually is really easy to add the Virtru SDK to your project, as I’ll demonstrate through the construction of a “Protect & Share” Google Docs add-on.
I’m not familiar with Virtru but in this post from Trevor Foskett (Senior Solutions Engineer at Virtru) shows how their product can easily be integrated into Google Docs as an add-on. You’ll hopefully find this post useful to find out about Virtru as well as how client side and server side processing can be handled using Google Apps Script.
I finished my free book on Apps Script by a long chapter about “Google Assistant with Apps Script”.
I’m often asked for resources to help people with getting started in Google Apps Script. Noted French computer scientist Jacques Chazarain has published a free ebook which looks like an ideal resource and is available in both French and English.
Google Apps Scripts are very powerful yet relatively unknown. In this post Fran Galarza shows us what we can do with them & IoT as a use case.
You could have a sensor regularly measuring the humidity of your garden’s soil and posting that value to your GAS (yes, you can make POST requests). Then your GAS could log that measurement in a Google Sheet and send you an email if the soil is too dry. It can even set an event in your calendar to remind you to water your garden.
I want to show you that Deep Convolutional Neural Nets are not nearly as intimidating as they sound. And I’ll prove it by showing you an implementation of one that I made in Google Sheets.
Take it off your weekly to-do list — learn how to automatically create a new tab, clear a designated range, and delete an old tab in Google Sheets.
