Automatically Mirror One Google Sheet to Another

Keep two spreadsheets perfectly in sync — effortlessly. This Google Sheets add on creates the automation that allows a user to set up a seamless, automatic connection between two separate spreadsheet tabs in two different spreadsheets. Anytime a cell is edited or updated in one sheet, that exact change is immediately reflected in the corresponding tab of another spreadsheet with the same tab name. No buttons, no manual copy-pasting, no version mismatches — just real-time synchronization.

🔄 How It Works:
You designate a source spreadsheet (where the edits happen) and a destination spreadsheet (where the synced data goes).

Once set up, any edit — whether it's entering new data, changing a number, or deleting a value — is detected by a trigger and pushed to the destination sheet.

The automation identifies the active sheet (by name), and mirrors all changes cell-by-cell to the sheet with the same name in the destination spreadsheet.

This works live — right after each edit, with no delay.

⚙️ Key Features:
Cell-level sync: Every individual cell change is tracked and mirrored.

Sheet-aware logic: Syncs only the tab you're working on — and only if it exists in both files.

No manual sync needed: Once set up, it runs in the background.

Safe & precise: Prevents overwriting unintended data by ensuring both tabs match by name.

🧑‍💻 Use Cases:
Collaborator View:
You're managing a spreadsheet internally, but you want to share just one synced tab with a client or teammate in another file. Instead of giving full access to your working doc, you sync a single tab to their spreadsheet — always updated, no risk of accidental edits on your original file.

Live Reporting Dashboards:
Your team updates a working spreadsheet throughout the day (sales logs, inventory changes, support ticket tracking, etc.), and you want a clean, up-to-date version that feeds into a dashboard spreadsheet used for reporting. This sync tool lets you keep the reporting file accurate at all times without needing to import ranges or rebuild the dashboard.