I want to read multiple Invocies from floder and read it using Mindee and write to excel

Questions
, , ,
1

Describe the problem/error/question

I want to read multiple Invocies from floder and read it using Mindee and write to excel

What is the error message (if any)?

I am not able to read the Invoices from the files -Invoices – Google Drive

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

Hi @Arudhra :wave:

Read Binary Files is a node you can only use on a host machine - in other words, this won’t work with a URL. Can you try using the HTTP Request node to get your file (be sure to mark the incoming data as binary data), and then use a Read PDF node after it?

I obviously can’t access the data that you’re trying to use, as I wouldn’t have any of your credentials, but that would look something like this instead:

4

Hi @EmeraldHerald i tried the workflow you shared, i am getting the below error

ERROR: Bad request - please check your parameters

400 - "Error 400 (Bad Request)!!1*{margin:0;padding:0}html,code{font:15px/22px arial,sans-serif}html{background:#fff;color:#222;padding:15px}body{color:#222;text-align:unset;margin:7% auto 0;max-width:390px;min-height:180px;padding:30px 0 15px;}* > body{background:url(//www.google.com/images/errors/robot.png) 100% 5px no-repeat;padding-right:205px}p{margin:11px 0 22px;overflow:hidden}pre{white-space:pre-wrap;}ins{color:#777;text-decoration:none}a img{border:0}@media screen and (max-width:772px){body{background:none;margin-top:0;max-width:none;padding-right:0}}#logo{background:url(//www.google.com/images/branding/googlelogo/1x/googlelogo_color_150x54dp.png) no-repeat;margin-left:-5px}@media only screen and (min-resolution:192dpi){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat 0% 0%/100% 100%;-moz-border-image:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) 0}}@media only screen and (-webkit-min-device-pixel-ratio:2){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat;-webkit-background-size:100% 100%}}#logo{display:inline-block;height:54px;width:150px}

400. That’s an error.

The server cannot process the request because it is malformed. It should not be retried. That’s all we know."

Please let me know any other details you require

5

Hi @Arudhra - it looks like you also have a topic open with this same subject with my teammate @MutedJam , can you please stick to one topic? I’ll close this one, and you can continue in the other topic.

That being said, this workflow will not work out of the box - you need to use the URL of the doc you’re trying to retrieve. Your example had your spreadsheet URL as https://drive.google.com/drive/folders/1St1-zMwWl3gaEKPLgPxlx2fbxpDE6ss8/*.pdf which is what I used - so you’ll need to change this URL as needed. Please also make sure you have access to this document via your sharing/organisation settings, too. :+1: