In this article the author elaborates on how to create a basic interface using a standalone Apps Script (based on JavaScript and HTML) in order to collect phone numbers on your website, email signature, or wherever you can embed a URL of this web app and have the phone numbers input, delivered to your Google Sheet.
Source: Create an Apps Script web app to collect phone numbers to text message customers updates 📟
Although Google Sheets has more than 400+ built-in functions, I love to show folks how you can create custom functions that you can write for custom problems.
Source: Auto-calculate rooms needed for a conference in a Google Sheet via an Apps Script
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
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
This post shows how easy it can be to geocode data using a custom script with google apps script in Google Sheets.
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
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
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
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
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?
