script.gs

Talks

[Talk # 3] Only with Apps Script

Things that can be built only using Google Apps Script.

Talks

[Talk # 2] Google Apps Script - an underdog within the dev ecosystem

Understanding Google Apps Script, what can Apps Script be used as, exploring a few use-cases, live demo and finally some Q&A.

Firebase

Integrate Google Sign-in using Firebase Auth on your Google Apps Script web app

Bonus: We'll make use of Firebase's pre-built UI to authenticate users on our Google Apps Script web app.

Classroom

Automating attendance recorder in Google Classroom using Apps Script

Programatically create multiple questions in Google Classroom using Apps Script.

Data Studio

Building a Data Studio dashboard to track Indian COVID-19 cases in realtime

Revisiting the power of Google Sheet's native IMPORTHTML function along with some Apps Script magic to visualize COVID-19 cases in India using Data Studio.

Talks

[Talk # 1] Simple Automations using Google Apps Script

Getting started with Google Apps Script.

Calendar

Trigger automated meeting invite reminders using Apps Script

Send a follow-up email to all undecided participants of a meeting that you've scheduled via Google Calendar using Apps Script.

Dialogflow

Conversational Stats - a way to talk to your data

Leverage the power of Dialogflow & connect your data sources with simple Apps Script functions to experience the next-gen approach towards consuming data and shaping insights.

Tips

Iterate ~80x faster through spreadsheet using map function in Apps Script

Use array map method instead of "for" loops to iterate faster through 2-dimensional spreadsheet data.

Add-on

Workbook Statistics - a Google Sheets Add-on built using Apps Script

Get stats for your current active sheet & the entire spreadsheet in one place using Workbook Statistics - A G Suite Editor Add-on built using Google Apps Script.

Firebase

Use Firebase Dynamic Links as a URL Shortener using Apps Script

Setup a Firebase account and configure a custom domain to use it as a URL Shortener service powered by Dynamic Links and Google Apps Script.

Sheets

Display user specific spreadsheet data on a Web App

Allow users to only view their data from a spreadsheet with the help of a Google Apps Script web app.

Ghost

Introducing "script.gs/new"

Building a redirect from 'script.gs/new' to create a new Apps Script project via user's own Google account.

Data Studio

Create a Google Data Studio Community Connector with "key" Auth type

An unofficial Google Data Studio open source Community Connector for visualising global stats of SendGrid user’s email statistics for a given date range.

Tips

Log and analyse your Google Apps Script execution stats

Capture, log and analyse Google Apps Script execution stats using REST APIs, Sheets and Data Studio.

Tips

How to use Google Apps Script REST API from browser editor

A quick tutorial on switching GCP projects, configuring OAuth consent screen and using Google Apps Script REST API from its browser editor.

Bot

Build a Telegram Bot using Apps Script

Launching SphygmoBot - a human "heartbeat" checker Telegram Bot that pings you every 24 hours to see if you're alive and notifies someone in case your response fails.

Web App

How to debug a web app deployed using Google Apps Script

A guide to test doGet and doPost functions, instead of deploying them over and again when any changes are made to the apps script.

Open-source

URL Shortener powered by Google Apps Script

Build a URL Shortening service powered by Google Apps Script and hosted using GitHub Pages.

Authy

Use Twilio's Authy with Google Apps Script web app

Make use of Twilio's TOTP and push authentications using Authy app and Apps Script for your web app.

Tips

Build a real-time dashboard (web app) using google.script.run API

Polling is bad, period. Falling short of integrating web sockets, this solution comes close to streaming live data.

Web App

Autocomplete drop-down options from spreadsheet data

Use spreadsheet data to autocomplete Materialize CSS chips & select components using Apps Script.

Calendar

Github-like contributions heat map, but for meetings

Create a meetings heat map dashboard view using Google's Calendar Chart and Apps Script.

Tips

Bypass script execution timeout, programmatically

Does your script exceed maximum execution time? Here's a solution to automatically bypass that.

Innovation

Password protected Web App

Create your very own frontend dashboard that requires a passcode to login, using Google Sheets and Apps Script.