How it Works

Sheets Connector makes it simple to sync and organize data between two Google Sheets™ files.

Follow the steps below to get started.

1. Install the Add‑on

Install Sheets Connector from the Google Workspace Marketplace.

After installation:

Extensions → Sheet Connector → Open

2. Select Your Source File

Choose the Google Sheets file you want to copy data from using the Google Drive Picker.

Then select the sheet inside that file.

3. Select Your Destination File

Choose the spreadsheet where the data should be copied to, and select the destination sheet.

4. Map Your Columns

Match your source columns to your destination columns.

You can create:

One‑to‑one mappings

Multiple mappings

Saved profiles for different workflows

5. Apply Optional Data Processing

Enhance your sync with built‑in data tools:

Sort

Sort rows by one or more columns.

Group By

Group rows using one or more column values.

Aggregate

Summarize grouped data using:

Sum

Count

Average

Max

Min

These processing options run automatically before syncing.

6. Click “Sync Now”

Sheets Connector copies only new rows from your source into your destination.

Existing rows are never duplicated or overwritten.

❓ Frequently Asked Questions (FAQ)

Does Sheet Connector overwrite data?

No. It only appends new rows that do not already exist in your destination sheet.

Does it work across different Google accounts?

Yes — as long as both accounts have access to the selected files.

Is my data safe?

Yes.

Sheets Connector only accesses files you choose using the Google Picker.

All data stays inside your Google Drive.

No sheet content is stored on external servers.

How many profiles can I create?

You can create unlimited profiles for different mapping setups.

What happens after the trial?

After the trial limit is reached, syncing pauses until you activate a license.

📞 Contact Us

If you need help or have questions, reach out anytime:

📧 support@sheets-connector.com

We usually respond within 24–48 hours.