Google Chat Introducing 'Twitter for Google Chat' – a Chat app built using Apps Script Preview tweets and user data when sharing links, along with the ability to follow a specific user or like a particular tweet.
Connector Connecting 'Tweet counts' API to Data Studio using a Community Connector A community connector with overridable config parameters to track recent Twitter trends for a query.
Add-on Making of Webhooks for Sheets Workspace Add-on Behind the scenes look at what went into creating an Apps Script-native Add-on to generate Webhooks for Google Sheets.
Web App Unnest an object with array values using cartesian product Convert array values from the doGet & doPost event parameters into 2D array when writing them onto a Google Sheet.
Sheets Find precedents of cells with formulas in Google Sheets using Apps Script — Part 1 Enumerate a range in Google Sheets using Google Apps Script and use that to find precedents of cells that contain a formula.
OAuth2 Generate code verifier & challenge for OAuth2 with PKCE using Google Apps Script Here's how you can generate a cryptographically random code verifier, hash it using SHA256 & derive it's BASE64 encoded challenge in Google Apps Script.
Solutions 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.
Open-source Introducing validator.gs — an open-source library of string validation for Apps Script projects The distant cousin of the already existing validator.js npm module.
Videos Access Notion API with 'OAuth2 for Apps Script' library Insights from a first-time Apps Script OAuth2 library user when connecting to the Notion API.
Solutions Using UrlFetchApp.fetch vs. fetchAll in Google Apps Script Make multiple, asynchronous API calls simultaneously using UrlFetchApp.fetchAll in Apps Script.
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.
Add-on Count von Count — a Google Workspace Add-on built using Apps Script A global counter that summarises accessible stats about different Workspace services.
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.
Webhook Web captioner, webhooks and Google Apps Script Push data from Web Captioner to Google Sheets via webhooks built using Apps Script.
Talks [Talk # 4] Rapid prototyping Fail-fast while building business-first, zero-cost solutions with 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.
Talks [Talk # 2] Google Apps Script - an underdog within the dev ecosystem Understanding Google Apps Script, what can Apps Script be used as, exploring a few use-cases, live demo and finally some Q&A.
Firebase Integrate Google Sign-in using Firebase Auth on your Google Apps Script web app Bonus: We'll make use of Firebase's pre-built UI to authenticate users on our Google Apps Script web app.
Classroom Automating attendance recorder in Google Classroom using Apps Script Programatically create multiple questions in Google Classroom using Apps Script.
Data Studio Building a Data Studio dashboard to track Indian COVID-19 cases in realtime Revisiting the power of Google Sheet's native IMPORTHTML function along with some Apps Script magic to visualize COVID-19 cases in India using Data Studio.
Talks [Talk # 1] Simple Automations using Google Apps Script Getting started with Google Apps Script.
Calendar Trigger automated meeting invite reminders 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.
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.