AppsScriptPulse

Workbook Statistics – a Google Sheets Add-on built using Google Apps Script (lessons in Add-on publication)

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.

A handy Google Sheets add-on from Sourabh Choraria that can give you an Excel like summary of the Google Sheet you are working on that can display information like the number of: filled cells, formulas, charts and more. This post is also worth reading if you are interested in tips for the Add-on publication processes, highlighting some of the pitfalls you can avoid. The code for the Add-on is also open source making it possible to reuse in your own Apps Script projects.

Source: workbook statistics – a google sheets add-on built using apps script

Integrate Google sign-in using Firebase authentication on your Google Apps Script web app

make use of firebase’s pre-built ui to authenticate users on our google apps script web app

Sometimes with Google Apps Script web apps you need a way to authenticate the user whilst also publishing the web app to run under a specific account. Sourabh Choraria details how Firebase can be setup allowing you to authenticate users with their Google account.

Source: integrate google sign-in using firebase auth on your google apps script web app

Trigger automated meeting invite reminders using Google Apps Script

send a follow-up email to all undecided participants of a meeting that you’ve scheduled via google calendar using apps script.

here’s a piece of code that you could schedule for every morning (preferably before your official work hours start) to be triggered, such that the script could iterate through every single meeting event that you’ve scheduled (i.e. where you’re the “organiser”) for the day and send an email to all those invitees who’ve neither accepted nor declined (even excluding the maybe’d ones too) to said invites.

Nice post from Sourabh Choraria which covers interacting and using data from your Google Calendar.

Source: trigger automated meeting invite reminders using apps script

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.

Nice proof of concept from AppsScriptPulse Contributor (and now Editor :)
Sourabh Choraria of the results of a recent hackathon to use Google Sheets as a data source for a Dialogflow agent/bot.

Source: conversational stats – a way to talk to your data

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.

Sourabh Choraria shares his experience of using Array.map to find values in a Google Sheet and the performance benefit of using this approach.

Source: iterate ~80x faster through spreadsheet using map function in apps script

SphygmoBot – A Telegram human heartbeat bot built using Google 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.

Another really interesting post from Sourabh Choraria this time looking at making a Telegram bot using Google Apps Script. You can also find SphygmoBot on ProductHunt and also browse the source code on GitHub.

Source: build a telegram bot using apps script

Take Me There – URL Shortener powered by Google Apps Script | Product Hunt

This tool is a URL Shortening service powered by Google Apps Script and hosted using Github Pages.

Lovely little project from Sourabh Choraria which uses some contributions from the Apps Script community. The code for the ‘Take me There’ URL shortener is open source making it easy to deploy your own version. You can read about the development of this project including discovering issues with e.pathInfo in Sourabh’s blog post.

Source: Take Me There – URL Shortener powered by Google Apps Script | Product Hunt

use twilio’s authy with google apps script web app

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

Source: use twilio’s authy with google apps script web app

Subscribe to Apps Script Pulse...