|code, google, google workspace, apps script, gemini, ai, vertex ai
Learn how to use the new built-in Vertex AI Advanced Service in Google Apps Script to access Gemini models directly, without the need for complex UrlFetchApp calls.
Learn about the @OnlyCurrentDoc annotation and currentonly scopes in Google Apps Script. Understand why and how to use them, along with their critical limitations regarding Advanced Services and external APIs.
The unofficial documentation for the Apps Script CacheService. Learn about key/value constraints, size limits, and the undocumented FIFO batch eviction policy.
The unofficial guide to Google Apps Script UrlFetchApp. Master authentication, fetchAll for parallelism, web scraping, and debugging "Address Unavailable".
Announcing the new Google Workspace Developer Tools extension for VS Code, working with Antigravity and providing OAuth2 scope linting and MCP support.
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.
Use the Spreadsheets v4 API to set the importFunctionsExternalUrlAccessAllowed property to true and allow access to external URLs without requiring user consent.
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.