#apps script
A deep dive into Apps Script CacheService limits. I verify key/value constraints and uncover the undocumented FIFO batch eviction policy at the 1000-item limit.
A comprehensive deep-dive into UrlFetchApp. Covers architecture, authentication, web scraping, and debugging notorious infrastructure errors (Address Unavailable, 60s timeout, Gzip truncation).
Do not hardcode secrets in Google Apps Script. Use Properties Service or Google Cloud Secret Manager.
Securing Gmail AI agents against Prompt Injection and untrusted content using Google Cloud Model Armor.
Recently I had to clarify some confusion around the title and name of a Google Form. Here is a quick explanation of the difference between the two.
Learn how to programmatically convert, open, and edit Microsoft Word .docx files using Google Apps Script and the Drive API.
Save the date for the Google Workspace Developer Summits in 2024! Boston - September 12, 2024 and Berlin - September 17, 2024.
You can use WebAssembly with Google Apps Script! This post will cover how to do that and provide a comprehensive guide on how to get started.
Learn about the different options for making API calls in Google Apps Script web apps: `google.script.run` and GET/POST endpoints (`doGet` and `doPost`). Understand their strengths and weaknesses to choose the best approach for your project.
Working with binary files like PDFs or images in Google Drive with Google Apps Script can be a bit tricky due to scopes. Here is a comparison of the three main ways to get the Blob of a file in Google Drive and the scopes required.
A comparison of key-value store options in Google Apps Script, including PropertiesService, CacheService, Firestore, and Sheet Developer Metadata.
Ping results to Google Cloud regions and short code snippet demonstrating how to measure latency from Google Apps Script.
A comparison of the WinterCG Minimum Common Web Platform API draft with the Apps Script V8 runtime.
I will be giving a talk at Google Next 2024 on how to use Rust, Python and WASM to extend Google Apps Script.
Google Apps Script is based on the V8 engine and supports the use of Promises, async and await. However, there are almost no APIs available that are asynchronous except for the WebAssembly API.
Firestore can be a powerful tool when using Apps Script. This post shows how to use the [Firestore REST API] in Apps Script.
Avoid downloading private service account keys by using impersonation in Apps Script to obtain access tokens.
A short code snippet demonstrating how to generate text with the Gemini Pro Rest API in Apps Script.
A generic Apps Script memoization function can be written to cache any function.
How to use the Vertex AI API in Apps Script to make predictions on your data or use it in any of your other Google Workspace processes.
Both Add-on types have their own strengths and weaknesses. Combining them could be a powerful way to build Add-ons for Google Workspace but with some caveats.
Using Google Apps Script as part of my open source workflow.
Archiving emails older than 30 days automatically.