Encoding issues

Questions
1

Hello,

I’m trying out n8n but I’m having issues with special characters in french.
As far as I understand, it’s an issue related to encoding.

My csv comes from phantombuster and is read in a spreadsheet note like this:

image
image1045×389 66.5 KB

As you can see, the csv gets read using the wrong encoding.
How could I fix that?

I have many files like that with many columns in each.
Is it possible to set encoding for the whole workflow?

Thank you!

workflow

setup

I’m running on the cloud instance created today.

2

Hi @Joachim_Brindeau, welcome to the community :tada:

Have you tried out the Read As String option of the Spreadsheet File node? This works fine for me for the example dataset from your screenshot:

image
image1279×782 76.4 KB

1 Like
3

Thank you very much @MutedJam !

May I bother you with one more question?
I’m having trouble understanding what blocks to use in the following case (the one from original post above):

  • A csv with record set A + record set B with field URL
  • An airtable with record set A with field URL and field ID

How can I check whether to append or update into airtable depending if the URL exists or not?
I thought a simple switch would suffice but apparently not.

Kind of lost on this.
Thanks a lot
Joachim