AppsScriptPulse

Make your own Google Hangouts Chat RSS bot

A simple Google Apps Script bot that fetches news from an RSS feed and posts them to a Hangouts Chat room. – thmslprt/hangouts-chat-rss-bot

This one comes via @dersteppen and is a nice little code project to show how you can send messages into Google Hangouts Chat using Google Apps Script. If you are looking for a more secure way of posting into Hangouts Chat the official docs include information on Async messages.

Source: thmslprt/hangouts-chat-rss-bot

Bulk Gmail Label Manager (made with Google Apps Script)

Use this spreadsheet to manage your Gmail labels in bulk! To get started, follow the steps below:

  1. Make a copy of this spreadsheet.
  2. Wait a few moments for the “Bulk Labels” menu to appear.
  3. Click “Bulk Labels > Pull labels”.
  4. When prompted, grant the script authorization to your account.

You can then use the spreadsheet to create, rename, and delete labels. You can also merge labels, which deletes a label but also moves all of it’s messages to another label.

When ready, click “Bulk Labels > Perform actions” to make the updates.

Google Apps Script — AirTable API – Urwa Shabir – Medium

Just putting it out there for some one who forgets syntax of RESTful API call in Google Apps Script.EVERY.SINGLE.TIME. This one is for AirTable API

I’ve not come across AirTable before but it looks like a nice service for creating database interfaces and in this post Urwa Shabir covers how you can access the AirTable API.

Source: Google Apps Script — AirTable API – Urwa Shabir – Medium

Full tour of Google App Maker’s interface | Sheets to Apps – YouTube

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!

Accessing Cloud SQL from AppsScript to plot data from IoT Core

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.

Source: Accessing Cloud SQL from AppsScript to plot data from IoT Core

Google Sheets: Code Adding Content to Multiple Tabs – Teacher Tech

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.

Source: Google Sheets: Code Adding Content to Multiple Tabs – Teacher Tech

Use Google Apps Script to Securely Share Google Docs

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.

Source: Use Google Apps Script to Securely Share Google Docs

Give your workday super-powers with Google Apps Script

The best learn-to-code projects are often those which solve a real world problem. – Peter Gleeson

Source: Give your workday super-powers with Google Apps Script

Google Apps Script & IoT

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.

Source: Google Apps Script & IoT

Google Script Automation: Create New Sheets Tabs Automatically

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.

Source: Google Script Automation: Create New Sheets Tabs Automatically

Subscribe to Apps Script Pulse...