#google

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.

Git LFS causes fatal errors in AI agents like Jules due to proxy conflicts and hook limitations. Learn why I abandoned LFS and migrated back to standard Git.

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.

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.

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.

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.

How I used an n8n webhook workflow, Google Chat slash command, and Cloud Translation API to build a simple translation chat app.

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.

A simple endpoint for checking whether a Google OAuth access token is valid, useful when troubleshooting authentication and API requests.

DevRel is a lot things: marketing, engineering, product management, support; my experience as a Developer Relations Engineer at Google.

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

Log microservice usage and bytes sent directly to Google BigQuery using OpenResty and Lua for accurate billing and analytics.