AppsScriptPulse

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

Using Google Apps Script to capture who sends email from your delegated gmail account

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

Improving your omnichannel customer experience – personalised problem solving (custom Exotel workflows with Google Apps Script)

With everyone talking about omnichannel communication,
@schoraria911 tells you how you create a smooth information flow between your helpdesk and phone system (@Exotel) to ensure a seamless customer experience

Always nice to see other companies promote the use of Google Apps Script with their service. In this post regular Pulse contributor Sourabh Choraria demonstrates how Apps Script can be used to configure the Exotel communications service.

Source: Improving your omnichannel customer experience – personalised problem solving – Global

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