In this article, we will learn how to import Merriam-webster Data to Google Sheets. Merriam-Webster is the oldest dictionary publisher in the United States of America. Besides publishing dictionaries, the American company also publishes reference books.
To import Merriam-Webster data to Google Sheets, we follow the steps below:
How to import Merriam-Webster data to Google Sheets
Follow the steps given below to learn how to import Merriam-Webster Data to Google Sheets.
Step 1: Get the API key
Register for a developer account here to import Merriam-Webster data to Google Sheets.
Fill in all the fields and choose the relevant API key for the data you wish to import to Google Sheets. As an example, we will be choosing the API keys for “Medical Dictionary” and “School Dictionary”.
Find the Application URL for the relevant API key here and click “Register”.
Click on the verification link sent to the registered email address. Upon clicking, you will be taken to the developer website of Merriam-Webster and asked to sign in.
Once signed in, you will be redirected to the developer center of Merriam-Webster. Navigate to “Your keys” to find the API keys requested while registering previously.
The API keys will be visible on your screen as shown below.
Step 2: Choose the API endpoint
On clicking the key for medical dictionary, you will be redirected to the website containing the API endpoint URL.
Copy the link under the heading Direct Browser URL. This is the API endpoint URL which will be used to import Merriam-Webster data to Google Sheets using the Amigo Data add–on.
Step 3: Get Amigo Data Google Sheets extension
The Amigo Data Add-on is an extension in Google Sheets that allows you to import data from various sources without coding.
You can either install the extension directly from the Google Workspace Marketplace or follow the steps below:
- Open a new google sheet
- Click on Extension→ Add-ons→ Get Add-on
- Search for “Amigo Data” and install it.
Step 4: Import the data to Google Sheets
Go to the Google Sheet in which you want the data to be pasted. Click on Extensions→Amigo Data→Connect
Select Custom API from the list of sources
Paste the API endpoint URL copied earlier as shown below and click Preview.
Continue flattening the data until the data is presented under relevant column headings using the Flatten option. Once done, you can click on Import to get the required format data in the concerned Google Sheet.
Once you have clicked on Import, after some time you will observe that your google sheets are filled with the different meanings of “test” available in Merriam-Webster.
Note: To import the meanings of a different word, change the word before the “?” in the endpoint URL before using it in the Amigo Data Add-on.
You can find the different API endpoints that you can request when you sign in to the Merriam-Webster Developer Zone here.
Note: The Merriam-Webster API limits to 1000 queries per day per API key, and its use is limited to two reference APIs.
Amigo Data Add-on makes it effortlessly simple to import data from various sources to your Google Sheets. It also allows users to set a refresh schedule that automatically updates the imported data ensuring that the user is provided with the latest data always. Learn how to automatically refresh the imported data and receive emails for the same on your Slack or email by clicking here.
In this article, we have successfully learned how to import Merriam-Webster data to Google Sheets using the Amigo Data Add-on. To expand the sources from which you can import data and perform several operations on them, check out our blog.
Below you will find some related articles on how to import data from a variety of sources.