Copy multiple google sheets content into master in Drive

How To
, ,
1

Hi team,

I have a problem for the below scenario.
I would like to get rows from multiple google sheets(store 1 sales, store 2 sales, store 3 sales) that i saved in Drive and copy them into the master (sales report) that in the same folder with each individual store report.

I have drafted a workflow but does not work.
Could you please kindly help.

Great thanks,
Jill
blueprint (1).json (38.1 KB)

2

Hi @_YI , Use ‘Sheet : get range’ for sheet1 and then use array aggregator to convert whole result into an array. Repeat for sheet 2 and sheet 3 in a sequence. Lastly, use for the master sheet - “bulk update rows (advanced)” module and in field ‘Rows’ check Map, input merge(array1;array2;array3).