14 posts in this series
A guide for Reddit OAuth2 flow and refresh token using Apps Script and Google Sheets
Reddit offers several different options for integrating web apps, scripts, and installed apps. Just go to https://www.reddit.com/prefs/apps/ to create a new app and select the type. In this guide,...
Dealing with 405 Method Not Allowed Errors and 302 Redirects
Google Apps Scripts is incredible for a free product. There are so many things you can automate using script triggers and Google Sheets, Gmail, Docs, Calendar, and the rest of the Google ecosystem....
Building a free web site contact form with no Google branding
Google Forms is the most obvious choice when you need a simple public form to collect information into a spreadsheet. You can share a link to the form, or embed the form directly in your website. The...
A Timer-driven Inbox Defender Against Spam
I get a LOT of spam email that make it passed Google’s spam detection, and I’m constantly marking emails as spam and blocking senders. It’s a never-ending battle. Most of them end with something...
Easily extract all images from a doc and sync with matching folder
Adding images to a Google Doc is no problem, but getting them back out can be a pain. I’ve written about this before with Five Ways to Extract All Images From a Google Doc, and more recently, with...
Using OrgChart JavaScript Library In A Web App
Organizational charts help visualize the reporting structure of a company in a tree-like graph. They are usually created with a design tool, and lots of manual data entry. Then, every time an employee...
ChatGPT Clone In Google Sheets
AI can be a huge productivity boost, but it can also become a new bottleneck if it doesn't have existing access to your data. Bouncing back and forth between tabs and pasting sheets data into ChatGPT...
Custom Background Image With Markers Plotted From Sheets Data
Google Maps has a ton of features for plotting points on a map, but what if you want to plot points on an image? These XY Image Plot maps are commonly used for floor maps, job site inspections, and...
Interactive Heatmap in under 100 lines of code!
Heatmaps are a great way to visualize aggregate data so you can easily see trends and spikes in the data. They can summarize data across a range of time, display traffic and weather patterns, or any...
Adding custom chart types to Google Sheets using MermaidJS and Apps Script sidebars
Google Sheets has a ton of different chart types built-in, but there are a few types missing like Class, Sequence and Sankey diagrams, to name a few. When it comes to these types of charts, you...
Automate bulk image extraction from Google Docs using Apps Script
Recently, I needed to export all the images from a Google Doc and upload them to another service. Seems like a simple job, right? You would think... but not so much. Google Docs blocks the standard...
General purpose Apps Script web app for saving cloud-hosted files to Google Drive
In this tutorial, I'll be writing a general purpose Apps Script Web App to save a cloud-hosted file to Google Drive as a new file, when the original file url is POST-ed to the script's web app...
Publishing script as a web app to serve as API endpoint
I've been having a lot of fun building with Appsmith lately and wanted to do something with Google Contacts. It's easy to connect to a new API from Appsmith, but it's not so easy to enable the Google...
Beginner Apps Script tutorial
Apps Script is a powerful tool for automating routine tasks with Google Sheets, Docs, Gmail, and other Google services. On a recent job, I needed to create a daily backup of a Google Sheet for a...
