Exploring Apps Script CacheService Limits
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.
About
I'm a Developer Relations Engineer at Google, focusing on Google Workspace. My work involves creating tools and supporting the open-source community.
Before Google, I had the opportunity to work with geospatial data at Descartes Labs and the US Geological Survey.
When I'm not coding, I'm usually running long distances in the mountains of Colorado.
Topics
Lead Story
Resolving Google Chat User IDs to Emails: The Least Privilege Way
| google chat, google workspace, service account, admin sdk, people api, service account impersonation, custom role, least privilege, directory api, domain wide delegation
A secure strategy to resolve Google Chat User IDs to email addresses without using Domain-Wide Delegation. By combining Direct Role Assignment with Service Account Impersonation, you can maintain Least Privilege security.
The Definitive Guide to UrlFetchApp in Google Apps Script
A comprehensive deep-dive into UrlFetchApp. Covers architecture, authentication, web scraping, and debugging notorious infrastructure errors (Address Unavailable, 60s timeout, Gzip truncation).
Secure Secrets in Google Apps Script
Do not hardcode secrets in Google Apps Script. Use Properties Service or Google Cloud Secret Manager.
Securing Gmail AI Agents against Prompt Injection with Model Armor
Securing Gmail AI agents against Prompt Injection and untrusted content using Google Cloud Model Armor.
Google Workspace Developer Tools MCP Server
Announcing the new MCP server for Google Workspace Developer Tools, providing AI agents with access to official documentation and API snippets.
React Wrapper for Google Drive Picker
Announcing the new React component for the Google Drive Picker, wrapping usage of the web component for easier integration.
Google Workspace Developer Tools VS Code Extension
Announcing the new Google Workspace Developer Tools extension for VS Code, working with Antigravity and providing OAuth2 scope linting and MCP support.
Google Drive Picker TypeScript - Types Updated
Last week I submitted a pull request to the DefinitelyTyped repository for the Google Drive Picker API. Not a big deal in itself, but these types are generated from the same source as the Google Drive Picker reference documentation and should be more correct and consistent than the community types that were previously in the DefinitelyTyped repository.
Google Forms - title vs name vs documentTitle
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.
Converting between Office docx and Google Docs in Google Apps Script
Learn how to programmatically convert, open, and edit Microsoft Word .docx files using Google Apps Script and the Drive API.
Google Workspace Developer Summits - 2024 - Boston and Berlin
Save the date for the Google Workspace Developer Summits in 2024! Boston - September 12, 2024 and Berlin - September 17, 2024.
Google Sheets API - IMPORT / Image - Bypass User Consent
Use the Spreadsheets v4 API to set the importFunctionsExternalUrlAccessAllowed property to true and allow access to external URLs without requiring user consent.
How do I get access to the chrome.sidePanel API from the latest manifest v3? - Stack Overflow
Link shared about: How do I get access to the chrome.sidePanel API from the latest manifest v3? - Stack Overflow
Apps Script and WebAssembly - A comprehensive guide
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.
Alfalfa Uses More Water Than All Cities, Industries in Colorado River Basin
Link shared about: Alfalfa Uses More Water Than All Cities, Industries in Colorado River Basin
SvelteKit: Convert base64 slugs to UUIDs automatically in a derived store
A SvelteKit store that automatically converts slugs to UUIDs from the URL path parameters.
Google Apps Script: google.script.run vs. doGet/doPost Endpoints
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.
Feds May Be Underestimating Broadband Woes
Link shared about: Feds May Be Underestimating Broadband Woes
TDS - les Traces du Duc de Savoie - Dacia UTMB Mont Blanc
TDS - les Traces du Duc de Savoie - Dacia UTMB Mont Blanc
Drive File Get Blob and Scopes in Google Apps Script
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.
Race Results
• TrailRun • 163.50 km • 5553 m
• TrailRun • 20.15 km • 712 m
• TrailRun • 173.22 km • 6428 m
• TrailRun • 147.63 km • 9507 m
• TrailRun • 161.39 km • 6705 m
• TrailRun • 99.78 km • 1693 m
• TrailRun • 391.21 km • 9436 m
• Run • 77.68 km • 1427 m
• Run • 50.99 km • 1132 m
• Run • 18.64 km • 759 m
Running Tracker (km)
Year-to-Date Distance: 2842.2 km