Answered

I need help with a flow I made.

(0) Share

Report

Posted on by callmejesus

Hello people! I wanted to scrape some data off of this website listing mobile phones and their details such as RAM, processor, etc.

Here's the link to it:

https://pricebaba.com/mobile/pricelist/all-mobiles-sold-in-india

If you go to the link there are multiple listings of multiple mobile phones on the 1st page and there are multiple pages, so I go to this page, click on the 1st mobile listing, then go to another page which shows the details of that specific mobile phone on which I clicked on. I scrape all the data from that page and then go back to the previous page and click on the second mobile listing and loop this whole process till I've scraped the data for all the mobile phones listed on the initial page.

I was able to do this using for each loop, but I am unable to save my extracted data to a single excel sheet or CSV file, I am unable to append the data to a new column, if I save the extracted data to excel it is saving each row in a different instance of excel, so suppose I have 20 rows my flow will create 20 different instances of excel and save one row in each instance, I want to save all the rows in one excel sheet, what am I doing wrong? I am new to this tool. Here's my flow.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

v-xiaochen-msft on at

Like (1)

Report
Copy link

Link copied!

Hi @callmejesus ,

We can use 'copy excel', 'paste excel' and 'Get first free cell' actions do it.

Let's say I have 2 web link of mobile phone details.

In loop, the method is similar.

Best Regards,

Wearsky

Was this reply helpful? Yes No
callmejesus 14 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the help mate, I will try it and get back to you and let you know if it worked out for me.

Was this reply helpful? Yes No
Verified answer

callmejesus 14 on at

Like (1)

Report
Copy link

Link copied!

Okay so, this is how I ended up solving it. I first went to the initial page
https://pricebaba.com/mobile/pricelist/all-mobiles-sold-in-india

And I scraped all the links from the highlighted section, from href tag for each phone, the page had multiple pages so I set a pager on next button at the bottom of the page. Here's my flow:

After scraping the around a thousand links I saved them in an excel file and went to each page, which looked like this and scraped the highlighted details:

Here's my flow for doing the task:

Was this reply helpful? Yes No