Tab Transfer
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
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Request | Owner | Amount | Status |
| 2 | Laptop refresh | Maya | $1,240 | Pending |
| 3 | Conference trip | Jon | $860 | PendingApproved |
| 4 | Design software | Ana | $390 | Pending |
| 5 | Office chairs | Leo | $2,100 | Review |
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.
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.
| Feature | Tab Transfer | AI assistant in a chat or side panel | Subscription automation add-ons |
|---|---|---|---|
| Price | Pay once from $18.99. Yours to keep | A monthly AI plan or usage credits | A 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 move | None. No credits, tokens or monthly caps | Uses credits or message limits | Often capped runs per month |
| Same result every time | Fixed rules you can read | Answers can vary | Yes |
| Works on a free Gmail account | Yes | Often needs a paid plan | Usually |
| Emails and filled-in documents | Built in (Pro and Ultra) | You build it yourself | Often 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 process | Varies |
Based on public pricing and product pages as of November 2026. Details vary by product and plan.
Set up in about two minutes.
Install
Install Tab Transfer from the Google Workspace Marketplace and approve its permissions.
Open it
In your spreadsheet go to Extensions → Tab Transfer → Open Tab Transfer.
Map statuses
Set the status column and the tabs to watch, then choose which statuses send rows to each tab.
Save
Rows now move on their own. Add a schedule, email notifications or documents any time.
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
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
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.
- 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
- 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
- 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
What Tab Transfer asks for, and why.
Google shows these permissions when you install. Here's what each one is used for.
| Permission | Why it's needed |
|---|---|
See, edit, create and delete your spreadsheetshttps://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 sidebarshttps://www.googleapis.com/auth/script.container.ui | Show the Tab Transfer window inside Google Sheets. |
Allow this application to run when you are not presenthttps://www.googleapis.com/auth/script.scriptapp | Create the edit and schedule triggers that move rows automatically. |
Send email as youhttps://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 addresshttps://www.googleapis.com/auth/userinfo.email | Identify the automation owner and send test emails to you. |
Associate you with your personal info on Googleopenid | 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 servicehttps://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 apphttps://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.
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.