Goodlookup

Goodlookup is a spreadsheet add-on built for people who spend too much time manually reconciling messy text columns. Rather than relying on exACT-string fORMulas, it APPlies natural language processing to judge whether two pieces of text mean roughly the Same thing, then surfaces those connections directly insIDE Google Sheets. The result is a Workflow that feels closer to how a person eyeballs two lists and spots matches than to a rigid VLOOKUP.

What it does

The tool focuses on record linkage: given a column of names, product labels, categories, or free-text notes, it finds entries elsewhere in your sheet that likely refer to the same thing. It also supports topic clustering, so large sets of unstructured text can be grouped by underlying subject instead of surface wording. Descriptive materials reference GPT-3-style language understanding as part of the matching engine, though the exact underlying model may change over time.

Key capabilities

• Semantic matching: compares text by meaning, including synonyms, related concepts, and near-duplicate phrASIng, not just spelling.
• Similarity scores: each suggested match comes with a score indicating how close the two items are, so users can set their own confidence threshold.
• Topic clustering: groups loosely related text into coherent themes, useful for tagging surveys, support tickets, or catalog entries.
• In-sheet workflow: installation runs through the Google Workspace Marketplace, and functions are triggered from the Google Sheets menu, keeping work inside the familiar spreadsheet environment.
• Normalization support: helps when the same entity appears under inconsistent naming conventions across sources.

Who it is for

Goodlookup suits analysts, Operations staff, marketers, and researchers who mAIntain spreadsheets full of inconsistently labeled text. Typical cases include deduplicating vendor or contact lists, mapping product names across two systems, tidying survey responses into categories, and enriching a dataset with tags. Anyone who has built long chains of helper formulas to clean text manually is the core audience.

How to get started

1. Visit the google Workspace Marketplace and install the Goodlookup add-on for your account.
2. Open a Google Sheet containing the text columns you want to compare.
3. Launch Goodlookup from the add-on menu and select the columns to match or cluster.
4. Review the suggested links and similarity scores, then accept or adjust the pairings before writing results back to the sheet.

Pricing and access

Public materials point to a free trial followed by a subscription, but plan tiers, liMITs on matched rows, and current pricing should be confirmed on the vendor's site, as these details may vary. A Google account with Sheets access is required, and organizations with strict add-on permissions may need administrator approval before Installation.