Suppose you’re a school teacher and you’re planning an upcoming Parent-Teacher conference. Instead of using a printed sign up sheet, you decide to use a Google Sheets spreadsheet where parents can sign up for a meeting slot.
In the past you’ve had parents forget which slot they signed up for so you’re hoping that a shared Google Sheet that they can access at any time will help solve this problem. You also want to receive an email notification whenever a parent signs up for a slot. This will help you keep track of who hasn’t signed up yet so you can remind them when they drop off or pick up their kids.
In this tutorial, I’ll show you how to send email notifications whenever a Google Sheets spreadsheet is edited. We’ll use Google Sheets and some Google Apps Script code to create this “application”.
"email@example.com" + "," + "firstname.lastname@example.org";
The next step is to think about how this information can be made clearer, possibly listing the specific changes, rather than just highlighting the particular school updated.
Using this script, I was able to create a start. I think that the things that I still wonder:
- Insert an image from URL
- Adjust the size of the text based on the length of the text in the spreadsheet
- Replacing/updating the current slides in the deck
This is at least a start.
via Alan Levine
Google Sheets is great for quickly spinning up dashboards and analysis, but getting raw data into Sheets from databases can be tedious.
In this post we cover a few ways to get data from your SQL database into Google Sheets.
Recently I had the opportunity to be interviewed with some of my fellow G Suite GDEs for a Google Apps Script marketing video that is being pulled together by Google. The final video is still in production and I look forward to seeing the results. Over the years I’ve either produced or appeared in a number of videos and the recording session for this video was definitely on a new level. Before the recording session I was given the questions I would be asked so that I could prepare some thoughts.
Apps Script Pulse is a new space to keep up-to-date with the latest contributions from the Google Apps Script community. Pulse is designed to compliment other community spaces – with the Apps Script Stack Overflow site supporting Q&A, the Apps Script Google Groupproviding a discussion space and the new G Suite Solutions Gallery providing a space for sample solutions – Apps Script Pulse is a distribution channel for community created content as well as surfacing highlights from existing spaces.
You can visit Apps Script Pulse and start browsing the content we’ve already collected and if you’d like to receive updates in your inbox you can subscribe to our daily digest of new posts. If you have content you would like featured in Apps Script Pulse you can ping us on Twitter @AppsScriptInfo or dropping us a line at email@example.com.
Apps Script samples for G Suite products. Contribute to gsuitedevs/apps-script-samples development by creating an account on GitHub.
Learn to do Automation with Apps Script in this premium, online video training course.
A free, introductory course teaching Google Apps Script from scratch
I have read a number of posts:
- Collins’ Beginner guide to APIs with Google Sheets & Google Apps Script
- Alice Keeler’s First Step – You Can Code Google Apps Script
- Jeff Everhart Add Custom Menus to Google Docs, Sheets & Forms
I look forward to this new offering. I always enjoy the way in which Collins’ breaks things down with his courses.
Totally Unscripted is a new Google Apps Script show organized by the community for the community. Each month members of the community will talk through some new developments in Google Apps Script as well as talking about a coding project or problem.