AppsScriptPulse

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

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

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

How to design advanced Google App Maker apps with BigQuery API, Google Groups, Google Data Studio and Cloud SQL

Where should I store my data? Should I sync Cloud SQL and Big Query? How to publish my app,… Read on Jérémy Dessalines’s (@Gr3m) thoughts on working with App Maker.

Source: How to design advanced Google App Maker apps with BigQuery API, Google Groups, Google Data Studio and Cloud SQL

Send automatic FYI emails for Meeting Action Items

Now you can get the Action Items (AIs) delivered right to your inbox! Joanna Smith’s (@dontmesswithjo) custom solution to integrate Google Docs with Apps Script allows you to send everyone a personalized list of their AIs at the end of every meeting.

Source: Send automatic FYI emails for Meeting Action Items

How to use Google Spreadsheet as Admin Interface for your Firebase project

Manage, verify and approve transactions in your application using cloud functions and Google Apps Script.

Nice little tutorial showing two communication between Google Sheets and Firebase using Google Apps Script.

Source: How to use Google Spreadsheet as Admin Interface for your Firebase project

I created a Twitter Bot from nothing but a Google Sheet – And I Didn’t Even Know The Scripting Language…

… that job taught me two very important lessons: repetitive stuff needs to be automated; the best way to learn to code is with a tangible, objective problem that needs a solution. … It was then I decided to go all-out and make a Twitter Bot. Having no relevant experience or clue of what I was doing, my goal was simple: send a few tweets with relevant quotes, readings, and information for Orthodox Christians

Very detailed post from Peter Berthelsen on his journey from no-code to making a functional Twitter bot and if you keep reading to the end you’ll get a link to Peter’s follow-up post with a template and setup instructions. These posts are great examples of the empowerment Google Apps Script can give to people.

Source: I created a Twitter Bot from nothing but a Google Sheet

Using Apps Script, a Google Sheets Macro and Benford’s Law to Detect Potential Fraud – Laura Taylor

As one of the only technologists in a family of CPAs I’m always seeking ways to participate in the discussion. So when the topic of using Benford’s Law as a risk assessment tool recently surfaced in conversation I decided to develop a custom macro to automate the analysis inside Google Sheets.

Laura Taylor tackles an interesting topic is this post highlighting how Benford’s Law can be used to detect anomalies in data. Google Apps Script developers might also be interested in the way macros are introduced to the reader.

Source: Using Apps Script, a Google Sheets Macro and Benford’s Law to Detect Potential Fraud

Subscribe to Apps Script Pulse...