tips | script.gs

get the redirect location of a url using google apps script

have a list of shortened urls and need their final destination? use this custom function in google sheets to extract them all at once.

make multiple, asynchronous api calls simultaneously using UrlFetchApp.fetchAll in apps script.

a global counter that summarises accessible stats about different workspace services.

programatically create multiple questions in google classroom using apps script.

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

use array map method instead of "for" loops to iterate faster through 2-dimensional spreadsheet data.

capture, log and analyse google apps script execution stats using rest apis, sheets and data studio.

a quick tutorial on switching gcp projects, configuring oauth consent screen and using google apps script rest api from it's browser editor.

a guide to test doGet and doPost functions, instead of deploying them over and again when any changes are made to the apps script.

polling is bad, period. falling short of integrating web sockets, this solution comes close to streaming live data.

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

does your script exceed maximum execution time? here's a solution to automatically bypass that.

using google apps scripts does not always mean that it would have something to do with google spreadsheets.