Convert Excel to Word, with specific vision data

How To
, ,
1

Hello everyone!!!

I want to automate the arrival of an excel coming from a gmail attachment.

I first upload it to Drive and convert it to PDF and then use OpenAI vision. The scenario does not give error to execute it. However it does not pass any data to the final Google Sheet.

I pass you screenshots, to see if you notice where the error is.

When I run the scenario it does not show any error. But the data does not appear in the final Google sheet.

I pass you screenshots to see if you see the error.

1 First screenshot:

Convert PDF coming from Google Drive, as you explained.

2 Second screenshot:

Shows how I Love PDF does the conversion well.

3 Third screenshot:

Shows that OpenAI has to extract some data with the view module. The data it has to extract are the ones in CAPITALS.

4 Fourth screenshot:

Shows that OpenAI is not extracting any data.

5 Fifth screenshot:

Shows that the Json is not receiving any data.

6 Sixth screenshot:

Shows how the Google Sheet module is configured.

Where is the bug, and if there are any more bugs in the flow let me know.

I would appreciate if you could explain me more because I am with this scenario for 4 days.

Thank you very much for the help!

1
11382×889 98.3 KB

2
21248×617 72.3 KB

3
31311×865 93.3 KB

4
41429×791 121 KB

5
51498×597 77.1 KB

6
61252×900 108 KB

2

Screenshot 4 shows that there is no data from OpenAI. If you run this manually in the OpenAI playground instead of using Make, does it work?

If it does, then it means that the data from I Love PDF is not making it to your OpenAI call, and that’s what you need to look at.

If it doesn’t work in the playground, then try with different models or modify the prompt to see if that’s the problem.

L