Lock a row after a Google Form submission

What it does

This automation watches the sheet linked to your Google Form. As each response arrives, the new row is protected so only you (and editors you allow) can change it. Collaborators can still view and add data elsewhere, but submitted responses stay tamper-proof — useful for audits, grading, applications, and approvals.

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 the “Lock row after form submission” template.
3. Optionally adjust who keeps edit access in the action settings.
4. Save. Submit a test response — the new row is protected instantly.

The ready-made template

Lock row after form submission — Trigger: a form response is received → Action: protect the new row from edits. Edit it live below:

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 “Lock row after form submission”.
4. Adjust the fields to match your data, then click Save.
5. Trigger it once to confirm the automation runs.

Related automations