Hi! This is the file from which we need to get the information - Zavag.com is for sale | HugeDomains . It’ s a price list for car parts From it we need to take only those rows where the price is greater than 0 (and not blank). The price column (in Russian - “Цена”) is the O column. The rows o…

Hi @Mikhail , I used two Move Binary Data nodes to change encoding and the Spreadsheet File node to achieve this. [image] Here is my example workflow.

Hey @marcus ! Thank you so much for your help! It is work! Can you please tell me how to save this file? There must be something like this: [6623chrome]

There is the Problem running workflow Request failed with status code 413 on the last node “Write Binary File” I guess it’s a problem with a large number of rows. Or maybe something else… Have you encountered this problem?

I did not experienced a 413 error. Is this error happening in the first Http Request node? Those kind of status code errors usually only occur when making http requests and none of our other nodes do that.

Weird. I reloaded the browser tab and everything worked. I tried executing separately by node - the error again. I’ll keep watching… If this error keeps coming up, maybe someone will help me with it. All in all, it works! Great job! [6624chrome] Thanks so much for your help and your answers!

How to transfer information from Excel file by link to G Sheet with correct encoding and filtering

Questions

marcus August 2, 2022, 10:56am 4

If you want to save as csv again you can use another Spreadsheet File node with Operation = Write to File like this:

Can't download file to my PC via a direct link from the /local-files

Topic		Replies	Views
Write to file a Google Sheet Questions core , data-transformation , deployment , node	3	1029	July 11, 2021
Create table from one object Questions data-transformation	6	1853	October 18, 2021
Unable to convert google sheets data to binary data and send to google drive Help me Build my Workflow	8	316	April 13, 2025
Spreadsheet File node change file encoding Questions spreadsheet-file	6	1023	November 23, 2023
Appending json values to a existing spreadsheet Questions	4	3306	November 26, 2019

How to transfer information from Excel file by link to G Sheet with correct encoding and filtering

Related topics