Gmail text to Sheets (via ChatGPT)

Hello all. I might be overthinking this but I am trying to take order info from a Gmail message and have relevant info populate into google sheets. My setup now is to parse the right gmail box and subject (that works) and send to ChatGPT to extract the data (worked once but now im stuck).

I started using a template for similar.

I would love if I am just missing a tutorial on this or someone has a template. Thanks!

Hi,
Are you getting a GPT response in the form of a json? It really makes your life many times easier when you get a structured json from GPT and then organise it into an array to push into a google sheet.