Installation & Setup

Get SheetClean up and running in your Google Sheets in just a few minutes.

Installing from Google Workspace Marketplace

SheetClean is available directly from the Google Workspace Marketplace, making installation quick and secure.

Step 1: Find SheetClean

1. Open any Google Sheets document
2. Click Extensions in the top menu
3. Select Add-ons → Get add-ons
4. Search for "SheetClean" in the marketplace
5. Click on the SheetClean result

Alternatively, visit the SheetClean listing directly in the Google Workspace Marketplace.

Step 2: Install the Add-on

1. Click the blue Install button
2. Review the permissions SheetClean needs:
   • View and manage spreadsheets
   • Display and run content from the web
   • Connect to an external service
3. Click Continue
4. Select your Google account
5. Click Allow to grant permissions

Why these permissions? SheetClean needs to read your spreadsheet data to find duplicates, and connect to our servers to verify your subscription and store your automation settings.

Step 3: Complete Installation

Once installed, you'll see a confirmation message. SheetClean is now ready to use!

First-Time Authorization

The first time you open SheetClean, you'll need to authorize it to access your spreadsheet.

1. Open any Google Sheets document
2. Click Extensions → SheetClean → 🧹 Run SheetClean
3. If prompted, click Authorize or Continue
4. Select your Google account
5. Click Allow

You only need to do this once. SheetClean will remember your authorization for all future spreadsheets.

Opening SheetClean

There are two ways to open SheetClean:

Method 1: Quick Launch (Recommended)

1. Open your Google Sheets document
2. Click Extensions in the menu
3. Select SheetClean → 🧹 Run SheetClean

The SheetClean sidebar will open on the right side of your spreadsheet.

Method 2: From the Menu

1. Open your Google Sheets document
2. Look for the 🧹 SheetClean menu in the top menu bar
3. Click it to see all available features
4. Select 🧹 Run SheetClean to open the sidebar

Understanding the Sidebar

When you open SheetClean, you'll see a clean, organized sidebar with several sections:

Sheet Information Bar

At the top, you'll see your current sheet name and selected range. Use the icons to:

• Select all data - Automatically select all data in your sheet
• Sync range - Update the display to match your current selection

Main Features

SheetClean organizes features into three categories:

🔍 Find

• Find Duplicates - Locate duplicate rows across multiple columns
• Find Duplicate Cells - Detect duplicate values at the cell level

🗑️ Remove

• Remove Duplicates - One-click duplicate removal
• Merge Duplicates - Combine duplicate rows into single entries

📊 Compare

• Compare Sheets - Find duplicates across different sheets
• Compare Columns - Compare two columns for matches or differences

Automations & Schedules

Below the main features, you'll find:

• 🤖 Automations - Your saved automation scenarios
• ⏰ Active Schedules - Upcoming scheduled runs

Subscription Status

At the bottom of the sidebar, you'll see your subscription status:

• Free Trial - Shows days remaining in your 7-day trial
• Premium - Active paid subscription
• Expired - Trial ended, upgrade to continue

Click Upgrade to view pricing and subscribe.

Your Free Trial

When you first install SheetClean, you automatically get a 7-day free trial with full access to all features:

• ✅ Find duplicates across unlimited rows
• ✅ Create and save unlimited automations
• ✅ Schedule up to 2 runs per day
• ✅ Compare sheets and columns
• ✅ Automatic backups before changes
• ✅ Priority support

No credit card required to start your trial!

Next Steps

Now that SheetClean is installed, you're ready to:

1. Run your first duplicate check - Learn the basics in 5 minutes
2. Explore features - Try out the different duplicate detection methods
3. Set up automation - Save time by automating repetitive tasks

Need Help?

If you encounter any issues during installation:

• Check permissions - Make sure you granted all required permissions
• Try refreshing - Reload your Google Sheets document
• Contact support - Email us at [email protected]

---

Ready to clean your data? Continue to the Quick Start Guide to run your first duplicate check.