AppsScriptPulse

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

Gym Attendance App built with Google App Script and React

Edward Meehan created a Gym Attendance web app using Google App Script and React that logs members attendance to be used for members and class metrics.

Source: Gym Attendance App built with Google App Script and React

Subscribe to Apps Script Pulse...