An add-on to grab whatever U.S. nonprofit tax information you want from the ProPublica Nonprofit Explorer API and put it in a Google spreadsheet!
Nonprofit corporations in the United States have to submit one of a few types of tax forms to the IRS each year, which are then made public. If their total revenue is over $200,000 in a year, they submit a form 990, if it is between $50,000 and $199,999, they submit a form 990-ez, and if it is under $50,000, they submit a 990-N (e-postcard). The information obtained from these forms from 2011-2014 is what has been made available through the ProPublica Nonprofit Explorer API. From this, we might be able to learn:
- Total number of individuals employed
- Total number of employees
- Amount of contributions and grants
- Year of formation
- City and State
- and more!
If you have a list of nonprofit organizations, this will loop through that list, use the API's Search Method to find an org's EIN number, and then use the EIN number and the Organization Method to find out whatever else you want to find out (e.g. total revenues, location, number of volunteers, etc). It then gently places all of that info into your Google Spreadsheet.
Check the Gitter chatroomfor the most up-to-date project information!
Want to quickly test it out? We'll be creating a Google Add-on soon, but for now:
- Open a blank Google Spreadsheet
- Click on the menu item "Tools" > "Script editor..." This will open up another window for editing your own custom scripts.
- Copy Code.gs into the box you see before you.
- Go to File > New > Html file
- Copy in dialog.html
- Press the play button and accept all the permissions
- Go back to your original spreadsheet, and refresh the page
- Enter an EIN number into a cell (lets say the EIN number is 142007220 and the cell is A1), go to another cell and enter =lookUpByEIN(A1)
- Press enter, and you have information on that nonprofit!
Thanks for your interest in contributing! To get started, take a look at CONTRIBUTING.md, and join the chatroom on Gitter.
This project adheres to a code of conduct. By participating, you are expected to uphold this code. Please report unacceptable behavior to maya@opentechinstitute.org.
- Useful code snippets for working with the ProPublica APIs
- Coding with Google Apps Script
- How to work with the Google Sheets API
- ckan-tutorial by Nat
- another piece of that tutorial
- Python client for ProPublica Nonprofit Explorer API
Join us at the Mozilla Global Sprint June 1-2, 2017! We'll be gathering in-person at sites around the world and online to collaborate on this project and learn from each other. Get your #mozsprint tickets now!
