I need an end-to-end script or lightweight app that links my Google Sheet to a Keynote pitch deck so every figure, metric, and text snippet stays current without any copy-paste work. Core workflow • Map individual Google Sheet cell references to specific objects in Keynote (slide number, object ID, or name). • Retrieve both text strings and numeric values through the Google Sheets API. • Push the data into Keynote while preserving every font, color, size, and style already applied. No re-formatting should be required after an update. Triggering updates • One-click manual refresh for ad-hoc edits. • Automatic refresh that runs once a week; scheduling can live in macOS (launchd, cron) or inside the script itself. A simple configuration toggle should let me change the cadence later. Deliverables 1. Working script/app (AppleScript, JXA, Python + Keynote scripting—whatever you prefer as long as it runs reliably on macOS). 2. A concise setup & mapping guide so I can add new deck elements or reuse the solution in future presentations. 3. Basic inline comments within the code explaining the key sections. Acceptance When I press the command or wait for the weekly job, every mapped element in the deck should update with live Sheet data and keep its original formatting intact. If anything is unclear about my environment or the sheet structure, let me know and I’ll share details right away.