In-Depth Analysis.

Google sheets formula on Zapier using fuzzy lookup for sheets

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.

--

--

--

I am Risk Consultant working for a Swiss Fintech. I help Banks fight Fraud using big data technologies.Data Science/Machine Learning/

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Stats Accelerator — Acceleration Under Time-Varying Signals

COVID-19: excess mortality figures in Italy

Maximum likelihood estimation and OLS regression

A Very Simple Data Integration Project: Rebrickable Datasets

Funds shun sterling as UK data dam bursts: McGeever

Time Series Model(s) — ARCH and GARCH

Demand Insighter | Higu Baruah

BERT Model Embeddings aren’t as good as you think

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Bena Brin

Bena Brin

I am Risk Consultant working for a Swiss Fintech. I help Banks fight Fraud using big data technologies.Data Science/Machine Learning/

More from Medium

The best alternative to Desktime.

How To Boost Profits Using Videos As Backend Products

Convert Xero Journals for Netsuite and Dynamics

How to Manage Two -Factor Authentication in WHM?