Build and edit Google Workspace automations visually

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.

Part of the Document generation template: copy the template file, get the copy's ID, then open it as a document. Recreated from ScriptGlyph using sample data.

See which steps fit as you build

The Document generation workflow makes a Google Doc for each row of a sheet. Here is the one decision that completes its copying step.

  1. Choose a step that fits

    Drag from the File. The menu lists only steps that work on a file; choose Make copy (name, destination).

  2. Connect it

    ScriptGlyph wires in the template file. You connect the name and the folder. The next steps are shown faded.

  3. Run the workflow in Sheets

    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.

How to read a graph

Every automation is built from the same few parts. This is the start of the Document generation template.

Where it starts

The orange node is the event that starts it: here, a menu item in the sheet.

Steps run in order

Blue nodes call a Google service. White wires set the order, left to right.

Values travel along wires

Light blue nodes give values. Coloured wires carry them; the colour is the kind of value.

Recreated from ScriptGlyph using sample data.

Start from a template

Each one opens as a graph you can change.

Document generation

Create a Google Doc for each row and write its link back to Sheets.

Approvals

Email the person who asked when their request is marked Approved or Rejected.

Form notifications

Email each new form response to you.

Document generation

Makes a document for each row from a template document, filling in {{Column name}} placeholders, and writes its link in the last column.

Drag to move, scroll to zoom
Menu: Create documents
Get active sheet Spreadsheet > SpreadsheetApp
Sheet
Get data range Spreadsheet > Sheet
Sheet
Range
Get values Spreadsheet > Range
Range
Any[][]
Get item
Array
Index0
FOLDER_ID
Get folder by ID Drive > DriveApp
ID
Folder
TEMPLATE_ID
Get file by ID Drive > DriveApp
ID
File
Length
Array
Subtract
A
B1
For loop
First index1
Last index
Loop body
Index
Completed
Get item
Array
Index
Length
Array
Subtract
A
B1
Get item
Array
Index
Not equal
A
B
Branch
Condition
True
False
Then
links
Add item
Array
Item
Length
Array
Subtract
A
B1
Get item
Array
Index
Make array
[0]
Next iteration
Get item
Array
Index0
To text
Value
Make copy (name, destination) Drive > File
File
Name
Destination
File
Get ID Drive > File
File
String
Open by ID Document > DocumentApp
ID
Document
Get body Document > Document
Document
Body
For each loop
Array
Loop body
Array element
Array index
Completed
Join text
A{{
B
Join text
A
B}}
Get item
Array
Index
To text
Value
Replace text Document > Body
Body
Search pattern
Replacement
Element
Save and close Document > Document
Document
links
Add item
Array
Item
Get URL Document > Document
Document
String
Make array
[0]
links
Length
Array
Greater than
A
B0
Branch
Condition
True
False
Then
Length
Array
links
Length
Array
Get range (row, column, num rows, num columns) Spreadsheet > Sheet
Sheet
Row2
Column
Num rows
Num columns1
Range
links
Set values Spreadsheet > Range
Range
Values
Range

In ScriptGlyph, choose New, then Document generation.

The template as ScriptGlyph builds it. Drag to move; scroll or pinch to zoom. Recreated from ScriptGlyph.

Approvals

Emails the person who asked when their request is marked Approved or Rejected. Requests have the item in column A, the email in column B and the status in column E.

Drag to move, scroll to zoom
On edit
Range
New value
Old value
Spreadsheet
User
Event
Get column Spreadsheet > Range
Range
Integer
Get row Spreadsheet > Range
Range
Integer
STATUS_COLUMN
Not equal
A
B
Equal
A
B1
Or
A
B
Branch
Condition
True
False
Then
Stop
Get value Spreadsheet > Range
Range
Any
To text
Value
Not equal
A
BApproved
Not equal
A
BRejected
And
A
B
Branch
Condition
True
False
Then
Stop
Get sheet Spreadsheet > Range
Range
Sheet
EMAIL_COLUMN
Get range (row, column) Spreadsheet > Sheet
Sheet
Row
Column
Range
Get value Spreadsheet > Range
Range
Any
Get range (row, column) Spreadsheet > Sheet
Sheet
Row
Column1
Range
Get value Spreadsheet > Range
Range
Any
To text
Value
To lower case
Text
Join text
AYour request was
B
Join text
AYour request for
B
Join text
A
B was
To lower case
Text
Join text
A
B
Join text
A
B.
Send email (recipient, subject, body) Mail > MailApp
Recipient
Subject
Body

In ScriptGlyph, choose New, then Approvals.

The template as ScriptGlyph builds it. Drag to move; scroll or pinch to zoom. Recreated from ScriptGlyph.

Form notifications

Emails each new form response to you. Attach it to the spreadsheet the form sends its responses to.

Drag to move, scroll to zoom
On form submit
Values
Answers by question
Range
Event
Join items
Array
Separator
RECIPIENT
SUBJECT
Send email (recipient, subject, body) Mail > MailApp
Recipient
Subject
Body

In ScriptGlyph, choose New, then Form notifications.

The template as ScriptGlyph builds it. Drag to move; scroll or pinch to zoom. Recreated from ScriptGlyph.

What stays yours

What you build belongs to you, not to ScriptGlyph.

Plain Apps Script

No ScriptGlyph library inside. Your automations keep running if you stop using ScriptGlyph.

Projects in your Drive

Saved as files in your own Drive. ScriptGlyph has no servers and keeps no copy of your data.

Permissions before every deploy

Each automation's permissions are listed before anything changes in your account.

Read the privacy policy

Already have a script? Open it as a graph.

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.

The script you have
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);
}
Opened as a graph

The tidying rule has no node yet, so it stays as code in a Code step, shown hatched.

One change
The result, on a row you didn't select
Before··Daniel···Reyes·
AfterDaniel Reyes

Get active range becomes Get active sheet and Get data range, so the whole sheet is tidied. Recreated from ScriptGlyph using sample data.

The whole imported script

The trimSpaces function after import, as ScriptGlyph lays it out.

Drag to move, scroll to zoom
Menu: Trim spaces
Get active range Spreadsheet > SpreadsheetApp
Range
Get values Spreadsheet > Range
Range
Any[][]
Make array
Set cleaned
Value
For each loop
Array
Loop body
Array element
Array index
Completed
{ }Code step
row
result
result = (row.map(cell => (typeof cell === 'string' ? cell.trim().replace(/\s+/g, ' ') : cell)));
Add item
Array
Item
cleaned
cleaned
Set values Spreadsheet > Range
Range
Values
Range

Recreated from ScriptGlyph using sample data.

Hand over an automation someone else can edit

The next person gets the project, not just the code: Tom changes the folder and deploys it to his own account.

The project

The graph and its settings, in a Drive file. Tom changes the folder.

Course certificates Tom can edit
TEMPLATE_ID1Hq3…template FOLDER_ID1Wd8…certificates-2027

Permissions for this automation

Listed before every deploy, and different for each automation. ScriptGlyph's own are separate.

Review and deploy When the script runs, it will ask permission to
  • See, edit, create and delete all your Google Docs documents
  • See, edit, create and delete all of your Google Drive files
  • See and edit the spreadsheet this script is attached to
CancelDeploy

Handover notes

Written by ScriptGlyph from the project: what it does, its settings, how to take it over.

Course certificates: handover notes

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.