Hello guys, I need some wisdom to be bestowed upon me. Simple outline of my flow -
- Get google sheet data from google drive
- Go through each row, passing data (Name, org name, org website) into ChatGpt (Openrouter)
- Get html of website using http module
- Pass html into Chatgpt as well
- Parse the output from ChatGpt (again, openrouter)
- Store result back into a specific column in the same google sheet already filled with other data
This flow is using wayy to much ops, I’m planning to personalize over 14k emails with it, I would really appreciate your help. Thanks in advance.