SnapSync — How to Add Multiple Source Spreadsheets (Step-by-step)

Before you start

• Open the Dashboard spreadsheet where SnapSync is installed.
• Open the SnapSync sidebar from the menu: SnapSync (Camera + Sync) → 📋 Open Sidebar.
• Make sure the spreadsheets you want to pull from are accessible (shared) to the account you're signed-in with.

1) Add a new mapping

1. Open the Sync Manager tab in the SnapSync sidebar.
2. Fill the Source Spreadsheet ID / URL field by pasting the whole URL or just the ID (the long string in the URL between /d/ and /edit).
3. Enter the Source Range. Examples:
   • Sheet1!A1:G100 — specific sheet and rows
   • A1:G — range without sheet name (assumes first sheet or current sheet; prefer including the sheet name)
4. Enter the Target Range inside the Dashboard workbook. Format: SheetName!A1. SnapSync writes starting at that cell and expands as needed.
5. Optional: Add a short Notes description so you can remember what the mapping does.
6. Set Enabled to TRUE (or choose FALSE to add it disabled).
7. Click ➕ Add Mapping. You should see a confirmation in the status area and the mapping added to the table below.

Tip: If you paste a full spreadsheet URL, SnapSync extracts the ID automatically. If you get a "Target sheet not found" error, create the target sheet first or correct the sheet name in the target range.

2) Run and verify a mapping

1. In the mapping table, find the mapping you added.
2. Click the ▶ button to run that single mapping. Watch the status line for success or error messages.
3. Open the target sheet in your Dashboard to confirm the data was copied successfully (values only — formulas will be copied as values).

If the source range includes blank trailing rows, SnapSync trims them automatically before copying.

3) Run all mappings (batch update)

1. Click 🔄 Run All Syncs from the Sync Manager.
2. SnapSync will iterate through every enabled mapping and copy each source into its configured target.
3. Use the mapping table to enable/disable individual mappings by toggling the checkbox — disabled mappings will be skipped when running all syncs.

4) Schedule automatic syncs

1. Choose a frequency from the Run every dropdown (note: add-on triggers require ≥ 1 hour intervals).
2. Click ⏰ Save Schedule. SnapSync will set up a time‑based trigger to run all enabled mappings at that interval.
3. To remove or change the schedule, set a new frequency; SnapSync will delete the old trigger and create a new one.

If you need near-real-time updates, you can also use the Camera Tool snapshots which sync on edit within the current spreadsheet. Cross-spreadsheet auto-syncs via triggers are limited to hourly or longer intervals for add-ons.

Example SyncConfig table

Paste this example into the SyncConfig sheet (or add it via the sidebar):

Enabled	Source ID/URL	Source Range	Target Range	Notes
TRUE	https://docs.google.com/spreadsheets/d/1a2b3cA/edit	Sales!A1:F200	Sales!A1	Sales data from Region A
TRUE	https://docs.google.com/spreadsheets/d/4d5e6fB/edit	Inventory!A1:D	Inventory!A1	Inventory summary
TRUE	7g8h9iC	Tickets!A1:G200	Support!A1	Customer tickets

Troubleshooting & common errors

• "Target sheet not found" — Make sure the sheet name in the Target Range exists in your dashboard workbook (case-sensitive).
• Permissions errors — Confirm the signed-in Google account has at least view access to the source spreadsheet. If not, share the sheet or use an account that has access.
• Invalid range — Use a valid A1 notation (include sheet name where possible, e.g. Sheet1!A1:G).
• Empty results — SnapSync trims trailing blank rows. If your entire range is blank, nothing will be copied.