Document generation
Create a Google Doc for each row and write its link back to Sheets.
Generate documents from spreadsheet rows, send form notifications, or build your own workflow. Start with a template and see which steps fit as you build, or open an Apps Script you already use.
The editor runs in your browser: desktop, no sign-in, nothing saved. ScriptGlyph writes readable Google Apps Script™ and deploys it to your own Google account.
The Document generation workflow makes a Google Doc for each row of a sheet. Here is the one decision that completes its copying step.
Drag from the File. The menu lists only steps that work on a file; choose Make copy (name, destination).
ScriptGlyph wires in the template file. You connect the name and the folder. The next steps are shown faded.
Choose Documents, then Create documents. Each row gets its own document, and its link is written back.
Try it yourself In the editor, in your browser. No sign-in, and nothing is saved.
Recreated from ScriptGlyph using sample data.
Every automation is built from the same few parts. This is the start of the Document generation template.
The orange node is the event that starts it: here, a menu item in the sheet.
Blue nodes call a Google service. White wires set the order, left to right.
Light blue nodes give values. Coloured wires carry them; the colour is the kind of value.
Recreated from ScriptGlyph using sample data.
Each one opens as a graph you can change.
Create a Google Doc for each row and write its link back to Sheets.
Email the person who asked when their request is marked Approved or Rejected.
Email each new form response to you.
What you build belongs to you, not to ScriptGlyph.
No ScriptGlyph library inside. Your automations keep running if you stop using ScriptGlyph.
Saved as files in your own Drive. ScriptGlyph has no servers and keeps no copy of your data.
Each automation's permissions are listed before anything changes in your account.
Bring in an Apps Script from a colleague, a consultant or Gemini. Supported logic becomes nodes; the rest stays as code. The original is left untouched.
function trimSpaces() { const range = SpreadsheetApp.getActiveRange(); const values = range.getValues(); const cleaned = values.map(row => row.map(cell => (typeof cell === 'string' ? cell.trim().replace(/\s+/g, ' ') : cell)) ); range.setValues(cleaned); }
The tidying rule has no node yet, so it stays as code in a Code step, shown hatched.
Get active range becomes Get active sheet and Get data range, so the whole sheet is tidied. Recreated from ScriptGlyph using sample data.
The next person gets the project, not just the code: Tom changes the folder and deploys it to his own account.
The graph and its settings, in a Drive file. Tom changes the folder.
Listed before every deploy, and different for each automation. ScriptGlyph's own are separate.
Written by ScriptGlyph from the project: what it does, its settings, how to take it over.
What it does
Runs when someone chooses Documents, then Create documents.
Handing it over
The new owner opens the project in ScriptGlyph and deploys it
once, so the script is theirs to change.
Recreated from ScriptGlyph using sample data.