Tab Transfer

Google Sheets add-onComing soon to Google Workspace Marketplace

Move rows between tabs automatically when their status changes. Set a status column, map each status to a tab, and Tab Transfer keeps your sheet organised without breaking formulas, checkboxes or formatting.

  • Pay once. No subscription
  • No AI credits or tokens
  • Runs 24/7 by itself
Moved 1 rowRequests → Approved
A1 Features

Everything a "move this row" macro should have done.

Copy-paste scripts lose formatting, break formulas and trip over shared sheets. Tab Transfer was built to handle the details.

Status-based rules

Map each status to a destination tab: Approved → Approved, Done → Archive. Import statuses straight from your dropdown or selected cells, and auto-match them to tabs with the same name.

Formulas stay intact

Per-row formulas in the destination are extended to new rows with references adjusted. ARRAYFORMULA, BYROW, QUERY and FILTER columns (even formulas in the header cell) are left alone, so nothing breaks with #REF!.

Checkboxes, links & notes

Checkboxes keep their state (custom Yes/No ones too), dropdown chips stay chips, and notes, rich-text links and cell formatting travel with the row.

Instant, scheduled or on demand

Rows move the moment a status is changed, on a schedule (every 1 to 12 hours or daily at a set time), or in a batch whenever you click Move rows.

Email notifications

Send an email per moved row or one digest per run, with {{Any Header}} placeholders, recipients from a column, CC, reply-to, your Gmail signature and file attachments.

Documents from templates

Turn each moved row into a filled-in Google Doc or PDF: invoices, contracts, certificates. Use a Google Doc or Word template with {{Header}} placeholders, or fill the fields of a PDF form. The link lands in the row and the PDF can ride along in the email.

Safe for shared sheets

One owner sets it up; editors just change statuses. Every run is recorded in an activity log, and editors can take over if the owner leaves the file.

Column check

One click compares the headers of every source and destination tab. Columns that would be lost, near-miss names like E-mail vs Email, and missing tabs are flagged before you save.

Big batches finish themselves

Thousands of rows? Tab Transfer works to a time budget, stops cleanly before Google's 6-minute limit and continues a minute later, so nothing is half-moved or emailed twice.

B1 Why not just ask AI?

Rules that run on their own, paid for once.

AI assistants are great for a one-off cleanup. A sheet your team updates every day needs something that works without being asked, gives the same result every time, and doesn't bill you per use.

FeatureTab TransferAI assistant in a chat or side panelSubscription automation add-ons
PricePay once from $18.99. Yours to keepA monthly AI plan or usage creditsA monthly or yearly subscription
Moves a row the moment its status changes Yes, even when the sheet is closed Only when you ask it to Yes
Cost for each moveNone. No credits, tokens or monthly capsUses credits or message limitsOften capped runs per month
Same result every time Fixed rules you can read Answers can vary Yes
Works on a free Gmail account YesOften needs a paid plan Usually
Emails and filled-in documents Built in (Pro and Ultra) You build it yourselfOften a separate tool to pay for
Your sheet data stays in your Google account Yes, it runs in Apps Script Sent to the AI to processVaries

Based on public pricing and product pages as of November 2026. Details vary by product and plan.

B1 How it works

Set up in about two minutes.

  1. Install

    Install Tab Transfer from the Google Workspace Marketplace and approve its permissions.

  2. Open it

    In your spreadsheet go to Extensions → Tab Transfer → Open Tab Transfer.

  3. Map statuses

    Set the status column and the tabs to watch, then choose which statuses send rows to each tab.

  4. Save

    Rows now move on their own. Add a schedule, email notifications or documents any time.

Full guide

C1 Notifications

Tell the right person, the moment it moves.

Build email templates with any column from your sheet. Send one email per row, to an address taken from the row itself, or a single digest of everything that moved in a run.

  • Placeholders for every header plus {{To Tab}}, {{Row Count}}, {{Spreadsheet Link}}
  • Per-row emails or one digest per run
  • Custom sender name, reply-to and CC
  • Paste your Gmail signature and attach files (PDFs, price lists, forms)
  • Attach each row's own document, such as its filled-in invoice PDF
  • Preview the exact email and send yourself a test before saving
D1 Under the hood

Careful with your sheet.

Tab Transfer reads and writes in bulk, so it stays fast even when thousands of rows move at once.

  • Columns matched by header name, so tabs don't need the same layout
  • Column check warns before a missing column would lose data
  • Per-row destination formulas are extended; spilling formulas are left alone
  • Conditional-formatting rules are never duplicated into the destination
  • Choose to delete the source row or just clear it
  • Keep the row's own look, match the destination tab, or skip formatting
  • Optional "moved on" timestamp column
  • Exclude tabs you never want scanned
  • Moved rows are removed in grouped blocks, fast even for thousands of rows
  • Huge batches pause before Google's 6-minute limit and finish on their own a minute later
  • Pre-filled formula and checkbox rows below your data are filled first, not skipped
E0 Pricing

Try everything free for 15 days. Then pay once, or stay free.

Your 15-day trial of every feature starts when you save your first setup. No card needed. After it, keep 3 rules free forever, or pay once for Pro or Ultra. No subscription.

One-time payment. No subscription, no renewals, no credits.Buy once and it's yours: every spreadsheet you automate, every future update, no monthly bill.
Free
$0forever
  • Starts with a 15-day trial of every Ultra feature
  • 3 status rules (3 statuses that move rows)
  • Instant moves when the status changes
  • Manual "move now" for one tab or all tabs
  • Column check before data is lost
  • Formulas, checkboxes, dropdowns, notes, formatting and links kept
Install & set up
Pro
$18.99one-time
  • Everything in Free
  • Unlimited status rules and destination tabs
  • Scheduled runs (hourly or daily) for formula- and form-driven statuses
  • Email notifications with your own Gmail signature and file attachments
  • Every spreadsheet you automate, no per-file fees
Best value
Ultra
$26.99one-time
  • Everything in Pro
  • Documents per row from Google Doc, Word or PDF form templates
  • Save as PDF or Google Doc; fill PDF forms flattened or fillable
  • Each row's document linked in the sheet and attached to its email

Own Pro already? Upgrade to Ultra for the $8 difference.

Upgrade inside the add-on: Extensions → Tab Transfer → Upgrade / license, or See plans in the sidebar. Payment is handled securely by Stripe and your plan activates automatically.

14-day no-questions refund · Prices in USD · See plans, purchases and refunds

E1 Permissions

What Tab Transfer asks for, and why.

Google shows these permissions when you install. Here's what each one is used for.

PermissionWhy it's needed
See, edit, create and delete your spreadsheets
https://www.googleapis.com/auth/spreadsheets
Read the status column and move rows between tabs. Tab Transfer only works in the spreadsheets where you set it up, including scheduled runs while the file is closed.
Display and run third-party web content in prompts and sidebars
https://www.googleapis.com/auth/script.container.ui
Show the Tab Transfer window inside Google Sheets.
Allow this application to run when you are not present
https://www.googleapis.com/auth/script.scriptapp
Create the edit and schedule triggers that move rows automatically.
Send email as you
https://www.googleapis.com/auth/script.send_mail
Send the notification emails you configure. Nothing is sent unless you turn notifications on.
See your primary Google Account email address
https://www.googleapis.com/auth/userinfo.email
Identify the automation owner and send test emails to you.
Associate you with your personal info on Google
openid
Lets the add-on prove to our license service which Google account you are, so your plan (Free, Pro or Ultra) can be looked up securely.
Connect to an external service
https://www.googleapis.com/auth/script.external_request
Used only to check your license, start a secure Stripe checkout when you upgrade, and work with your attachments, templates and documents through the Google Drive and Google Docs APIs. Spreadsheet data is never sent to macrotool.
See, edit, create and delete only the specific Google Drive files you use with this app
https://www.googleapis.com/auth/drive.file
Store the files you attach to email notifications, read the templates you choose, and save the documents it creates for your rows, all in your own Drive. Tab Transfer can only see files you picked or it created, never any other file in your Drive.

Tab Transfer does not send your spreadsheet data to macrotool or any third party. Only your Google account email address is sent, to check your plan. Read the full Privacy Policy.

F1 FAQ

Questions, answered.

Is Tab Transfer free?

Yes. Every account gets a 15-day trial of all features, starting when you save your first setup. After that, the free plan has no time limit and includes three status rules, instant moves and manual moves. Pro ($18.99, one-time) adds unlimited rules, scheduled runs and email notifications with attachments. Ultra ($26.99, one-time) adds documents from templates on top. Both cover every spreadsheet you automate.

Why not just use AI like Gemini or ChatGPT?

AI is useful for a one-off job, like moving rows once. But an AI assistant only acts when you ask it, can give different results each time, and usually needs a paid plan or credits. Tab Transfer runs by itself the moment a status changes (or on a schedule), follows the same rules every time, keeps your data in your Google account, and costs nothing per move. You pay once.

What happens when the trial ends?

Nothing is deleted. You choose which 3 rules keep moving rows; the other rules, email notifications, schedules and documents are paused with their settings kept. You get one reminder email during the last 24 hours of your trial (the day before it ends). Buy Pro or Ultra any time and everything runs again exactly as you set it up.

Are Pro and Ultra subscriptions?

No. You pay once. The license is tied to the Google account you buy it with, so it works in every spreadsheet that account automates and comes back automatically if you reinstall. Editors who just change statuses in your sheet don't need a license.

Do the tabs need identical columns?

No. Tab Transfer matches columns by header name (case-insensitive), so tabs can have their columns in different orders, and a destination can have extra columns of its own, for example a formula column or a "Moved on" timestamp. Columns that don't exist in the destination are skipped, and the Column check in the Rules tab lists them before anything is lost.

What happens to formulas in the row being moved?

Formulas from the source row arrive as their calculated values, because their cell references wouldn't be valid in another tab. Formulas that already exist in the destination tab are never overwritten. Per-row formulas are extended to the new rows automatically.

Who can set it up?

The first person to save the setup in a spreadsheet becomes its owner. Only the owner can change rules or run batch moves; editors can still change statuses, and the owner's automation moves those rows for them. If the owner loses access to the file, an editor can take over.

Will it send emails from my account?

Only if you turn email notifications on. Emails are sent with your own Google account through Google's mail service and count toward your daily Google sending quota. You can send yourself a test email before saving.

Can emails include attachments?

Yes, with Pro or Ultra. Attach up to 5 files (15 MB each, 20 MB in total) to any notification. They're stored in a Tab Transfer attachments folder in your own Google Drive, and the add-on can only access the files it stored there.

Can it create a document or PDF for each row?

Yes, with Ultra. Choose a Google Doc or Word template with {{Header}} placeholders, or a PDF with form fields, for any destination tab. Each moved row gets its own file (a PDF, a Google Doc, or a flattened or fillable PDF form) saved in your Drive, with a link written into the row. The PDF can also be attached to that row's email.

Does it work with very large sheets?

Yes. Rows are read, written and deleted in bulk. If a huge batch would run past Google's 6-minute limit for add-ons, Tab Transfer pauses at 5 minutes, then continues automatically about a minute later until everything has moved, without duplicating rows or emails.

Can I undo a move?

Moves can be reversed with Sheets' version history (File → Version history). For extra safety you can choose to clear the source row instead of deleting it, and try the setup on a copy of your spreadsheet first.

Does Tab Transfer see or store my spreadsheet data elsewhere?

No. It runs entirely inside Google Apps Script under your account. Its settings are saved with the spreadsheet itself, and no spreadsheet content is sent to macrotool or any third party. See the Privacy Policy for details.

How do I get help?

Click the ? next to any heading in the add-on, open Extensions → Tab Transfer → Help & guide, read the guide, or email support@macrotool.app.

Stuck on something?

The guide covers every option. If you still need help, email support and you'll hear back from the developer directly.