AppsScriptPulse

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...