google spreadsheets

sheets

visually display status when looping through google sheets data

show a processing status in a cell when looping through rows in google sheets using google apps script.

sheets

google sheets custom functions for wannabe domain investors (like me)

a few of the custom functions being used in sheets, powered by google apps script.

sheets

format specific word inside a google sheet cell using apps script

format (bold) a single word or a group of words automatically in sheets, using google apps script.

sheets

send personalized appreciation certificate to employees

automatically customize an existing google slide certificate template with employee data in google sheets and share them using gmail.

data studio

building a data studio dashboard to track indian covid19 cases in realtime

revisiting the power of google sheet's native IMPORTHTML function along with some apps script magic to visualize covid19 cases in india using data studio.

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.

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.

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

autocomplete drop-down options from spreadsheet data

use spreadsheet data to autocomplete materialize css chips & select components using apps script.

calendar

github-like contributions heatmap, but for meetings

create a meetings heatmap dashboard view using google's calendar chart and apps script.

innovation

password protected web app

create your very own frontend dashboard that requires a passcode to login, using google sheets and apps script.

webhook

managing ghost's subscriber list

create webhooks to store, access & update ghost's subscriber list using google apps script.