Send Each Google Sheets Tab to a Different Email?

Updated 5 November 2026 · Standard formula, shown below

Yes, you can send each sheet (tab) in a Google Sheets spreadsheet to a different email address, but Google Sheets does not provide a built-in command that automatically routes every tab to a separate recipient. You can send tabs individually by exporting or copying them, or automate the process with a Google Apps Script or an add-on, depending on how often you need to do it.

What “each sheet” means

A Google Sheets spreadsheet can contain multiple sheets, shown as tabs along the bottom. A regular sharing invitation applies to the spreadsheet file, not to one selected tab: people you give access to can generally access the file’s other tabs too. Hiding a tab is not a reliable way to keep its contents private.

That distinction matters if each recipient should see only their own data. Sending a tab as a separate attachment or creating a separate spreadsheet for each person can isolate what you send. Simply sharing the original spreadsheet with different people does not create tab-level permissions.

Send a tab manually

For an occasional task, prepare one tab at a time and send it as its own file. One practical route is to create a new spreadsheet for the tab, then email that new file or download it as an attachment. Menu labels can vary slightly as Google updates its interface, but the basic workflow is:

Open the spreadsheet and select the tab you want to send.
Copy the tab’s contents into a new spreadsheet, or use the sheet-copy option to copy it into a new spreadsheet if that option is available.
Check the new file for formulas, linked data, hidden rows or columns, and information that should not go to the recipient.
Use the new file’s Share controls to invite the intended recipient, or download it in a suitable format and attach it to an email.
Repeat for each tab and recipient. Verify the recipient and attachment before sending.

A copied tab may include formulas that refer to other tabs in the original file. Those formulas can fail or behave differently when copied alone, especially if they rely on data elsewhere in the workbook. If the recipient only needs a snapshot, consider copying the relevant range and pasting values into the new file. If formulas should remain usable, inspect their references and test the copy first.

Send a tab as an attachment

Google Sheets’ email options may let you email a spreadsheet as an attachment in a chosen file format, but the standard send flow is for the spreadsheet file rather than an automatic “one tab to one recipient” distribution rule. To send only one tab, first make a separate file containing that tab, then attach or share that separate file.

Formats such as PDF or Excel are useful when a recipient needs a readable copy rather than an editable Google Sheet. A PDF can preserve a presentation layout, while an Excel file may retain spreadsheet data and formulas but can display or calculate some features differently. Before sending, check print settings, page breaks, selected ranges, and whether the exported file contains only the intended information.

Automate recurring emails

If this is a repeated report, Google Apps Script can automate the workflow. A script can read a mapping of tab names to email addresses, create or export a separate file for each tab, and send an email with the corresponding attachment. A script can also send a link to a separately generated spreadsheet, rather than attaching a file.

Automation needs careful setup. A typical design includes:

A clear list matching each tab to its recipient or recipients.
Logic to create a separate output containing only the intended tab and any required values or formatting.
An email step that uses the correct recipient and an appropriate attachment or link.
Checks for missing tabs, duplicate addresses, empty reports, and failed sends.
A schedule or manual trigger, plus a way to review the output before distribution.

Apps Script may request permission to access spreadsheet data and send email, and automated executions run under an account with applicable permissions and service limits. Review the script’s behavior and Google’s current Apps Script documentation before relying on it for business-critical distribution. Do not assume a script or add-on can enforce privacy if the output file itself is shared too broadly.

Choosing the right method

Choose based on frequency, editability, and confidentiality:

One-time, small task: create a separate spreadsheet or export a separate attachment for each tab.
Recurring distribution: use a reviewed Apps Script or a reputable workflow tool with permissions suited to the task.
Recipients need to edit: share separate files with the appropriate access level, rather than sending a static PDF.
Recipients only need to read: a PDF or a view-only separate file may be sufficient.
Data must stay separated: create independent files and inspect their contents and sharing settings; do not rely on hidden tabs or filtered views.

For a small number of tabs, manual preparation is often easier to audit. Automation saves repetitive work but adds maintenance: tab names, recipient lists, and source data can change, and a mistaken mapping can send sensitive information to the wrong person.

Common problems and privacy checks

A frequent misconception is that protecting or hiding a sheet makes it safe to share the workbook with someone who should not see that sheet. Protection is intended to limit editing, not to provide separate viewing permissions. If recipients must not access other tabs, give them a different file containing only the information they are meant to receive.

Before sending, check for more than the visible cells. Review hidden rows and columns, notes, comments, formulas, named ranges, charts, and linked data. In a new spreadsheet, also check the sharing list: copying or exporting data does not automatically guarantee that the resulting file has the right access settings. Send a test to yourself or review the attachment before distributing it to a group.

If a copied tab shows formula errors, inspect whether formulas refer to other sheets or external data. If an attachment looks incomplete, confirm that the correct tab or range was exported and check the document’s print or export settings. If an automated email did not arrive, check the script’s execution history, permissions, recipient address, and any applicable sending limits.

Frequently Asked Questions

Can I email only one tab from Google Sheets?
Yes. Put the tab’s contents into a separate spreadsheet or export a separate copy, then email or share that file. The usual spreadsheet email workflow does not automatically assign different tabs to different recipients.

Can different people have access to different tabs in one spreadsheet?
Not as a dependable tab-by-tab privacy setting. Sharing is controlled at the file level, so use separate files when recipients should not see one another’s data.

Will copying a tab keep its formulas?
Often, but formulas that depend on other tabs, ranges, or data sources may not work in the new file. Test the copy, adjust references, or paste values if the recipient needs a fixed snapshot.

Can Google Apps Script send each tab to a different address?
Yes, a script can be written to map tabs to recipients and send separate files or attachments. It requires permissions, testing, and ongoing checks to prevent incorrect or unintended distribution.

Is hiding a sheet enough to protect it from recipients?
No. Hidden tabs are not a substitute for access control. Create separate files that contain only the data each recipient is authorized to receive.

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.