Google sheets formula on Zapier using fuzzy lookup for sheets
Automated name matching based on name similarity using zapier and google sheets fuzzy lookup add on.
In this tutorial we will show how to automate name matching based on text similarity using fuzzy look together with zapier.
Fuzzy Lookup for Sheets is a Smart Add-on for sheets that allows partial name matching Click here to download fuzzy lookup for sheets
Zapier is a product that allows end users to integrate the web applications they use and automate workflows.
For this case we will use fuzzy lookup addon to retrieve data from world billionaires list and populate our custom google sheets.
The source data is on the table show below:
To perform the above match we use Zapier google sheets feature to watch for new spread sheet rows.
Once a new row is created we automatically update the spread sheets rows using the Fuzzy lookup formula which is able to perform similarity matches.
For the company name we get the data directly from the cell above.
The rowID allows us to track new records and inclemently update the formula downwards
From the data Output below we can see the row was updated by the formula.