OpenAI node only copies the text — it doesn’t rewrite to third person (Google Sheets → OpenAI → Google Docs scenario)

[Together_Cultural_Ex]

What is your goal?

I want to automate a process where answers written in first person (stored in Google Sheets) are rewritten into third person using OpenAI, and then automatically sent to Google Docs.
The flow is: Google Sheets → OpenAI → Google Docs.

What is the problem?

Everything works technically — data moves from Google Sheets to OpenAI and then into Google Docs without errors.
However, OpenAI doesn’t follow the instruction.
Instead of rewriting the text into third person, it just copies the original text exactly as it is.

It seems like the model receives the data, but doesn’t apply the transformation described in the prompt.

What have you tried so far?

Refreshed and re-mapped all Google Sheets fields in Make.

Reconnected both Google Sheets and OpenAI modules.

Verified that data from Sheets is being passed correctly to OpenAI.

Tested the same prompt directly in ChatGPT — and it works perfectly there.

Adjusted the OpenAI node roles

Tried using Iterators, Array Aggregators, and Tools modules to handle grouped responses or multiple columns — but the result is always the same: OpenAI just repeats the input text or are empty

Screenshots: scenario setup, module configuration, errors

Integration Google Sheets, OpenAI (ChatGPT, Sora, DALL-E, Whisper).blueprint (1).json (70.9 KB)

[mszymkowiak]

Hello,

Welcome to the community!

Your scenario can’t work - you have not mapped values from Google Spreadsheet into the OpenAI module.

Your prompt/module config does not contain any mappings.

Also, you are creating a Google Docs document with values from Google Sheets- so even if OpenAI would work, the document will be created using unconverted data.

[Together_Cultural_Ex]

Thank you for your message. at the beginning I didn’t fully understand the codes but know the module is now working (Y) —

However, a new issue appeared: all the OpenAI answers are being inserted into the first question of the Google Doc. I’m not sure how to correctly place each individual answer into its corresponding question in the template.

Could you please guide me on how to map each response properly?

Thank you!

[mszymkowiak]

Hey,

You should set up OpenAI’s response type to JSON (advanced settings–>Output Format) and provide a schema that the LLM should use to generate responses. You can choose JSON schema or JSON object- if JSON object is selected you must provide sampel JSON in your prompt.

With this approach, you’ll be able to map answers to the correct fields.

Remember to “force” the LLM in your prompt to strictly follow the schema- this will reduce the chances of errors caused by incorrect AI output.