Can I split a ChatGPT response into multiple variables?
I am trying to create an agent to provide me with the latest Foreign Exchange prices, so there are multiple that needs to be looked at. When I do this, I do not know how to take the response from ChatGPT and split it up so it corresponds to the separate values in Google Slides that I want them to go to, I am not even sure how to use an intermediary step like Google Sheets to paste the information and then split it into different variables. It also seems like only 4o works, and I need o3 to work (for context I have enough credit on my API account to run o3). This is because only o3 has the quality of information I am looking for, as well as the updated information, does anyone know how to get o3 to work - I will show the error message below.
The Many Variables I want to fill out in my Google Slide:
o3 error message:
Page 1 / 1
@abzakhali Are you just using o3 to look up current exchange rates online? If so, that’s not something you need AI for, and it’ll be cheaper, faster, and more accurate to use a deterministic data source for that.
if I’m misunderstanding, please include a copy of the prompt you’re using and I’ll see if I can give any pointers.
Hi @abzakhali
Try using this Zap action: AI by Zapier - Analyze and Return Data
You can select OpenAI as the Provider, use your Authentication, and choose the Model.
You can specify Input/Output fields.
@Troy Tessalone I don’t have access to the feature you seem to be advertising, where would I be able to find it in order to use the feature and extract accurate daily information?
@abzakhali Are you just using o3 to look up current exchange rates online? If so, that’s not something you need AI for, and it’ll be cheaper, faster, and more accurate to use a deterministic data source for that.
if I’m misunderstanding, please include a copy of the prompt you’re using and I’ll see if I can give any pointers.
Hello @DennisWF @Troy Tessalone ,
I also have a writeup about Daily Forex News, International and Regional Financial News, Local Financial News, and a “On This Day In Finance” section. The core of the issue, is that no matter what, I cannot use the web search feature accurately. When I use 4o, even with the web search prompt enabled, it either provides information from 2023 or tells me it cannot provide me the information. When I use o3, It does not process my request for a variety of reasons that I try to remedy and then it just leaves me with this message:
Sometimes it tells me I use TOO many tokens, and others TOO little, I am not sure what is an appropriate amoutn of tokens. I heard disabling the temperature setting would make it work, but that doesn't help me. How can I remedy this so I can keep working? This is the only piece of Automation that is slowing me down.
@abzakhali try enabling Web Search in the Tools parameter:
