I want to update the obtained csv file to only the desired values and save it

Help me Build my Workflow
1

I want to create the following workflow, but I’m not sure how to proceed from step 3. Please help.

  1. Search Google Drive for .csv files containing the name “test_”
  2. Download the found CSV files
  3. Convert CSV to JSON
  4. Extract only the “Product URL” column and add “https://test” to the beginning of the URL
  5. Save as test_save_date.csv
2

Hello @junx,

After Download the CSV file (step 2):

  1. Use the Extract from File node (choose CSV), This will output each row as its own item.
  2. Add a Set node to keep only the Product URL field, using this expression to concatenate your domain {{ "https://test" + $json["Product URL"] }}
  3. Use the Convert to File node to turn the modified JSON back into a CSV (with just the updated Product URL) and save it as csv.

Here is an example to help:

3

It doesn’t work.
I’ve attached the workflow I created and test.csv.
Is it possible to extract only the “Product URL” column and add “https://test” to the beginning of the URL?
I would like you to create a workflow for me.csv file

workflow json file

1 Like
4

Hi, what do you mean by it doesn’t work?!

By the way, I just created it again with your sample CSV file,
Please take a look:

the outout:

image
image309×441 4.35 KB

5

This may be because the csv file is large, but it won’t load properly…
The contents of the csv file are not displayed as shown in the attachment.

image
image1281×849 39.7 KB

6

Can you please just copy and paste and run this exact workflow:

image
image1214×287 30.5 KB

This should output a csv file like this

image
image309×441 4.35 KB

7

It worked fine with the test CSV file!!
However, the production CSV file has about 7,000 rows and 20 columns, so that may be the cause.
Thank you for your help.

1 Like