How to move aws s3 file to a google sheet?

Hi @eaferstl, welcome to the community :tada:

Sounds like there’s two separate issue here:

Google Sheets

Afaik Google Sheets does not allow uploading arbitrary binary files to Google Sheets and even adding an image file is somewhat tricky for two reasons:

  • It requires a public image URL inside a formula
  • The formula starts with = which is also how n8n indicates the use of an expression

An example workflow for adding the image would be available over here.

AWS S3

Downloading in AWS S3 seems to work fine based on the steps you have described. I tested this using the below workflow:

I ended up with a binary file in n8n as expected which can be viewed and downloaded:

This isn’t quite what Google Sheet needs as per my comment above, but the download should still work of course. Are you not getting this binary file? Any errors?