How to get AWS S3 Bucket object which is CSV in JSON Format inside n8n?

Describe the problem/error/question

I want to get a CSV file from my aws s3 bucket, and want to upload that file’s data into a google sheet. How can I do so?

Here is my approach, I want to conver the downloaded binary data into json:
node1) AWS s3(download file) → Response(Data is only in Binary form (Download button))
node2) Extract from CSV(Node)… but it is not working

What is the error message (if any)?

I think Extract node is not waiting for AWS s3 node to complete its download.
I don’t know how to target binary data using code node.

Please share your workflow

Share the output returned by the last node

no output any

Information on your n8n setup

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

What is the error? Extract node should do the job.
You just should specify the binary name that is usually the data word

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.