Need Help With Grant Scrubbing Workflow Im creating

Hello Community,

Im new to N8N and automating workflows but Im determined to learn and asking from people with experience to mentor me to be great at this. I built a Grant Scrubbing Agent for a friend but this is technically my first use case and I want to build credibility and knowledge so I took on the task of trying to learn this on my own. Im very frustrated because I dont understand the Http Request node or how I could get this workflow to work. I have attached my workflow:

Basic Understanding of the Grant Scrubber:

I receive a sheets list of applicants for a grant submitted through an online form. Im tasked to go through hundreds or thousands of applicants to qualify them or disqualify them based on

  1. Must be a small business making less than $500,000 in revenue ( can be a start -up…. $0-%500,000)
  2. Must be registered in the state youre boing business in ( iu normally check these one by one going to each secretary of the state website)

** Note, some applicants do not spell their state correct or incorrect state abbreviates or countries out side of the U.S. and some have revenue well over 500,000….) the get disqualified or if its an incorrect spelling get sent for human review.

Now that you get the context, Im submitted what i’ve created. Ive used the help fo chatgpt with the code writing and some of the nodes. But i also used what I’ve learned through youtube tutorials and learning as I go. Hope someone can help

Hey @Eric_Gibbons !

The HTTP node can be configured easily if you know what format does “some free API” expects.

What errors do you have on your HTTP node?

Well the http request nodes I currently have are for opencorporates api but there is no free api with opencorporates or sba.gov . That is just the logic and I’m trying to figure out how I can get request from each states Secretary of State to validate whether a company exist or not and is active or not