AppsScriptPulse

Send SMS event updates or discount codes using Twilio from a Google Sheet

Whether it’s a dinner reservation confirmation, a discount code, or a status update via SMS; it’s handy to be able to use a Google Sheet as an interface where you enter desired phone numbers to text along with a unique message for each, especially if you need to concatenate or produce randomized data using formulas in a Sheet as the message.

In this article the author will walk you through how to use a Google Sheet to send text messages using Twilio’s free trial account (an online communications provider that offers texting, calling, etc).

Source: Send SMS event updates or discount codes using Twilio from a Google Sheet

BigQuery create partitioned table and load CSV with Apps Script

Work with partitioned table and upload a csv file in BigQuery with Apps Script.

BigQuery is the famous Google database to store huge amount of data and query them fastly. For a recent a project I had to use it for storing some logs so here the code used with Google Apps Script to create the table and load a csv file from Google Drive.

Source: BigQuery create partitioned table and load CSV with Apps Script

Geocoding With Google Sheets Custom Script

This post shows how easy it can be to geocode data using a custom script with google apps script in Google Sheets.

Source: Geocoding With Google Sheets Custom Script

Google Apps Script Course – Intro: 2D Array Data Transformation for Google Sheets – Yagisanatode

This course requires a rudimentary understanding of very basic Javascript concepts and of what an array is. Nevertheless, if you want to come in blind you should be able to pick things up with a bit of Googling.

One of the major regular tasks that Google Apps Scripts can do for Google Sheets is to automate the transformation of data from one state to another.

Sometimes this task can simply be accomplished by building dynamic templates using the vast functionality of Google Sheets. Other times automation via Google Apps Script is a better tool for the job.

Source: Google Apps Script Course – Intro: 2D Array Data Transformation for Google Sheets – Yagisanatode

Retrieving volunteer records by SQL with Google Apps Script in Google Spreadsheet

Recently, I am working for an NGO supporting those severe handicapped. This article documents how I retrieve target entries programmatically.

Source: Retrieving volunteer records by SQL with Google Apps Script in Google Spreadsheet

How to create an automated calendar with Google Apps Script with open source on top

Speaking at conferences can be hard. This tutorial aims to help you better manage the “administrative” of submitting to calls for proposals (CFPs) and speaking at conferences.

Get this single small script that does everything Zapier does and more.

Source: How to create an automated calendar with Google Apps Script with open source on top

Retrieve Rows from Google Spreadsheet with Google Apps Script

After answering 100’s of Google Apps Script questions, I realized how many projects people are working on that start with a Google Spreadsheet as a base. A lot of my existing examples involve using a Google Form to trigger scripts that do things to data being written to a spreadsheet, so I typically have to describe what to do using quick code snippets or links to other docs.

In this post, we look at the easiest way to retrieve all of the rows of data from a Google Spreadsheet using Google Apps Script.

Source: Retrieve Rows from Google Spreadsheet with Google Apps Script – Jeff Everhart

Building a shared password manager on Google Sheets

Password managers have become an inevitable part of our online lives. The only way not to reuse a password is to use a password manager. Sharing over LastPass needs the user to know the other person’s email address and the receiving person need to have a LastPass account and have it installed. While I am a strong advocate of using password managers, I understand that everyone in a team might not be comfortable in doing so.

If we can use a shared secret to encrypt the password and save the encrypted text in the sheet, anyone who is looking for that password can just decrypt it using the shared secret. But everyone need to have the encrypt-decrypt tools installed. This takes us back to the original problem – everyone need to have the password manager installed. What if we could do this in Google Sheets itself?

Source: Building a shared password manager on Google Sheets

Using React + Google Sheets as your CMS

I’ll start this tutorial by admitting you shouldn’t actually use Google Sheets as your CMS for a production level site or project. However…

By the end of this tutorial, you will be able to serve up any data from a Google Sheet into a real React app.

Source: Using React + Google Sheets as your CMS

Get The Last Response from a Google Form

Most of the time, when I write Google Scripts that address a Google Form, I almost always access the data through the spreadsheet of responses. But sometimes, getting back to the Form itself is necessary. In those cases, I use this code to access the final response. It’s not quite as simple as it seems.

The script below accesses the last response to a form, gets the email, timestamp, and answers and then adds them to a Google Sheet.

Source: Get The Last Response from a Google Form

Filling out your column data to match the number of columns in a range – Yagisanatode

Have you ever experienced the warning about “number of columns in the data does not match the number of columns in the range” when trying to set values or paste a range of values back into your Google Sheet with Google Apps Script?

Check out this post to see how this script can help you fill out your column data to match the number of columns in a range.

Source: Google Apps Script: Filling out your column data to match the number of columns in a range – Yagisanatode

The simplest OAuth2 server in 120 lines using Google Spreadsheet and Apps Script

oauth2

Explore how to setup your own OAuth2 server using Google Spreadsheet and App Script.

Source: The simplest oauth2 server in 120 lines : Google Spreadsheet and App Script

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

Are small errors like worldwide targeting draining your budget? This Google Ads script can help

The script emails you a customized report to flag issues with your chosen account settings, preventing potential Google Ads catastrophes.

[Editorial note: Google Ads script is a variant of Google Apps Script designed to let you control your Google Ads. Google Ads script uses it’s own online IDE but is similar in terms of being an authenticated environment and able to connect with other Google products as well as external data.]

Source: Are small errors like worldwide targeting draining your budget? This Google Ads script can help

Google Apps Script Physics Problem Database

Database

This post will be mostly about how to use GAS as a data-driven, responsive website, with the Physics Problem Database really just the example Andy Rundquist (@arundquist) put together to show things.

Source: Google Apps Script Physics Problem Database

Create a seat booking form with Google Forms, Google Sheets and Google Apps Script – Yagisanatode

In this tutorial, Yagisanatode (@LifeOfSpy) is going to build a simple seat booking Google Form that will contain a registeree’s name and the session that they wish to attend. Each time a registeree submits a request to book a seat for a session, that seat is taken from the list displaying only the remaining seats for that session for when the next user submits the form.

Source: Create a seat booking form with Google Forms, Google Sheets and Google Apps Script – Yagisanatode

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

Create a Branching Google Form – Teacher Tech

Alice Keeler’s architecture on designing your Google Forms to provide immediate feedback by utilizing branching options is fascinating and efficient.

Create multiple sections in your Form and add only one question per section that determines which section to jump to next. Answer correctly and the branching should take the student to the next question. Answer incorrectly and be taken to a section with a tutorial or hint and a chance to answer a new question.

Source: Fast: Create a Branching Google Form – Teacher Tech

Subscribe to Apps Script Pulse...