Smart Join Google Sheets add-on interface

Smarter Data Joins in Google Sheets

Smart Join helps marketers, analysts, and teams quickly merge multiple sheets into a single clean dataset with pivots, de-duplication, and automation.

Get Started
Screenshot: joining multiple tabs into one dataset
Screenshot: pivoting metrics by date and platform

Who Smart Join Is For

Marketers

Combine campaign data from different sources to analyze performance.

Analysts

Clean and merge complex datasets for deeper insights without leaving Sheets.

Agencies

Streamline client reporting by automating data aggregation tasks.

Why Choose Smart Join?

Automated Joins

Merge data from multiple sheets with a single click. No more VLOOKUP nightmares.

Pivot-Ready

Automatically normalizes your data, making it perfectly structured for pivot tables.

One-Click Scheduling

Set up automated refreshes to keep your master dataset always up to date.

Inside Google Sheets

Works directly where your data lives. No need to export or use other tools.

Pricing Plans

Free

For individuals getting started.

$0/mo

  • Free plan: up to 4 tabs of joined data
  • 100 rows per tab
  • Manual refresh
Most Popular

Pro

For professionals and power users.

$19.99/mo

  • Unlimited joins
  • Advanced de-duplication
  • Scheduled refreshes
  • Priority support

Yearly

For professionals and power users that love a deal.

$199/yr

  • Everything in Pro
  • 12 months for the price of 10

Stripe pricing table will be embedded here.

Frequently Asked Questions

What is Smart Join?
Smart Join is a Google Sheets add-on that combines data from multiple tabs into a unified, clean output with options for pivots and automated refresh.
How does Smart Join work?
Select source tabs, choose key fields (e.g., Date, Platform), and Smart Join merges them into a structured output ready for analysis.
Why can't I see all my data in the join?
Free plans may have row caps, so large datasets can be truncated. Upgrade to Pro to unlock full joins and scheduling.
Manual vs. Scheduled vs. On-Change refresh
Manual is available to all users; Scheduled (hourly/daily/weekly) and On-Change refresh are paid features for automation.
Why don’t my Pivot totals look right?
Source data may use inconsistent date/number formats. Smart Join normalises common formats, but ensure inputs are valid dates and numeric values.
Does Smart Join edit my source tabs?
No. Smart Join reads from your selected tabs and writes the merged result to a destination sheet you choose.
What data types are supported?
Text, dates, and numeric fields are supported. Smart Join includes pivot-aware numeric coercion (currency, percentages, error-to-zero handling).
Is my data secure?
Yes. We request the minimum Google OAuth scopes, process data in your current spreadsheet, and comply with Google’s Limited Use requirements.
How do I install or uninstall?
Install from Google Workspace Marketplace. To remove, go to Extensions → Add-ons → Manage in Google Sheets and uninstall Smart Join.
Where can I get support?
Email support@smartjoin.co and we’ll get back to you. Or fill in the contact form below.

Contact Us

Privacy Policy

Last updated: 30 September 2025

This Privacy Policy explains how Smart Join (“Smart Join”, “we”, “us”, or “our”) collects, uses, discloses, and protects personal information when you use our website, apps, and related services (collectively, the “Services”). By using the Services, you agree to this Privacy Policy.

Who we are & contact

Controller: Smart Join. Questions or requests: privacy@smartjoin.co.

Information we collect

  • Account & profile data: name, email address, organisation, role, and preferences you provide when creating an account or interacting with the Services.
  • Billing data: payment method details (processed by our payment provider), billing address, tax details, subscription plan, and transaction history.
  • Usage data: log files, device and browser info, IP address, timestamps, pages viewed, referring/exit pages, and feature interactions.
  • Support content: messages, attachments, and any information you submit to our support channels.
  • Integrations data: if you connect third-party services (e.g., Google Sheets), we access only the scopes you authorise to provide the Service features.
  • Cookies & similar tech: small files used for session management, analytics, preferences, and security. See “Cookies” below.

How we use information

  • Provide, operate, and maintain the Services, including authentication and core functionality.
  • Process payments, manage subscriptions, and send transactional communications (e.g., receipts, service notices).
  • Respond to enquiries and provide customer support.
  • Monitor, prevent, and detect fraud, abuse, security risks, and technical issues.
  • Improve and develop new features, including aggregated and de-identified analytics.
  • Comply with legal obligations and enforce our terms.
  • With your consent, send product updates, tips, and marketing. You can opt out at any time.

Legal bases for processing (GDPR/UK GDPR)

  • Contract: to provide the Services you requested.
  • Legitimate interests: to secure, improve, and market our Services proportionately.
  • Consent: for certain cookies/marketing where required.
  • Legal obligation: to meet record-keeping, tax, and compliance requirements.

Sharing & disclosures

We do not sell your personal information. We may share it with:

  • Service providers: trusted vendors who process data on our behalf (e.g., hosting, analytics, email, customer support). They are bound by confidentiality and data protection obligations.
  • Payment processing: Stripe processes payment information; we do not store full card numbers on our systems.
  • Integrations you enable: if you connect third-party services (e.g., Google), we exchange data as necessary to provide the integration.
  • Legal & safety: to comply with laws, court orders, or to protect rights, property, users, or the public.
  • Business transfers: in a merger, acquisition, or asset sale, your information may be transferred consistent with this Policy.

International transfers

Your information may be processed in countries other than your own. Where required, we implement appropriate safeguards (e.g., Standard Contractual Clauses) to protect your information.

Data retention

We retain personal information only for as long as necessary to provide the Services, comply with laws, resolve disputes, and enforce agreements. When no longer needed, we delete or de-identify data in accordance with our policies.

Security

We use administrative, technical, and organisational measures designed to protect personal information. No system is 100% secure; you are responsible for maintaining the confidentiality of your account credentials.

Cookies

We use cookies and similar technologies to keep you signed in, remember preferences, enable functionality, and perform analytics. You can control cookies via your browser settings. Disabling some cookies may affect certain features.

Your rights

  • Australia (APPs): you may request access to and correction of personal information. You can also lodge a privacy complaint (see “Contact & complaints”).
  • EEA/UK: rights include access, rectification, erasure, restriction, portability, objection, and withdrawal of consent (where processing is based on consent).
  • California (CCPA/CPRA): residents may request to know, delete, correct, and opt out of sharing for cross-context behavioural advertising. We do not sell personal information.

To exercise your rights, contact privacy@smartjoin.co. We may need to verify your identity.

Children

Our Services are not directed to children under 13 (or under the age required by local law). We do not knowingly collect personal information from children. If you believe a child has provided personal information, contact us to delete it.

Third-party links & services

The Services may link to third-party sites or services. Their privacy practices are governed by their own policies. We encourage you to review them.

Do Not Track

Some browsers offer “Do Not Track” signals. Because there is no industry standard for DNT, we do not respond to these signals at this time.

Changes to this policy

We may update this Privacy Policy from time to time. The “Last updated” date reflects the latest changes. Material changes will be notified via the Services or by email where appropriate.

Contact & complaints

Questions, requests, or complaints: privacy@smartjoin.co.

Australia: If you are not satisfied with our response, you can contact the Office of the Australian Information Commissioner (OAIC). EEA/UK: you may contact your local data protection authority.

Google User Data (Workspace Add-on)

Smart Join requests the minimum Google OAuth scopes needed to work inside your active Google Sheet. We use Google user data only to deliver the features you ask for. We do not sell Google user data or use it for advertising or personalization.

Human access: We do not allow humans to read Google user data unless you give explicit consent, it’s necessary for security/bug/abuse investigations, or we’re legally required.

Scopes & purpose

  • https://www.googleapis.com/auth/spreadsheets.currentonly — read selected tabs and write joined/pivoted results in the current spreadsheet.
  • https://www.googleapis.com/auth/script.container.ui — render the sidebar UI, dialogs, and menus.
  • https://www.googleapis.com/auth/script.scriptapp — create/manage user-initiated installable triggers for scheduled or on-change refresh.
  • https://www.googleapis.com/auth/script.external_request — secure server-to-server calls (e.g., Stripe) via UrlFetch.
ScopeWhy we need itStored?Shared?Retention
…/spreadsheets.currentonly Read source tabs & write outputs in the current spreadsheet In your Sheet; not stored on Smart Join servers No (processors only) N/A (in-Sheet)
…/script.container.ui Sidebar/dialog UI No sheet content stored No (processors only) N/A
…/script.scriptapp User-initiated triggers (scheduled/on-change) Minimal config (e.g., join settings) if you enable scheduling No (processors only) Until you remove the join or request deletion
…/script.external_request Secure calls to Stripe endpoints No Google sheet content transmitted No (processors only) N/A

Limited Use

The use of information received from Google APIs will adhere to the Google API Services User Data Policy, including the Limited Use requirements.

Disconnect & deletion

You can remove the add-on from Extensions → Add-ons → Manage at any time. To request deletion of server-side metadata associated with your account (if any), email privacy@smartjoin.co. We delete within 30 days, subject to legal retention.

Domain installs & admins

For domain-wide installs, Workspace administrators may control access through Google Admin. We do not access domain data beyond the scopes you authorise.

Additional Stripe & Google disclosures

  • Stripe: payment info is processed by Stripe according to its own privacy terms. We receive limited billing metadata necessary to manage your subscription.
  • Google connections: where you authorise Google scopes (e.g., Google Sheets), we access only the data necessary to fulfil the requested features and do not use Google-sourced data for advertising.

This Policy is provided for general information and does not constitute legal advice.

Terms of Service

Last updated: 30 September 2025

Acceptance of Terms

By accessing or using our website, products, or services (collectively, the "Services"), you agree to be bound by these Terms of Service ("Terms"). If you do not agree to these Terms, you may not use the Services.

Eligibility

You must be at least 18 years old or have the consent of a parent or guardian to use the Services. By using the Services, you represent and warrant that you meet these eligibility requirements.

User Responsibilities

You are responsible for your conduct, the content you submit, and your communications with others while using the Services. You agree not to:

  • Use the Services for any unlawful purpose or in violation of any applicable laws or regulations.
  • Interfere with or disrupt the integrity or performance of the Services.
  • Upload or share malicious software, viruses, or harmful code.

Accounts

When you create an account with us, you must provide accurate and complete information. You are responsible for safeguarding your password and for all activities that occur under your account.

Intellectual Property

All content, features, and functionality of the Services (including but not limited to text, graphics, logos, icons, images, and software) are the exclusive property of Smart Join and its licensors, and are protected by intellectual property laws. You may not copy, reproduce, modify, distribute, or create derivative works without our prior written consent.

Payment Terms

For paid Services, you agree to pay all applicable fees. Payments are processed securely through Stripe, our third-party payment processor. By using our paid Services, you also agree to comply with Stripe's Terms of Service.

Subscriptions & Cancellation

Subscriptions renew automatically at the end of each term unless cancelled. You may cancel at any time; access remains until the end of the current billing period. Unless required by law, fees are non-refundable once a period has started. Any applicable trials are one per customer unless stated otherwise.

Limitations of Liability

In no event shall Smart Join, nor its directors, employees, partners, agents, suppliers, or affiliates, be liable for any indirect, incidental, special, consequential, or punitive damages, including without limitation, loss of profits, data, use, goodwill, or other intangible losses, arising out of or in connection with your use of the Services.

Indemnification

You agree to indemnify and hold harmless Smart Join and its affiliates, employees, and agents from any claims, damages, liabilities, costs, or expenses (including legal fees) arising out of your use or misuse of the Services or your violation of these Terms.

Availability & Support

We aim to keep the Services available, but they may occasionally be unavailable for maintenance or due to factors outside our control. Unless expressly agreed, we do not provide an uptime SLA. Support is available via privacy@smartjoin.co.

Data Export

You may export your joined results from Google Sheets at any time. Removing the add-on does not delete data already written to your spreadsheets.

Email Communications

We may send you transactional emails (e.g., receipts, service notices). Marketing emails are sent only with your consent, and you can unsubscribe at any time.

Google APIs & Workspace Marketplace Compliance

When Smart Join accesses Google APIs, we comply with the Google API Services User Data Policy (including the Limited Use requirements), applicable Google OAuth policies, and Google Workspace Marketplace program policies. Your installation and use of the add-on are also subject to the Google Workspace Marketplace Terms.

Termination

We may terminate or suspend your account and access to the Services immediately, without prior notice or liability, for any reason, including but not limited to a breach of these Terms. Upon termination, your right to use the Services will cease immediately.

Governing Law

These Terms shall be governed by and construed in accordance with the laws of New South Wales, Australia, without regard to its conflict of law principles. Any disputes shall be subject to the exclusive jurisdiction of the courts located in New South Wales.

Changes to Terms

We reserve the right to modify or replace these Terms at any time. Changes will be effective immediately upon posting to this page. Your continued use of the Services after such changes constitutes your acceptance of the new Terms.

Contact Us

If you have any questions about these Terms, contact us at privacy@smartjoin.co.