GreenFlux Blog GreenFlux Blog

Home Tags Series About
Home Tags Series About

Google Apps Script Series

14 posts in this series

Reddit API with OAuth2 using Google Apps Script

Reddit API with OAuth2 using Google Apps Script

A guide for Reddit OAuth2 flow and refresh token using Apps Script and Google Sheets

Apr 30, 2025 5 min read

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,...

reddit REST_API JavaScript google_apps_script OAuth2 google_sheets APIs social_media social_media_marketing
So you want to send JSON to a Google Apps Script Web App...

So you want to send JSON to a Google Apps Script Web App...

Dealing with 405 Method Not Allowed Errors and 302 Redirects

Apr 26, 2025 5 min read

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....

google_apps_script google_sheets JavaScript fetch CORS http REST_API json automation
Replacing Google Forms with CloudFlare Pages & Apps Script

Replacing Google Forms with CloudFlare Pages & Apps Script

Building a free web site contact form with no Google branding

Mar 22, 2025 5 min read

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...

google_apps_script google_sheets google_forms cloudflare GitHubPages Small_business
Anti-Spam Agent: OpenAI Assistant Email Filter Using Google Apps Script

Anti-Spam Agent: OpenAI Assistant Email Filter Using Google Apps Script

A Timer-driven Inbox Defender Against Spam

Feb 08, 2025 5 min read

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...

google_apps_script openai agentic_AI spam gmail REST_API JavaScript
Export & Sync All Images from a Google Doc to Drive Folder using Apps Script

Export & Sync All Images from a Google Doc to Drive Folder using Apps Script

Easily extract all images from a doc and sync with matching folder

Feb 03, 2025 5 min read

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...

google_apps_script Google JavaScript Google_Docs Google_Drive Low_Code
Building A Data-Driven Organizational Chart In Apps Script

Building A Data-Driven Organizational Chart In Apps Script

Using OrgChart JavaScript Library In A Web App

Oct 05, 2024 5 min read

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...

google_sheets google_apps_script JavaScript Open_Source Web_Development
Talk To Your SpreadSheet:  Apps Script + Cohere AI

Talk To Your SpreadSheet: Apps Script + Cohere AI

ChatGPT Clone In Google Sheets

Sep 06, 2024 5 min read

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...

llm AI Google google_apps_script cohereAI cohere_
Building an Interactive XY Image Plot with Google Apps Script and Leaflet.js

Building an Interactive XY Image Plot with Google Apps Script and Leaflet.js

Custom Background Image With Markers Plotted From Sheets Data

Sep 03, 2024 5 min read

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...

google_apps_script leaflet Mapping google_sheets JavaScript
Generating Heatmaps in Google Sheets using Apps Script and ECharts

Generating Heatmaps in Google Sheets using Apps Script and ECharts

Interactive Heatmap in under 100 lines of code!

Aug 27, 2024 5 min read

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...

echarts heatmap google_apps_script google_sheets JavaScript
Creating a Google Sheets Sidebar with MermaidJS Charts

Creating a Google Sheets Sidebar with MermaidJS Charts

Aug 25, 2024 5 min read

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...

MermaidJS google_sheets google_apps_script JavaScript DataVisualization
Extract Images from a Google Doc and Save to Drive Folder

Extract Images from a Google Doc and Save to Drive Folder

Jun 10, 2023 5 min read

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...

google_apps_script Google_Drive Google_Docs
Saving Files to Google Drive by POST-ing the Url to a Web App

Saving Files to Google Drive by POST-ing the Url to a Web App

Jul 25, 2021 5 min read

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...

Google google_cloud JavaScript Tutorial APIs
Adding Gmail Contacts to Appsmith using Apps Script

Adding Gmail Contacts to Appsmith using Apps Script

Publishing script as a web app to serve as API endpoint

Jul 13, 2021 5 min read

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...

JavaScript Google APIs REST_API Tutorial
Creating a Scheduled Backup Service for Google Sheets using Apps Script.

Creating a Scheduled Backup Service for Google Sheets using Apps Script.

Beginner Apps Script tutorial

Jul 09, 2021 5 min read

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...

google_sheets JavaScript Tutorial Google

© 2025 GreenFlux, LLC.

RSS Feed