User Guide

Welcome to the central documentation for Data Transporter. This guide covers everything from your first transfer to complex background automation in Google Sheets™.

Installation 📥

Data Transporter is available via the Google Workspace™ Marketplace. Once installed, it attaches to your spreadsheets globally.

Activation

To start, open any Google Sheets™ file and go to Extensions > Data Transporter > Open Sidebar. If this is your first time, you will need to approve the Google™ OAuth scopes.

Required Permissions

The add-on requires access to spreadsheets (to read/write data) and drive (to save your configurations and create archive files). We never see your data; all processes run within your own Google™ account.

Core Logic 🧠

Understanding how Data Transporter handles data is key to preventing accidental data loss.

Sync vs. Move

Sync Mode: Acts like a "mirror." It copies data from source to destination. If you delete a row in the source, it remains in the destination unless the sync is run again with specific cleanup rules.

Move Mode: Acts like "cut and paste." It is a destructive action on the source sheet. Use this for moving completed tasks into an archive.

Filtering Data

You can set multiple filter conditions. Data Transporter will only process rows that meet 100% of your criteria. You can filter by exact matches, partial strings, or numerical values.

Automation 🤖

Stop doing manual work. Data Transporter includes a robust triggering system.

Time-Based Triggers

Configurations can be set to run every hour, every day, or on specific days of the week. This uses Google™ Apps Script Triggers under the hood.

Error Handling

If a Google Sheets™ limit is hit (like the 10 million cell limit) or a sheet is deleted, the automation will pause and send an alert to your Google™ account email.