Google Sheet Input > OpenAI Write > Google Sheet Output the same row different column

[bernie1224]

I want to create a process where a user inputs information into the “Input” column of a Google Sheet. This information will be sent to OpenAI for rewriting, and the rewritten text will be output to the “Draft” column in the same row. When the dropdown in the “Confirmation” column is set to “Confirmed,” the content will be passed to OpenAI again to rewrite it as a Facebook post.

Issue: Even though I get the “input” from the sheet and add the OpenAI as a parameter, it seems it doesn’t get it when running. I don’t know if I did anything wrong.

blueprint (1).json (78.3 KB)

[samliew]

Welcome to the Make community!

Your “Draft Confirmation” has to be a separate scenario, with a different trigger module.

Try the “Watch Changes” trigger module just to watch column E changes, which requires advanced setup.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew