In-Depth Analysis.
Google sheets formula on integromat -fuzzy lookup for sheets
Automated name matching based on name similarity using integromat and google sheets fuzzy add on.
In this tutorial we will show how to automate name matching based on text similarity using fuzzy look together with integromat.
Fuzzy Lookup for Sheets is a Smart Add-on for sheets that allows partial name matching Click here to download fuzzy lookup for sheets
Integromat lets you connect apps and automate workflows in a few clicks. Move data between apps without effort so you can focus on growing your business.
For this case we use fuzzy lookup addon to retrieve data based on text similarity as show on the table below.
The source data is on the table show below:
To perform the above match we use integromat features for google sheets as shown below we will use watch rows feature to watch for new rows and use the update a row together with a fuzzy lookup for sheets for formula to perform matches.
Watch rows trigger of integromat allows us to see any new data added to google sheets then we use update row to perform text similarity using the fuzzy lookup for sheets addon.