• Demonstrate openFDA API applied to Google Sheets.
• Create a replica of the FDA's NDC Directory

• Google Apps Script (Javascript)
• Note: I have also translated this repository to VBA for Microsoft Excel

1. In order to use/edit the script for personal use, make a copy of the original Google Sheet. To make a copy, click 'File' then click 'Make a copy'.
2. When you open the file, a new menu labeled 'openFDA' should appear (see images). Simply run the API by using the 'Run API' submenu (see images).
3. This code runs the API using 1 of 5 parameters (brand name, generic name, application number, manufacturer, or product NDC) and outputs the result to the active sheet.

Note: The parameters do not support partial spelling