goodlookup

goodlookup is a smart function for spreadsheet users, described as a pre-trained model with the intuition of GPT-3 combined with the join capabilities of fuzzy matching. It can be used like vlookup or index match to speed up topic clustering work in Google Sheets. The page says it can match semantic relationships, synonyms, and cultural similarities between text strings, and it is positioned as a complement to traditional fuzzy matching rather than a replacement. The page describes a setup flow: subscribe, install goodlookup from the Google Workspace Marketplace, then activate the function via sheet menu > extensions > manage add-ons. A score next to each match indicates the intensity of the neighboring words in the vector space.

Key features

• Smart function for Google Sheets
• Works like vlookup or index match
• Semantic matching of text strings, including synonyms and cultural similarities
• Matches text records without uniform naming conventions
• Match score indicating similarity intensity in vector space
• Installed via Google Workspace Marketplace

Best suited for

• Spreadsheet users doing text-to-text record linking
• Topic clustering work in Google Sheets
• Joining data stored in multiple places with inconsistent naming

Pricing

Yearly subscription at US $15 per year