#google workspace

A writeup of a small agentic system I built to triage my Gmail inbox, using Claude subagents to organize and assess messages.

Human DX optimizes for discoverability. Agent DX optimizes for predictability. What I learned building a CLI for agents first.

Connect Apps Script to PostgreSQL via JDBC, including connection strings, JSONB and UUID workarounds, transactions, and PostGIS.

Learn how to communicate with Model Context Protocol (MCP) servers using Apps Script and UrlFetchApp. Incorporate the MCP client into Vertex AI tool calling.

Use Apps Script's Vertex AI advanced service to call Gemini for text, images, structured output, search grounding, and multi-turn chat.

How Apps Script currentonly scopes limit access to an active file, and why Advanced Services, direct API calls, and openById need full scopes.

Securely resolve Google Chat User IDs to emails without Domain-Wide Delegation. Use Service Account Impersonation and custom Admin roles.

Unofficial Apps Script CacheService findings: key and value limits, FIFO batch eviction, edge cases, and practical cache patterns.

The unofficial guide to Google Apps Script UrlFetchApp. Master authentication, fetchAll for parallelism, web scraping, and debugging "Address Unavailable".

Avoid hardcoded Apps Script secrets by using PropertiesService for configuration and Google Cloud Secret Manager for sensitive values.

Announcing the new MCP server for Google Workspace Developer Tools, providing AI agents with access to official documentation and API snippets.

Announcing the new React component for the Google Drive Picker, wrapping usage of the web component for easier integration.

Announcing the new Google Workspace Developer Tools extension for VS Code, working with Antigravity and providing OAuth2 scope linting and MCP support.

A DefinitelyTyped update that replaced community Google Drive Picker types with autogenerated types from the official reference source.

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.

Programmatically convert, open, and edit Microsoft Word .docx files in Google Apps Script using the Drive API and DocumentApp.

Save the date for the 2024 Google Workspace Developer Summits in Boston on September 12 and Berlin on September 17.

Use the Sheets API to allow external URL access for IMPORT and IMAGE functions without requiring each spreadsheet user to grant consent.

How I compile Rust to WebAssembly, bundle it with JavaScript, and run it in Google Apps Script, with examples and performance notes.

Compare google.script.run vs doGet/doPost endpoints for Apps Script web apps. Choose the best method for simple apps or complex frameworks like React/Vue.

Compare DriveApp, the Drive Advanced Service, and UrlFetchApp for retrieving Drive file blobs in Apps Script while minimizing OAuth scopes.

Benchmarks comparing CacheService, PropertiesService, and Firestore in Apps Script, including speed measurements and when each storage option fits.

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 APIs and Apps Script's V8 runtime, including UrlFetchApp and sleep workarounds.

A Google Next 2024 lightning talk on extending Apps Script with Rust, Python, and WebAssembly, with a build demonstration.

Understand async/await and Promises in Google Apps Script. Learn why most APIs remain synchronous and how WebAssembly is the exception.

Understand why Google Calendar reports "usage limits exceeded" for external attendees and notifications, plus practical alternatives.

Google Drive broke the ability to embed images with the /uc path. Here's how to embed images from Google Drive in your website.

Use the Firestore REST API from Google Apps Script when CacheService, PropertiesService, or Sheets cannot meet your storage requirements.

Avoid downloading service-account keys: use impersonation in Apps Script to mint access tokens for Google Cloud APIs.

A short Apps Script example that calls the Gemini Pro REST API to generate text, then reads the response candidate text.

A generic Apps Script memoization helper that hashes a function and arguments, stores results in CacheService, and explains its limits.

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.

Use an OAuth2 offline flow to obtain Google user credentials as application default credentials when service accounts or API keys cannot work.

Archive Dependabot and Semantic Release emails automatically using Google Apps Script cron jobs to declutter your inbox.

An Apps Script that archives Gmail threads older than 30 days, respects Gmail's 100-thread batch limit, and runs hourly on a trigger.