Use the National Plan and Provider Enumeration System (NPPES) API To Fetch Provider Information

The U.S. Department of Health and Human Services (HHS) NPI Registry Public Search is a free directory of all active National Provider Identifier (NPI) records. Healthcare providers acquire their unique 10-digit NPIs to identify themselves in a standard way throughout their industry. The National Plan and Provider Enumeration System (NPPES) NPPES API allows systems to access NPPES public data in real-time and retrieves data from NPPES daily.

Provider Website: https://npiregistry.cms.hhs.gov/api-page
‍Provider Enrichment Docs: https://npiregistry.cms.hhs.gov/demo-api
‍Endpoint: https://npiregistry.cms.hhs.gov/api/
‍Token / Registration Required: No

‍

How To Enrich A Spreadsheet With HHS NPI Data:

For this example, my data looks like this. It is a list of physicians and medical providers first and last names, and their city and state.

Step 1. In Gigasheet, head to the Enrichments function and select Custom Enrichment. First we paste in the URL request generated by the API demo here: https://npiregistry.cms.hhs.gov/demo-api

In my example I put in first name, last name, city, and state since those columns exist in my sheet, but you could use any of the fields available in the demo form. 

Step 2. On the next screen we’ll insert the column variable from our Gigasheet sheet for the prompt. In this case, we highlight FIRST, in the input, and then select our First Name column and click +Insert Column Reference. I’ll do the same for Last Name, City and State. Then click Next.

Here you can see all of the columns inserted:

Step 3. In this screen we see a preview of the results. Gigasheet makes requests for the first three rows and shows the HHS NPPE response. At this point select the fields you want to be inserted into your sheet. In this case I’ll select the street address fields and the Medicaid IDs.

Step 4. Finally, confirm the number of requests is to your liking, and when ready click Run to kickoff the custom enrichment process. It’s ok to leave or close the sheet; the custom enrichment will keep running and you’ll receive an email once the job has been completed. You can monitor the progress of your enrichment, or cancel the job at the top of the sheet.

Step 5. Once completed, Gigasheet will send a completion alert and refresh the page. The result will show generation of new columns in blue based on the API. In this case we see the address information was added, and columns for Medicaid appear to the right.