​
1. Install the Application in Your Workspace

This only needs to be done once per workspace

Go to "EntityMatcher" in the Google Workspace Marketplace and Install the application.

Install EntityMatcher in Google Sheets

​
2. Enable the Plugin in Your Worksheet

This only needs to be done once per worksheet

Click Extensions > Add-ons > Manage add-ons in the menu bar.

Manage Add-Ons

Then click the three dots in the top right corner of the EntityMatcher add-on and select Use in this document.

Use in this document

​
3. Get and Set Your API Key

This only needs to be done once per workspace

Go to this page and click the New API Key button. Copy and save the key to a secure place.

Once you've retrieved the API key, add it to the plugin by clicking Extensions > EntityMatcher > API Key in the menu bar.

Open API Key Dialog

Paste in your API Key and click Ok.

Add API Key

​
4. Start a Match Job

If all the data that you want is in the same worksheet, use the =ENTITYMATCH custom formula. Here’s an example formula:

=ENTITYMATCH(A1:E51,"id", google!A1:E44, "id", "test_google_sheets_matching")
  • The first parameter covers the base_dataset which is the dataset with every record that you want to be matched. This should be a range of cells
  • The second parameter is the base_id_column which is the column in the base_dataset that contains the unique identifier for each record. This should be a value, not a cell
  • The third parameter covers the match_dataset which is the dataset with the records that you want to match against the base_dataset. This can be the same as the base_dataset if you are, for example, trying to de-duplicate the dataset. Thisb should be a range of cells
  • The fourth parameter is the match_id_column which is the column in the match_dataset that contains the unique identifier for each record. This should be a value, not a cell
  • The fifth parameter is the match_job_name which is the name of the match job that you want to use. This should be unique within the worksheet if you are using multiple match jobs
For the base_dataset and match_dataset, select the entire datasets, including the column headers, and not just the individual rows

Once you press enter, the relevant cells will be populated with Loading...

ENTITYMATCH formula

​
5. Refresh Values

You can't just press enter to refresh the values because of the way Google caches results. Instead, click Extensions > EntityMatcher > Jobs in the menu bar.

Open Jobs Sidebar

Find your job (it should have the same job_name that you specified in the formula) and click Refresh.

Refresh Job

If you can't find your job, you can reload all jobs by clicking the Refresh button at the bottom of the sidebar.

Reload All Jobs

ApplicationGet all matches