How to use Analyse Image (openAI) node's Content response?

Help me Build my Workflow
1

Hello,

I’m stuck and would love your help on this target workflow.

  • User fills n8n form with upload image field + other fields
  • AI analyses the image and should recognize the values for each field
  • Gsheet is appended with 1 col = form field title, and value = AI analysis result

Problem:

The Analyse Image node’s output is a Json with the {“content” : json} key-value pair, so the Json-value values cannot be dragged and dropped to do a matching of the AI response and the corresponding field.

Tldr:

Everytime I upload an image, and I want the automation to fill a gsheet with columns “Title", “dominant color", “number of visible humans"

Data manipulation problem

Thank you for your help

2

Hey @Ckn_07 ! Welcome to n8n community!

Can you share an image with the output of AI in your workflow?

If the output is under “content”, you can use a SET node after, and mapping to each sheet column names with the corresponding values from output.

Cheers!

3

Thank you :slight_smile:

I’ve attached a screenshot. The thing is I cannot seem to isolate the corresponding values to map them.

image
image2760×1012 313 KB