Enrichments /
No-Code Enrichment with
Use the National Plan and Provider Enumeration System (NPPES) API To Fetch Provider Information
Sign Up Free

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.

sample spreadsheet for the nppes api

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. 

paste in nppes api request from the documentation

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.

highlight fields to customize within the nppes api

Here you can see all of the columns inserted:

nppes api ready for execution

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.

Gigasheet preview of first 3 responses from nppes api

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.

confirm execution of the nppes api on all rows

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.

gigasheet enriched with data from the nppes api
Try it Out

The ease of a spreadsheet with the power of a database, at cloud scale.

No Code
No Database
No Training
Sign Up, Free Forever