Open xlsx file from gmail and access the sheets inside

Questions
,
1

Hello! I have a question regarding on how can I access the sheets inside the attachment xlsx file from GMAIL?

What I want to do:
I want to retrieve the XLSX file from gmail.
Inside the XLSX file, there are 2 sheets inside, I want to get the sheet 1 and upload the data inside in AWS3 bucket named folder “sheet 1”, same goes to sheet 2. Is this possible?

Note: There is a password to open the xlsx file.

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

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

To open xlsx files you will need the Extract from File Node with Extract from XLSX Operation. But I think the n8n doesn’t work with password protected files

1 Like
4

i get this error…
i tried sending an xlsx file without password

image
image1893×921 54.8 KB

5
6

Your binary field is attachment_0, not attachment_ :wink:

7

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