​
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 Transform Job

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

=ENTITYTRANSFORM(A1:E44, "id", "get the vendor and indicate whether the product is software or not, two separate fields", "plugin-transform-test-v1")
  • The first parameter covers the dataset which is the dataset with every record that you want to be transformed. This should be a range of cells
  • The second parameter is the id_column which is the column in the dataset that contains the unique identifier for each record. This should be a value, not a cell
  • The third parameter covers the user_instructions which is the instructions that are passed to the application describing the transformation that you want to perform. This should be a value, not a cell
  • The fourth parameter is the transform_job_name which is the name of the transform job that you want to use. This should be unique within the worksheet if you are using multiple transform jobs
For the dataset, select the entire dataset, including the column headers, and not just the individual rows

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

ENTITYTRANSFORM 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 transforms