Filling A New Template Google Sheet from Multiple Apify 'Get Dataset Item' Sources

Getting Started
, ,
1

Hello, make.com is quite new for me and I’m trying to work out how to do something which I know enough to know is doable, but don’t know enough on how to make it work.

I am using several apify webscraper tools to generate text data via links input into a Tally form. This all works and the outputs are what I need.

image
image1134×1358 180 KB

What I want to do is having scraped the data, to input it into a new google sheet from a template (link below). With each output of the scraped data modules being in a new row on a single sheet.

I this this is something to do with text aggregators, but I can’t work out how to get all the the outputs from each “Apify - Get Dataset Output” module into a single aggregator, or how to get this data into a newly created sheet.

Very much a newbie, and happy to answer any clarifying questions needed, or open to suggestions on what’s a simpler way to get this to work.

1 Like
2

Hi @Morwoo
You can use the “Add a Row” module in the first router to insert data. Afterward, store the row number in a “Set Variable” module for later use. In subsequent routes, use the "Update a Row"module, retrieving the row number from the stored variable via the “Get a Variable” module. See an example in the following post: Merge 2 iterator - #2 by Msquare_Automation

Best regards,

Msquare Automation
Platinum Partner of Make
@Msquare_Automation