Home › Automations › Copy a row to another spreadsheet automatically
Trigger: Column updatedAction: Copy row

Copy a row to another spreadsheet automatically

Hand rows off between files without copy-paste. Tick a checkbox and the row is copied into a completely different spreadsheet — a master log, a teammate's tracker, a department file.

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 a checkbox (or any column). When it's ticked, the row is appended to a sheet in another spreadsheet that you pick by URL. The source row stays put, so it works as a one-way sync: collect locally, aggregate centrally. Common uses: pushing qualified leads to sales, escalating tickets, and building a master record across team files.

How to set it up

  1. Install Sheet Automation from the Google Workspace Marketplace and open it from the source sheet.
  2. Pick the “Copy row to another spreadsheet” template.
  3. Paste the destination spreadsheet URL and choose the destination sheet.
  4. Save. Tick the checkbox on a row — it appears in the other file within seconds.

The ready-made template

Copy row to another spreadsheet — Trigger: checkbox in column A is ticked → Action: copy the row to a sheet in another spreadsheet. 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 “Copy row to another spreadsheet”.
  4. Adjust the fields to match your data, then click Save.
  5. Trigger it once to confirm the automation runs.

FAQ

Does it work across different Google accounts?
It works on any destination spreadsheet your Google account can edit, including files shared with you.
Can it move instead of copy?
Yes — use the Move Row action instead if the row should leave the source sheet.
Can it trigger on something other than a checkbox?
Yes. Trigger on any column update, a new row, a form response, or a schedule.

Related automations

Copy a row to another sheet when it’s updated Move a row when status changes to Done Move a row when a checkbox is ticked Send an email when a checkbox is ticked