- 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
- 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'.
- 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).
- 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
