Retrieve data - binary file

Questions
,
1

Hello,
I’m quite new to n8n and definitely new to the community → hope my question is OK…

Describe the problem/error/question

I am implementing the following workflow

  1. Trigger → vcf file saved on google drive
  2. Download file from Google drive. (node works → I see the binary apparently)
  3. Read data from node (to collect Name, email, phone etc…)
  4. Insert results in Google Sheet

This is where I am stuck on step 3. I got a message
“Cannot read properties of undefined (reading ‘data’) [line 2]”

Here is the code
const fileData = $node[“Download File”].json.binary.data.data;

Please share your workflow

Information on your n8n setup

  • Running n8n via Docker on OVS
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

Hi @AlainJeanfavre

You could actually use the Extract From File node to return the UTF-8 string. You can then simply use the output in your code node as const vcfContent = $input.first().json.data;

4

Thanks a lot ria for your kind assistance !
I tried and got the following results

Result
Result1224×356 76.6 KB

I probably have an issue with the encoding ???
Thanks again