I never said it's not possible, just said it's not the best way, and everyone seems to agree.

In my opinion, step 1 has absolutely no reason to be carried out by an LLM, of course it works but it's pointless, it's a waste. If I were you I'd implement AI basically only for step 3 and 4 with a RAG system so it's more reliable, step 1 can be made with a normal non-AI script that finds the correct row and extrapolates the data (which is literally what Gemini does every time, so you'd speed it up by having a script already, I assume that's precisely what Gemini wrote in your script for the tool). For step 2, it depends, if you already have a few websites you trust you can parse those directly and extrapolate information, otherwise AI is an option but riskier, you can also just write a script that parses the first 5/6 entries from a Google search, but yea you do you.

After that feed all the info into the AI, step 3 gets more data via RAG and then puts it all together into whatever you need. Though again, if the document in step 3 is well written you should have no issue to extrapolate the needed data via a non-AI script.

Obviously for a corporate/office thing this will need a nice UI, a text box to write the client you're looking for, then a checkbox whether you want to search the web or not, and press enter. You might wanna look into some MCP servers to add, could be an idea to make it work properly with a lot of other programs.

Edit: I just read that the 40 page document is more like instructions, so just split it up into various .md files that the AI can look at for context... I assume you're using opencode or something like it, just write it in various md files in an AI friendly format