Tab Transfer guide

How every part of Tab Transfer works. In the add-on, the small ? next to a heading opens the matching section here.

1. Install

  1. Open the Tab Transfer listing on the Google Workspace Marketplace and click Install. (The listing link appears on the Tab Transfer page once it's published.)
  2. Choose the Google account you use for Sheets, review the permissions and click Allow. Each permission is explained on the Tab Transfer page.

Using Google Workspace at work or school? Your administrator may need to allow the add-on, or can install it for the whole organisation from the Admin console.

2. Open Tab Transfer

In any spreadsheet you can edit, open the Extensions → Tab Transfer menu:

  • Open Tab Transfer: opens the sidebar on the right. It has five tabs: Move, Rules, Behavior, Email and Log.
  • Emails & documents: opens the wide editor for email notifications, documents and your signature (owner only, after all three Rules steps are set and saved).
  • Help & guide: this page.
  • Upgrade / license: shows your license, or the upgrade options on the Free plan.
  • Contact support: email us at support@macrotool.app.

Long dropdowns (8 or more options, such as a list of columns) have a search box: click the dropdown and start typing. Use ↑ ↓ and Enter to pick, Esc to close.

If the menu doesn't appear right after installing, reload the spreadsheet tab.

3. Prepare your sheet

  • Headers go in row 1 of every tab. Tab Transfer reads row 1 as the column names.
  • Use the same status column name (for example Status) on every tab rows should move out of, and on destination tabs too if rows may move on again later.
  • Create the destination tabs first, for example Approved, Rejected, Archive.
  • Columns are matched by header name (ignoring upper/lower case), not position. Destination tabs can use a different column order, skip columns, or add columns of their own.

Tip: try your first setup on a copy of the spreadsheet (File → Make a copy).

4. Rules

The Rules tab decides which rows move and where, in three steps. Each step opens when the one before it is set, and Change reopens a step later. Changes apply after you press Save setup at the bottom of the sidebar. The first person to save becomes the automation owner.

Behavior and Email open once the three steps are set, because they work on the rows your rules move. If you change saved rules later, Tab Transfer warns you first: email notifications and documents for tabs that no longer receive rows are turned off (kept, not deleted), and a timestamp column that becomes the status column is set to None.

Step 1: Status column

Pick the header whose value decides where a row goes, then click Set status column. The list shows the headers found in row 1 of your tabs.

Step 2: Watched tabs

Check the tabs rows should move out of, then click Set watched tabs. Only tabs that have the status column are listed; with many tabs, use the search box and All / None. Leave out tabs that should never be scanned, such as a dashboard or an archive.

Each tab needs its headers in row 1 only, with data starting in row 2. When you set the watched tabs, Tab Transfer reads their headers and runs the column check.

Step 3: Statuses & destinations

  • Each watched tab has a row that reads statuses → tab. Click the statuses button on the left to choose the statuses that send rows to the tab on the right, then click Set. The button shows how many statuses are chosen; point at it to see their names. A tab can receive several statuses, for example Paid and Lost into Closed.
  • The list of statuses comes from the status column: its dropdown options and the values already used in your watched tabs. Type a new one in Add a status, or import it from the selected cells or the selected cell's dropdown. Matching ignores upper/lower case and extra spaces, so approved and Approved are the same status. Click the × next to a status to remove it from the list; adding it again brings it back.
  • Each status goes to one tab, so statuses already chosen for another tab are hidden in the list. Turn on Show statuses used by other tabs to see them; choosing one moves it to this tab.
  • Add a destination tab adds a tab that isn't watched, such as an archive, so it can receive rows.
  • Match statuses to tab names sends each unassigned status to the tab with the same name.
  • A status that isn't chosen for any tab is ignored. Rows with it stay where they are.
  • The Free plan moves rows for 3 statuses; Pro and Ultra remove the limit, and so does the free trial.
  • When every tab has its statuses, click Set statuses & destinations. Tab Transfer scans the columns and shows the Column check. Click Change to edit them again.
  • Behavior and Emails & documents open once all three steps are set. This includes the Emails & documents menu item: while a step is open in the sidebar, it asks you to set your rules first.

Column check

Columns are matched by their row 1 header. If a column exists on the source tab but not on the destination, its data is not moved, and it's lost when the row leaves the source tab (deleted with the row, or cleared if you keep the row). The column check finds these before it happens.

  • It appears and runs when you set the statuses and destinations (step 3). After fixing a header in the sheet, click Re-scan columns at the bottom of the Rules tab to read the current headers again.
  • You get one card per destination tab, in the order of your rules. A red number shows how many columns would be lost, a red ! means the tab no longer exists, and a green check means every column matches.
  • Click a card to see each route into that tab (for example Inbox → Approved): the missing columns, headers that look alike (E-mail vs Email), columns that only exist on the destination, and a missing timestamp or status column.
  • The Rules tab shows a red badge with the number of routes that would lose data. When you press Save setup with such routes, Tab Transfer asks first: Review columns or Save anyway.
  • To fix it, add the missing column to the destination with exactly the same header text, or rename a near-match so both headers are the same. Columns that only exist on the destination are fine: they're filled by their own formulas or left empty.

5. Behavior

Timestamp column

Optional. Choose a header (for example Status Timestamp) and Tab Transfer fills it with the date and time when a status changes or a row moves, on the source tab and on the destination.

After a row moves

  • Delete it from the source tab (default). Moved rows are removed in grouped blocks, which is fast even for thousands of rows. If every data row leaves a tab, row 2 is cleared instead of deleted so its formulas and checkboxes survive as a template.
  • Clear it, keep the row. Values are cleared; formulas stay and checkboxes are unticked.

Formatting of moved rows

  • Match the destination tab (default): new rows copy the look of the destination's last row, so every tab keeps its own style.
  • Keep the row's own formatting: fill, font, colours, number formats, alignment and wrapping travel with each cell. Colours from conditional formatting are never copied, because the destination's own rules should decide those.
  • Don't change formatting: only values move.

Links inside cells and HYPERLINK() formulas always stay clickable.

6. Automation

  • Move instantly: as soon as anyone changes a status, editors included, that row moves. It runs under the owner's account.
  • Run on a schedule (Pro and Ultra): every 1, 2, 4, 6, 8 or 12 hours, or daily at a chosen hour in the spreadsheet's time zone. Use it when statuses are set by formulas, Google Forms or imports, which don't count as edits.

Google allows add-on schedules at most once an hour. Turning an option off removes its trigger when you save.

7. Move tab

The Move tab is the home screen.

  • Plan card: your plan, with Upgrade and Already bought? (re-checks your license).
  • This tab: moves every row on the tab you're viewing whose status has a destination. It follows the tab you click in the sheet.
  • All tabs: the same for every watched tab.

Both buttons stay greyed out until the setup is saved.

Status

Shows who owns the automation, whether instant moves and the schedule are on, and the email setup at a glance.

8. Formulas, checkboxes & formatting

  • Formulas in the moved row arrive as their calculated values, because their cell references wouldn't be correct on another tab. HYPERLINK("…","…") formulas are kept as live formulas.
  • Per-row formulas in the destination (for example =C2*D2 in every row, including rows pre-filled below the data) are extended to the new rows automatically.
  • Formulas that fill a whole column are left alone: an ARRAYFORMULA, BYROW/MAP, QUERY or FILTER in row 2, or a formula in the header cell such as ={"Total";ARRAYFORMULA(…)}. Tab Transfer writes around them.
  • A destination column with no formula receives the value from the source, like a manual entry.
  • Checkboxes keep their ticked or unticked state, including custom values such as Yes/No. Empty pre-filled checkboxes below your data don't count as data, so new rows fill those rows first.
  • Dropdowns keep their style (chips stay chips). Notes and links come along.

9. Email notifications

Pro and Ultra. In the sidebar's Email tab, click Open emails & documents editor (or use Extensions → Tab Transfer → Emails & documents), switch email on and add notifications. For each one choose:

  • When rows move to: a specific tab, or any tab.
  • Send: An email per row, or One summary per run listing every moved row.
  • To / CC: fixed addresses, and/or Also email the address in column to use each row's own address (for example the Email column).
  • Subject and message: click a placeholder to insert it: any header as {{Header Name}}, plus {{From Tab}}, {{To Tab}}, {{Row Count}}, {{Moved At}}, {{Spreadsheet Name}} and {{Spreadsheet Link}}. Checkboxes appear as ☑ / ☐.
  • Include row details adds a table of the moved row(s). Add my signature is set per notification.
  • Attach the row's document: when a document is set up for the same tab, an email per row gets that row's file attached as a PDF, and a summary email lists links to all the new files.

Attachments

Click Attach files to add files from your computer: up to 5 files, 15 MB each and 20 MB in total. They're saved in a Tab Transfer attachments folder in your own Google Drive and attached to every email the notification sends. Tab Transfer can only see the files it stored there, never the rest of your Drive. If you delete a file, emails go out without it and the Log tells you.

Preview and test

Preview email shows the exact email using a real row; Send me a test emails it to you, attachments included. Press Save at the bottom of the window to apply.

Emails are sent from the owner's Google account and count toward Google's daily sending quota (about 100 recipients a day for free Gmail accounts, more on Google Workspace). If the quota runs out, the remaining emails are skipped and the Log says so.

10. Documents

Ultra. Create a file for every row that moves to a tab: an invoice, a contract, a certificate, a filled-in form. Tab Transfer fills a copy of your template with the row's values, saves it in your Drive and writes a clickable link to the file in a column of the moved row.

Open Emails & documents, choose Documents on the left and click Add document. Each card is one tab, with its own template and link column:

  • When rows move to: the destination tab.
  • Template: Choose from Drive or Upload a file. See the two template types below.
  • Save each file as: for Google Doc and Word templates, PDF (best for emailing and printing) or Google Doc (still editable). For PDF forms, Flattened PDF or Fillable PDF.
  • File name: click a placeholder to insert it, for example {{Invoice No}} - {{Customer}}.
  • Who can open the files: Only me, or Anyone with the link if the people you email should open the link. Attached PDFs work either way.
  • Skip rows that already have a file: if the row already has a link in the column, no new file is made. Useful when rows move between several tabs.

Google Doc and Word templates

Write {{Header Name}} in the document wherever a value should go, in the body, tables, headers or footers. Any header of the tab works, plus {{To Tab}}, {{From Tab}}, {{Moved At}}, {{Today}}, {{Spreadsheet Name}} and {{Spreadsheet Link}}. After you choose the template, the card shows every placeholder it found: green ones match a column, red ones don't and would stay as typed, so rename the column or the placeholder. Word files (.docx) are converted to a Google Doc once, when you choose them; the formatting of the template is kept.

PDF form templates

Use a PDF that has fillable form fields, for example a form made in Adobe Acrobat (Prepare a form) or a form from a supplier or agency. After you choose it, the card lists every field with a Fill with dropdown: a column, a built-in value such as Today, or Leave empty. Fields with the same name as a column are matched automatically, ignoring case, spaces and punctuation (customer_name matches Customer Name).

  • Text fields get the cell's value as shown in the sheet. Line breaks are removed in single-line fields, and fields with a character limit are cut to fit.
  • Checkboxes are ticked when the value is TRUE, Yes, X, 1 or a ticked checkbox.
  • Choice, dropdown and list fields select the option that matches the value.
  • Flattened PDF prints the values on the page and removes the form, so nothing can be changed. Fillable PDF keeps the values in the fields, which can still be edited.
  • PDF form fields only support Latin characters. Other characters (for example Chinese or emoji) are replaced with "?" and the Log says so. Password-protected PDFs and PDFs without form fields can't be used; use a Google Doc template for those.

Where the files are saved

Everything is saved in the owner's Google Drive, in folders Tab Transfer creates: new documents in Tab Transfer documents › [tab name], uploaded templates in Tab Transfer templates. Templates you pick from Drive stay where they are and are only read. Tab Transfer uses Google's drive.file permission, so it can only see the templates you choose and the files it creates, never the rest of your Drive.

Preview and existing rows

Preview document makes one sample file from the first row of the tab and opens it, named "[Preview] …" in the same folder (delete it when you're done). Create for rows already there makes files for rows that are already on the tab and have an empty link cell; save first. Files are made while rows move, so large batches with documents take longer and may continue in a second run.

11. Sender & signature

  • Sender name and Reply-to address are optional.
  • Signature: open Gmail → Settings → Signature, select your signature, copy, and paste it into the editor. You can also paste HTML from a signature generator, or edit the HTML directly. The preview shows exactly how it will look.
  • Use images hosted on the web (https links); pasted or embedded images are removed because email apps block them. Scripts and unsafe code are stripped automatically.
  • If spacing around a heading looks too big, the signature's HTML is probably missing style="margin:0" on that heading or paragraph.

12. Activity log

The Log tab lists the 25 most recent runs: when they ran, how they were triggered (Instant, Manual, Scheduled or Continued), how many rows went to each tab, emails sent, and any problems. The Move tab shows the latest three.

13. Plans & license

15-day free trial. When you save your first setup, every feature (Ultra) is unlocked for 15 days, once per Google account. The plan card on the Move tab counts down the days, and you get one reminder email, from your own account to yourself, during the last 24 hours of your trial (the day before it ends). Buying during the trial simply replaces it.

When the trial ends, nothing is deleted. The sidebar asks which 3 statuses keep moving rows (you can change this later from the Rules tab); the other rules are shown as paused. Email notifications, schedules and documents keep their settings and show Paused. Rows whose status points to a paused rule stay where they are. Buy Pro or Ultra and everything runs again exactly as you set it up.

  • Free, forever: 3 status rules, instant and manual moves, and everything in section 8.
  • Pro: $18.99 once. Unlimited rules, scheduled runs, and email notifications with your signature and attachments.
  • Ultra: $26.99 once. Everything in Pro, plus documents from Google Doc, Word and PDF form templates, attached to emails.
  • Pro to Ultra: if you own Pro, upgrading costs only the $8 difference.

Both plans are one-time payments that cover every spreadsheet you automate. No subscription. Upgrade from the sidebar (See plans or Upgrade on the Move tab) or from Extensions → Tab Transfer → Upgrade / license. Payment is handled by Stripe; your plan activates on its own within a few seconds. Bought already but still see Free? Click Already bought? on the Move tab. The license belongs to the Google account you bought it with. 14-day refund: see the terms.

14. Owners & editors

  • The first person to save the setup becomes the owner. Only the owner can change the setup, run batch moves and edit emails. Only the owner needs a license.
  • Editors change statuses as usual; the owner's automation moves their rows and sends emails on the owner's behalf. When an editor opens Tab Transfer they see who the owner is and where each status goes.
  • If the owner loses access to the file, an editor can take over. The previous owner is notified by email.

Copied spreadsheets

When someone makes a copy of an automated spreadsheet (File → Make a copy), the copy brings the Tab Transfer setup along, but nothing runs in it. The first time they open Tab Transfer in the copy, they choose:

  • Start fresh: removes the copied setup and its activity log, so they set up their own rules.
  • Keep the copied setup: they become the owner of the copy. Rules, behavior and emails stay. Document templates and email attachments are cleared, because those files are in the original owner's Drive; they choose their own in Emails & documents.

The original spreadsheet and its automation are not affected either way.

15. Large sheets & limits

Google stops any add-on run after 6 minutes. For very large batches Tab Transfer works to a budget: it stops starting new moves at 5 minutes and stops sending emails at 5½ minutes, then schedules itself to continue about a minute later, repeating until everything is done. A tab is never half-moved, and unsent emails are queued and sent first by the next run, so nothing is duplicated or lost. You'll see Continued entries in the Log.

16. Troubleshooting

Rows aren't moving

  • Check the status column header is in row 1 and spelled the same on each tab.
  • Check the status has a destination in Rules and the tab still exists.
  • Make sure the tab is checked under Watched tabs.
  • Statuses set by formulas or forms need the schedule (or a manual move).
  • Open the Log for the last run and any message.

"Only the automation owner can…"

Someone else saved the setup first. Ask the owner, or take over if they've left the file.

A column is empty in the destination

The destination has no column with that header name, or the source cell was empty. Run the column check in the Rules tab: it lists every column that won't be moved. Add a column with the same header.

A document wasn't created or has empty spots

Open the Log: a failed document is listed with the reason, and the row still moves. Check that the template still exists in Drive, that the link column exists on the destination tab, that red placeholders on the document card are fixed, and for PDF forms that each field has a Fill with value. Rows that already have a link are skipped when Skip rows that already have a file is on.

Emails didn't arrive or have no signature

Send yourself a test, check spam, check the recipient column has valid addresses, check Add my signature is on for that notification, and look for a quota message in the Log.

The plan still says Free after buying

Click Already bought? on the Move tab. Make sure you bought with the same Google account you use in Sheets. Still stuck? Email support with your purchase email.

17. Turn off or uninstall

To stop automation in one spreadsheet, turn off Move instantly and Run on a schedule in Behavior and save. To remove Tab Transfer completely, go to Extensions → Add-ons → Manage add-ons, open Tab Transfer's menu and choose Uninstall. You can also remove its access at myaccount.google.com/permissions. Attachment files stay in your Drive folder until you delete them.

Still need help? Email support@macrotool.app.