Extract information from Google Sheet

I have a Google Sheet that contains information on 2,400 government programs. One of the columns in the Sheet is “Eligibility”. That column contains the eligibility criteria for each government program. I need the following criteria extracted from the “Eligibility” column and put into separate columns in the sheet:

- Type of Business (for profit, non-profit)
- Legal Structure (registered, sole proprietorship, partnership, incorporated/corporation, co-operative)
- Number of Employees
- Annual Revenue
- Age of Business
- Credit History/Score

Note: I only need the “Employer” or “Candidate” criteria extracted from the “Eligibility” column. For some grant programs, the “Eligibility” column also includes criteria for “Students” or “Interns” - I do *not* need criteria for those.

I have uploaded a sample of the Google Sheet (note: the complete sheet contains 2,400 rows - this is just a small sample):

https://docs.google.com/spreadsheets/d/1PxBJAF5Ez2qtaYjPgb7HVHeWeUa1rR0y6oj_IoonIoY/edit?usp=sharing

The output for this project will be an Excel sheet that contains the additional seven (7) columns mentioned above, containing the relevant information copied from the “Eligibility” column.

Bidders MUST briefly describe similar projects that they have successfully completed.