After a fight with wordpress, I said to myself: Can I use google doc as content management? .. Join me in this attempt
A simple yet elegant approach to using Google Docs to manage structured content using Google Apps Script.
My small team relies on automation to make things run. Part of our PD process is a Google Form workflow that kicks off calendar events, document creation, and email notifications. Since we’ve moved to online learning, we wanted to update that process to automatically add a Google Meet link for any PD that doesn’t have to be in person.
There are some official Google guides that show how to attach a Meet event to the Calendar, but nothing from the perspective of Apps Script specifically, so that’s what is shown here.
I like shortcuts! I’m in constant search of what I deem to be the most simple, efficient and effective shortcuts. I consider any tool, system or methodology which helps me streamline workflow and save precious time a shortcut. When I believe I’ve discovered (or perhaps created) a shortcut, especially a G Suite shortcut, I like to share that shortcut with others.
One popular method to get your students to learn is to categorise things or to put them in order. Here, we’re going to look at making a card sorting game, which could be used for both.
Apps Script now supports the V8 runtime. Time for an update to the story “Structure and simplify your Google Apps Script Apps script”. The V8 runtime brings modern ECMAScript syntax to Apps Script. So we can now use arrow functions and destructuring assignments. No more hoisting with let and const and my personal favorite, template literals.
In this story Jasper Duizendstra shows the added value of the changes made in the constructor pattern using the factory functions. It also shows how to implement chaining and a builder pattern in Apps Script.
Building up a solid link profile is a cornerstone of local SEO, but it can be a time consuming and tedious process. In this post I’ll show you how to automate this quickly and efficiently with Google Sheets.
This Google Sheets tool uses Apps Scripting to combine the Google Maps and Mozscape APIs into an all-in-one link finder. Type in a search term and a lat/long, and the tool will find the top Google maps results. Once we have those results, we can discover who is linking to them, and produce a “link intersect” report.
I recently sent an email where I typed code inline in the message body. I spent a good 15 minutes going through and formatting each line of code to look like, well, code. I wanted an extension like Code Blocks that would instantly format my text to a specific preset style.
A well chronicled article by Kelsey Kripp on how to dive right into Apps Script for G Suite to build your own Gmail add on!
As of writing Google App Scripts and functions in the code.gs documents use the V8 Runtime which generally supports ES6 syntax. This wasn’t true historically, and Google Scripts was limited ES5 syntax. This was a significant limitation. You’ll likely still find a lot of tutorials for Google App Scripts using ES5 and related workarounds, keep in mind there may be more modern ways to do the same thing now.
If your teams are using G Suite tools and Airtable, the building blocks to build secure and operational web application prototypes may be closer than you think. This article shows you how to get started and offer tips along the way.
All through the day, I want call reminders for specific events 10 mins before the meeting time, so I can leave my current meeting with out a hitch and go for the next one. So I used 3 tools for this: Google Calendar to fetch meeting times, Google Calendar to fetch meetings. Twilio to make calls. And finally Google Apps Script to put it altogether.
An interesting implementation by Urwa Shabir on managing meeting schedule using Twilio, Google Calendar and Apps Script.
Google Classroom has become one of the darlings of the teaching world that has come out of this crisis. Its shallow learning curve and attractive UI made it an obvious choice for most educators. Oh, and I am sure the fact that it is free helped too.
One of the limitations is that you cannot simply upload grades from, say Google Sheets or another assessment tool. Well…not directly in the Google Classroom platform, yet.
This tutorial runs through the basics of uploading grades from Google Sheets into Google Classroom using Google Apps Script with the Classroom API.
Some time ago, I had a request from one of my colleagues to help automate a rather repetitive and might I add, highly prone to error, process. One of the clients required her to fill in the same form several times in a day, manually, and then send it back for approval and signing. Of course, I’m simplifying a bit but that was what it was in essence.
In this detailed post, Neha demonstrates how to use Google Forms to generate professional looking PDFs from the data submitted via the form, using Google Sheets and Apps Script.
After a while, writing code becomes less about knowing all of the specifics of a language, framework, or platform, but more about being able to match patterns. After seeing a sufficient number of different problems, you get better at saying, “Hey, this bit of problem X seems a lot like this part of problem Y, maybe we could use that.”
In this post, learn about the Delegation Pattern that describes an object whose role it is to accept requests, delegate those responses to other objects, then return the responses to the original caller.
In our foreign language classes, one of the classic activities we do to help students learn new language, is to print phrases onto card, then cut the cards up. We then write the answers on the back of the cards. They then place the cards on a desk and then go through the cards one by one, trying to remember the correct answer.
Here we’re going to make a simple ladder card game using Apps Script and Google Sheets.
If you had used the GUI to manage your custom formulas used for conditional formatting, then to see and manage that logic, you would have to find and select the correct cell, or select the entire spreadsheet, and then right click and select “Conditional Formatting”, or go to the menu and select “Format -> Conditional Formatting”, to actually see and edit that logic. Which can be quite inconvenient at times.
Set conditional formatting rules through your script, which would allow you to keep everything configured in a single script.
Use a Google Group to work cross-functionally with vendors, partners, customers, and volunteers outside of your domain, and scale access to work assignments and leverage security controls.
Share documents, events, and communications with users outside (or inside) your G Suite domain.
Make your own YouTube uploader form and let anyone upload videos of any size to your YouTube channel. The uploader can send videos even anonymously without a Google account.
It is easy to upload videos to your own YouTube channel but there’s one limitation. Only the owner of the channel can upload videos to their YouTube account and they cannot delegate the task to someone else in the team.
Google Drive has the concept of shared folders. A folder can have multiple collaborators and anyone can upload files to that folder. Wouldn’t it be useful if such a feature were available for YouTube channels as well? You maintain a single YouTube account and multiple people can upload videos to your common account without the owner having to share their Google account credentials with anyone.
A post dedicated to devs and highlighting the power of the Slides API.
Use Google Apps Script and the Google Slides API to create a card game like Dobble.
App Script comes with a JDBC Service that lets you connect to MySQL, Microsoft SQL Server, and Oracle databases.
With Google App Scripts, SMS Gateway and CRM APIs we managed to come up with a solution that made a rewards awarding mechanism for the riders. Once a Rider completes a Delivery they are getting rewards and rewards are mapped through the Leads in CRM solution.
While no Apps Script code is included, it’s a useful usecase of how Apps Script is helping businesses deliver.
Google Calendar provides a facility to create multiple calendars in order to keep different kind of events tidy. It also let’s us colorize them, but in the addition to that, you can also colorize different events in a single calendar!
Automatically colorize your calendar events using the power of Google Calendar and Google Apps Script platform.