Creating CSV for aggregated rows but not working. Its creating a file per row

How To
1

I am updating a list of leads from another sheet in Module 19, 22, 49.
I added aggregator, Iterator and advanced create CSV modules but it runs for each row and creates a file in the drive.

I want to create the whole list as CSV. Attached the setting screenshots.

Would hugely appreciate your help.

Make_3
Make_31222×1708 132 KB

make_2
make_21222×1708 51.1 KB

Make _1
Make _11222×1708 129 KB

2

Hi,

Try to put the Iterator as the source module of your csv module. Your screenshot shows that the source module is the aggregator, so the csv module is executed as many times as you pass through the iterator.
Regards.

3

Thanks @Baptiste_Petrilli . I tried but it doesnt work. It still runs each row.

4

Hi,

It is strange. Could you put a screenshot of the entire scenario, or upload the blueprint ?

Regards.

5

blueprint (1).json (416.3 KB)

@Baptiste_Petrilli Here you go. Attached the blueprint.

Let me know what changes I can do.

Thanks a ton.

6

@Sahil_Senapaty
Here is a screenshot. First Route : all the searchs, updates etc, …
Second route : file building (the source module of the csv should be the GoogleSearchRow Module.
I ve added a basic trigger, so the second route will be executed only once.

image
image1741×557 73.3 KB

Hope it helps.

7

Thanks for your reply @Baptiste_Petrilli .

Quickly want to check, I am want to add the data that comes after the route 17 second filter get executed.

if we add a second route from the beginning would it do the same job?

Also, you referenced GoogleSearchRow module. Which scenario do you mean exactly?

Appreciate this.

8

You re welcome.
On the second route and for the module 17 you will need to put the search parameters you had in your first scenario (maybe you ll have to deal with variables (Set and Get).
GoogleSearchRow module = module 17 (its a module not a route) in the second route (you can see the ID of each route on the routeur module).

9

I implemented your proposed structure. @Baptiste_Petrilli

Now its creating a single CSV with 2 rows but the rows are empty. Its not taking the data that comes after the router -module 17.

Also, in your trigger, what bundles did you add? I see its a basic trigger.

I am sorry, I am unable to understand exactly.

Thanks.
blueprint (2).json (481.0 KB)

Untitled2
Untitled21306×1708 72.3 KB

10

Hi,
Does your module 17 returnsany datas ?
The basic trigger is just here to be sure that the second route will be executed just once.
Regards.

11

@Baptiste_Petrilli , The router module 17 does not return any data.
What do you mean exactly?

I ran the scenario with the basic trigger in place, it didnt give me the desired output.

12

@Sahil_Senapaty
Could i ask you for how long you work with Make ?

13

What do you mean exactly?

14

Its just because you seem to be a beginner reagrding some of your questions.
Anyway, the basic trigger is not here to provide datas, but just to be sure the second route will be executed only once. From your first scenario, you tried to aggregate datas after a Google Sheet module (i guess the dats you want to aggregate are stored in the link sheet). In my proposition you have to put the same filter on your google sheet module that you had on you first scenario, if you dont do that it will return no datas or all the datas stored in your google sheet.

Regards.

15

You are correct. I started using Make 1 week ago.
Thanks for your help. I solved it.

16

Great !
Hope you will discover how Make is a powerful tool.
Regards.