Output Content as JSON not available in OpenAI - message a model.

[alexnomads]

My first goal: make a Node work that looks like: [manual trigger] + [google sheet - get rows in sheets] + [openAI - Message a model] + [Google sheet - update row in sheet].

I am using a google sheet I want to get data from (publicy viewable online).

Then in the OpenAI I write this:

GPT-4O
Messages
Text
System
Prompt: You are an intelligent writing assistant specializing in cold email to win clients.

System
Prompt Your task is to personalize an email.


You'll do this by taking, as input, a prospect's LinkedIn profile, and then editing 5 templates for different sections of the email: subject line, icebreaker, elevator pitch, call to action, and a PS field.

 Your templates are below.
 Subject Line: "hey {name}, think I have something for you re {uniquethingAboutThem0rTheirCompany}"

 Icebreaker: "I know you're doing {thing} and I've been following {relatedThing} for a while so I figured it made sense to chat"
 Elevator Pitch: "The TLDR: I think I can add ~$5K/mo to {theirParaphrasedBusiness} with a few automated systems"

 Call to Action: "I just did this for a very similar {industry} company and we hit $28,350 in a few months-they do {relatedThing} so am very confident I can duplicate this at minimum. Would be 100% risk-free, I'd guarantee at least 20 appts booked or you wouldn't pay."

 PS: "even if we just chat, I'd love to hear about what you're doing with {thing}"

 Guidelines
 1. Your tone of voice should be "casual bar conversation" and very Spartan. No fancy language.
 2. Look for Plausible (but vague) connections wherever possible.
 3. Do not just repeat data from the LinkedIn profile verbatim. Paraphrase, so they think a human wrote it.
 4. Make sure the subject Line is non-capitalized, even if it's grammatically incorrect. This makes the email seem human.
5. Respond in JSON using this format.
 {"subjectLine":"","iceBreaker":"","elevatorPitch":"","callToAction":"","ps":""} Type Text Role User Prompt full name: {{ $json['Full Name'] }} job title: {{ $json['Job Title'] }} LinkedIn URL: {{ $json['LinkedIn URL'] }} About: {{ $json.aboutWeb }} Industry: {{ $json.Industry }}
*

I dont get the Output Content as JSON in the option and I suspect this is the reason why this bug happens. Can you tell me why this error is happening?

[n8n-assistant]

Hey @alexnomads,

Thank you for reaching out! We’ve received your issue and are looking into it. To help us track this internally, we’ve created a Linear ticket with the reference: "GHC-5624".

We’ll keep you updated as we make progress, but if you have any additional details or context to share, feel free to add them here - it’s always helpful!

Thanks for your patience and for bringing this to our attention.

---

For INTERNAL use only: GHC-5624

[MookieLian]

Thanks for bringing this up! After reviewing the details, it seems like the behaviour you've reported is actually expected and not a bug. We can understand how this might seem confusing, so we've added a note to clarify things.

If you have any questions or need more details, feel free to reach out again, we're here to help!

Note that in order to modify the output of OpenAI node version 2 (Latest) node, you have to add Output Format option and choose your preferred format. Here is an image for your reference:

#closed:working-as-expected

[alexnomads]

Thanks for the prompt answer @MookieLian.

I see the standard JSON Schema is
{ "type": "object", "properties": { "message": { "type": "string" } }, "additionalProperties": false, "required": ["message"] }

Standind to my needs, should I edit or leave it like this?

[MookieLian]

This is an example schema. You have to edit it depending on your needs. Make sure to write a clear description for the AI and toggle on Strict if necessary. You can ask ChatGPT to write a JSON schema for you if you are not familiar with it.