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

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

Subscribe to Apps Script Pulse...