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

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

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

[Promo] Free book: “Introduction to Google Apps Script” – Google Groups

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.

Source: [Promo] Free book: “Introduction to Google Apps Script” – Google Groups

Building a Deep Neural Net In Google Sheets

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.

Source: Building a Deep Neural Net In Google Sheets

QUERYX allows you to use SQL queries in sheets

QUERYX allows you to use sql queries in sheets.

Those familiar with Google Sheets will probably want to know how this is different to the built-in QUERY() function, the answer is this is add-on enables a full SQL. Following the source link gives information on how to access this add-on.

Source: [PROMO] QUERYX allows you to use sql queries in sheets. – Google Groups

Goal Seek in Google Sheets – How To Use Goal Seek In Google Sheets

Learn how to use Goal Seek in Google Sheets. The Goal Seek feature enables you to change input values to make a formula result match the goal you specify.

We’ve highlighted the new Goal Seek Add-on previous in Pulse, but if you missed it or wanted to see some more practical use cases Ben Collins has expertly covered how to setup and use it.

Source: Goal Seek in Google Sheets – How To Use Goal Seek In Google Sheets

The classic Halloween dilemma: how to visit as many homes as possible solved by Eric Koleda with a little Apps Script

Subscribe to Apps Script Pulse...