Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Can I split a ChatGPT response into multiple variables?

  • July 28, 2025
  • 5 replies
  • 29 views
A

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: 

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

DennisWF
Forum|alt.badge.img+5
  • DennisWFZapier Solution Partner
  • Zapier Solution Partner
  • 153 replies
  • July 28, 2025

​@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. 

https://www.work.flowers
Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • 34068 replies
  • July 28, 2025

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 - AutomationAce.com | Platinum Authorized Zapier Solution Partner | #1 Zapier Community Contributor
A
  • abzakhaliBeginner
  • Author
  • Beginner
  • 2 replies
  • July 29, 2025

​@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?

A
  • abzakhaliBeginner
  • Author
  • Beginner
  • 2 replies
  • July 29, 2025

​@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. 

DennisWF
Forum|alt.badge.img+5
  • DennisWFZapier Solution Partner
  • Zapier Solution Partner
  • 153 replies
  • July 30, 2025

​@abzakhali try enabling Web Search in the Tools parameter:

 

https://www.work.flowers
Terms & ConditionsAccessibility statement