Guest post by Thomas Coudray, Amaury de la Vieuville, and Ahmed Bougacha. Thomas, Amaury, and Ahmed attended the Google Apps Script Hackathon in Paris, and in this post they are sharing their creative use of Google Apps Script to render a 3D scene in a Google Spreadsheet
An old project but hopefully something nice to delve into for the weekend…
Simplify the process of producing visually rich mail merges using Gmail and combining it with data from Google Sheets. With this solution you can automatically populate an email template created as a Gmail draft with data from Google Sheets. Merged emails are sent from your Gmail account allowing you to respond to recipient replies.
A few months ago my team was challenged to digitize the work of the General Services Department in our offices. To improve the process we created a Google App Maker web-app designed to be used on Chromebooks in tablet mode. To track usage and movements, Cloud SQL stores data in tables: packages, movements/history and anomalies declared by teams. In order to retrieve the hexadecimal code of the badge, it’s really easy. A card reader behaves like a keyboard !
Have you ever created a Google Sheet projects where you could really use a select all checkbox (they call them ‘Tick-boxes’ in Google Sheets)? Sure you can copy a range of … Continue reading
Great post not only showing you how to make a ‘select all’ checkbox but you also get an in depth explanation of how this works. Once you fishish this post you might want to read this other Yagisanatode on How to check if there is a Tick Box (Check Box) in a cell or range
The usual list of links to interesting resources for Google Apps Script – contributorpw/google-apps-script-awesome-list
Alexander Ivanov has been curating this amzing list of Google Apps Script related resources for a number of years. The list includes links to a number of useful resources, cool Apps Script code projects, libraries and more. If you have a suggestion for the ‘awesome list’ you can open an issue ticket.
In this video tutorial, you’ll learn how to develop Google Apps Script projects locally on your computer inside Visual Studio Code. You can write your code in modern JavaScript, neatly organized in modules, and the build environment will use Babel and Webpack to transform your code into a version of JavaScript that is compatible with Apps Script.
Amit Agarwal has a great tutorial and boilerplate code for developers interested in locally Google Apps Script development.
make use of twilio’s totp [time based one time password] and push authentications using authy app and apps script for your web app.
In this example script from sourabh choraria you can find out how you can use Twilio’s Authy service with a Google Apps Script Web App. Authy allows you to implement time based one time password authentication for your web app removing the need for username/password management
Use Google Apps Script to get all the emails addresses of the members in a G Suite group, compare that against all the current members in the Calendar and add anyone who is missing
Google Apps Script, G Suite Admins, Google Calendar, Calendar API, AdminDirectory, GroupsApp Note! This article is for G Suite users and admins. You won’t be able to apply the same code to Consumer accounts. Google Groups in G Suite can be a really convenient and clean way to share users to drive folders and file locations, … Continue reading “Google Apps Script: How force subscribe Google Group Members to a Google Calendar for G Suite”
Jobs lets me set any tasks for Sheets: copy ranges, hide sheets, filter data, send emails.
Interesting script project from Max Makhrov for quickly creating automated Google Sheets tasks. The source code is available under a MIT licence and you can view/fork from Github.
