Formula Inventory For Prompt
A sheet with 4,000 formula cells usually has about six distinct formulas, copied down. formulaInventoryForPrompt(range) groups cells by…
8 posts tagged with “co-pilot”
Redact Rows For Prompt
Co-Pilot writes much better code when it sees a real-looking sample row. Real-looking is the point: it shouldn't be a real customer…
Trigger Inventory For Prompt
Co-Pilot can't see which triggers a project has, so it happily adds a second nightly trigger next to the first, or edits a function without…
Script Property Keys For Prompt
Ask Co-Pilot for a script that calls your CRM and it will invent CRM_KEY when you already have HUBSPOT_TOKEN in Script Properties…
Snippet Catalog For Prompt
Your project already has rowsToObjects, withScriptLock and retryUrlFetch. Ask Co-Pilot for a new job and it writes its own versions of all…
Tiny Test Runner
Apps Script has no built-in test framework, and you don't need one to catch the obvious stuff. runTests(tests) runs an object of named test…
Sheet Schema For Prompt
Ask any assistant to write a script for “the Orders sheet” and it will happily invent a Customer Email column you don't have…
Brief NitroGAS Co-Pilot so you get working Apps Script
Co-Pilot is optional. The NitroGAS extension stays free forever for snippets and the editor workflow. When you do use Co-Pilot, the quality…