Home › Automations › Create a unique ID for each form response in Google Sheets
Trigger: Form responseAction: Generate ID

Create a unique ID for each form response in Google Sheets

Give every submission a unique reference. The moment a form response lands, Sheet Automation generates a unique ID and writes it into the row.

Add to Google Sheets — free See the template

Installs in 30 seconds · No credit card · Works inside Google Sheets

★★★★★ 4.9/5 · 500+ reviews · 300,000+ installs

What it does

This automation watches your form-linked sheet for new responses. When a response arrives, it generates a unique ID (UUID) and writes it into the column you choose — so every ticket, order, or registration has its own traceable reference, with no scripts.

How to set it up

  1. Install Sheet Automation from the Google Workspace Marketplace and open it from your form’s response sheet.
  2. Pick a column to hold the ID, e.g. column H.
  3. Pick the “Create a unique ID for form response” template and set the result column.
  4. Save, then submit a test response — a unique ID appears in that column.

The ready-made template

Create a unique ID for form response — Trigger: a form response is received → Action: generate a unique ID (UUID) into the column you choose. Edit it live below:

Loading preview…

How to use this template

The builder above is a live preview of this automation. To run it in your own spreadsheet:

  1. Click Add to Google Sheets to install Sheet Automation (free).
  2. Open it from your sheet: Extensions → Sheet Automation → Open.
  3. Open the Templates tab and choose “Create a unique ID for form response”.
  4. Adjust the fields to match your data, then click Save.
  5. Trigger it once to confirm the automation runs.

FAQ

What kind of ID is generated?
A UUID — a globally unique identifier — so no two responses ever share the same ID.
Where is the ID written?
Into the result column you set in the template (e.g. column H), on the same row as the response.
Does it work without a Google Form?
This template triggers on form responses. To stamp IDs on manually added rows instead, switch the trigger to “row added”.
Do I need Zapier or Make?
No. Sheet Automation runs inside Google Sheets, so there’s no third-party connector to pay for or maintain.

Related automations

Add a timestamp when a row is updated Copy a row to another sheet when it’s updated Send a Slack message when a row is added Send a reminder when a due date arrives