Keeping a Gemini Answer as a Dated PDF — Export to Docs, Then Freeze It with Apps Script
Gemini's Share & export menu has no PDF option. Here is how to export to Docs, freeze a dated PDF next to it with Apps Script, and avoid the getAs() file-naming trap.
The Table Was There, but the Rows and Columns Weren't — Preserving Docs Structure Before It Reaches Gemini
getBody().getText() flattens Google Docs tables into a column of loose values. Here is what that cost me on a 42-row ledger, the Apps Script extraction layer that keeps the structure, and the acceptance test that keeps it honest.
Google Workspace × Gemini API Automation: Production Notes on 12 Apps Script Patterns
12 Gemini API + Apps Script patterns for Gmail, Docs, Sheets, and Calendar automation—plus the production snags I hit running this across four sites and an app support inbox: swallowed 429s, JSON code fences, the 6-minute cap, and flash-vs-pro routing, with measured numbers.
Gemini × Google Docs and Sheets - AI Techniques for Work
Learn how to use Gemini AI integrated into Google Docs and Sheets. Master auto-document creation, data analysis, function suggestions, and summary generation to streamline your daily work.