Hi,
I am a bit new to Make.com. Hope you can help me out with this. It is in Dutch, but I will try to explain it as best as I can.
Currently, I am working on an automation flow to get raw OCR JSON-output file structured via ChatGPT completion action, to the following structure in Google Sheets:
| Column 1 | Column 2 | Column 3 | Column 4 |
|---|---|---|---|
| RE (g/kg) | value y | Gerst | value x |
| Rvet (g/kg) | value y | Tarwe | value x |
| RAS (g/kg) | value y | Soja 49 HP | value x |
| Zetmeel (g/kg) | value y | Mais | value x |
| EW (/kg) | value y | Tarwegries | value x |
| E-dracht (/kg) | value y | Raapzaadschroot | value x |
| aid Lys (g/kg) | value y | Zonnepitschroot | value x |
| aid Met (g/kg) | value y | Melasse | value x |
| aid Trp (g/kg) | value y | Sojaolie-lec | value x |
| aid Thr (g/kg) | value y | Krijt (fijn) Ca | value x |
| aid Val (g/kg) | value y | Az. L-Lysine HCL (78%) | value x |
| Palmolie | value x | ||
| Vit/min VLV Start 0,5% (LCu) | value x | ||
| Natriumchloride (zout) | value x |
Now there are a few questions/comments:
- Column 1 and 2 are connected to eachother, having the same amount of rows. Value y belongs to the value name in the column before it. This is also the case for column 3 and 4.
- The amount of columns are always the same. But, the amount of rows differ in 9/10 OCR automation flows.
- What message in the completion action (GPT) Do I need to create to structure raw json-file in the right way?
- What are the right parse json settings after the ChatGPT completion step?
- What are the right modules (router, iterator) after the parse json-step? Tried a lot, but all failed as it couldn’t paste the cell reach.
- What are the right modules & settings when using Google Sheets for this?
Hope that you can help me out with this!
