Google Sheets
Start transforming records in under 5 minutes using Google Sheets
1. Install the Application in Your Workspace
Go to "EntityMatcher" in the Google Workspace Marketplace and Install
the application.
![Install EntityMatcher in Google Sheets](https://mintlify.s3-us-west-1.amazonaws.com/pandan/screenshots/gsheets/plugin_install.png)
Install EntityMatcher in Google Sheets
2. Enable the Plugin in Your Worksheet
Click Extensions > Add-ons > Manage add-ons
in the menu bar.
![Manage Add-Ons](https://mintlify.s3-us-west-1.amazonaws.com/pandan/screenshots/gsheets/extensions_manage_add_ons.png)
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](https://mintlify.s3-us-west-1.amazonaws.com/pandan/screenshots/gsheets/plugin_enabled.png)
Use in this document
3. Get and Set Your API Key
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](https://mintlify.s3-us-west-1.amazonaws.com/pandan/screenshots/gsheets/menu_api_key.png)
Open API Key Dialog
Paste in your API Key and click Ok
.
![Add API Key](https://mintlify.s3-us-west-1.amazonaws.com/pandan/screenshots/gsheets/api_key_dialog.png)
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 thedataset
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
dataset
, select the entire dataset, including the column headers, and not just the individual rowsOnce you press enter, the relevant cells will be populated with Loading...
![ENTITYTRANSFORM formula](https://mintlify.s3-us-west-1.amazonaws.com/pandan/screenshots/gsheets/job_transform_formula.png)
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](https://mintlify.s3-us-west-1.amazonaws.com/pandan/screenshots/gsheets/menu_jobs.png)
Open Jobs Sidebar
Find your job (it should have the same job_name
that you specified in the formula) and click Refresh
.
![Refresh Job](https://mintlify.s3-us-west-1.amazonaws.com/pandan/screenshots/gsheets/job_individual_refresh.png)
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](https://mintlify.s3-us-west-1.amazonaws.com/pandan/screenshots/gsheets/job_all_refresh.png)
Reload All Jobs