Scenario nightmare.... · Automate What Academy

Scenario nightmare....

I'm struggling on a scenario. I just sent you a DM on TikTok about the assistant for google doc templates and using the stuctured output for Open AI into JSON schema. I have 11 modules doing research, then I run them through 6 chatGPT modules, for various reasons, then i have the data dropping into a google sheet with headers. I have a google doc template set up that prepares an Executive summary for a Sales Team. My problem is the template. I'm sure there is a simpliar way to approach this research assistant style scenario. So baically I have the trigger set up when I add a company name and location into the google sheet, then I have a module that takes that information and finds the company URL. The next 8 modules are set up to use the URL found and research certain information concerning the company. Then I have a chatGPT model summarizing 3 of the outputs, and i have a chatGPT module that gives a yes/No answer as to whether the company is a distributor/Reseller. At this point all data collected drops into the google sheet before moving on. Then I have the scenario sleep for 30 sec. before moving on. I have 2 massive prompts in-line next to gather as much data as possible with a 30 second sleep in between them, as well as a chatGPT module in place after each massive research prompt to summarize the findings, and finally I have a module that takes the first set of modules and writes a summary of the data output before finishing up and filling in the rest of the google sheet with the data outputs. I also collect all the citations in the google sheet so i can verify the information collected was accurate. I think I'm in overkill mode. Any help or suggestions on this scenario would be helpful. Here is a screenshot of a messy, and I mean messy scenario.... As you can see I have a boatload of disconnected modules simply because I have been trying out a lot of different methods to get to the end result.

FYI: I also broke this down into smaller steps that ended with adding 'completed' into a cell in google sheets that would trigger the next scenario. I've moved on from that and now have this longer scenario.

7 comments