Anleitung

So nutzt du Google Apps Script Copilot.

Sieh es in Aktion, richte es in drei Schritten ein und lerne die vier Handgriffe fur den Alltag.

Google Apps Script Copilot open beside the editor on script.google.com

Einmal einrichten, in drei Schritten.

  1. 1Add it to ChromeOne click from the Chrome Web Store. No CLI, no config files.
  2. 2Mit Google anmeldenUse the account that owns your Apps Script projects.
  3. 3Open any scriptThe panel docks itself into the editor. Press Alt+L if you closed it.

Die vier Handgriffe fur den Alltag.

Ask in the panelAlt+L

It already has your open file and your sheet, so describe the outcome rather than the implementation. Every conversation is kept, per project, in the history panel.

Tab to acceptTab

Ghost text appears as you type. Tab takes it, Esc drops it.

Pull in files with @@

Type @ to attach another file. Type / to run a skill.

Read the diff, then acceptAccept

Changes arrive as a diff in the editor, never straight into the file. Nothing is written until you accept. Revert on a turn also undoes every turn after it.

Vage Frage, vage Antwort.

The gap between a useless answer and a working one is usually three extra words.

Vage

fix my script

Konkret

sendDailySummary throws "Cannot read range" when Sheet1 has blank rows. Guard it and keep the mail format.

Zum Merken.

Alt+L
Open the panel
Alt+Q
Send the selected code to chat
Tab
Accept the inline suggestion
Esc
Dismiss the suggestion
@
Attach a file to the message
/
Run a skill

Auf dem Mac Option statt Alt verwenden.

Erst lesen, dann ausfuhren.

  • Test on a copy of the sheet, not the live one.
  • Keep API keys in PropertiesService, never in a prompt.
  • Validate anything arriving from a form or a URL parameter.
  • Keep each change small enough to review in one screen.