CSV file with dynamic number of columns into Google sheets

How To
,
1

Hi,

I have a question about “Parse CSV” and “Add Row” modules. Problem is that data from “Parse CSV” might have different number of columns every run. How can i import this file/rows into google sheets?

Thanks in advance.

2

@Piotr_Jablonski
Depending on the pattern of the number of columns in the CSV, Router and Filter would need to be used to conditionally branch.

The following image determines whether a particular column exists.

image
image704×457 41.5 KB

3

Case is that source data which go into Parse CSV might be ±10 columns different based on Apify scrape. Maybe i should go through JSON instead CSV?
blueprint.json (10.8 KB)

4

hmm… that’s a lot of numbers. Maybe JSON would be better, as you wrote.

5

I don’t know if i am doing something wrong. Changed to JSON, but it’s not working as i expected. In a blueprint you can find this JSON structure. Problem is with hotelAds (this part is dynamic). Could help me what can i do with that?
blueprint (1).json (215.3 KB)