How Can I do This? Grab data from a page and insert into spreadsheet?

Hawker · Mar 16, 2016

Hello all. Whats a good way to grab some data from a web page and then have it inserted into a spreadsheet for me?

Specifically what I want to grab is some data from a Facebook group page.

Specifically what I need to grab is the group name, status & number of current users.

I have a list of around 1500 Facebook groups in a really big niche and currently doing it manually which is taking forever.

It might behove me to find something I can use to get that and do that for me.

Not just for this but in the future too and for updating my current lists.

What is something I can use to do that with?

Thanks!

This is what I need it to do in steps.

1. Visit the group URL and check if the group still exists.
2. If does not then skip and move to next group URL.
3. If group exists, grab the group name, group status, amount of users.
4. Insert that into a spreadsheet or save a report of some sort.

How can I do that?

Is iMacros good for doing something like that?

fwh · Mar 17, 2016

Hawker said:
Hello all. Whats a good way to grab some data from a web page and then have it inserted into a spreadsheet for me?

Specifically what I want to grab is some data from a Facebook group page.

Specifically what I need to grab is the group name, status & number of current users.

What purposes and why do you want to grab data from FB groups?

To add into an auto software and doing some jobs for you?

Hawker said:
I have a list of around 1500 Facebook groups in a really big niche and currently doing it manually which is taking forever.

It might behove me to find something I can use to get that and do that for me.

Not just for this but in the future too and for updating my current lists.

What is something I can use to do that with?

Thanks!

Of course, if you do this manually, you're so tired with the job "copy and paste" :crazy:

Hawker said:
Is iMacros good for doing something like that?

How iMacros could open an URL and grap data from different URLs?, its impossible for iMacros, iMacros should run on a web page and do tasks you prepared for it.

Hawker said:
This is what I need it to do in steps.

1. Visit the group URL and check if the group still exists.
2. If does not then skip and move to next group URL.
3. If group exists, grab the group name, group status, amount of users.
4. Insert that into a spreadsheet or save a report of some sort.

How can I do that?

You can do that if you know PHP and using file_get_contents or cURL in PHP but I don't know Facebook have blocked file_get_contents function or still opening it.

Hawker said:
This is what I need it to do in steps.

1. Visit the group URL and check if the group still exists.

Creating a small script to get all Facebook groups from your keyword or your conditions.

After got all groups, using a function to get content, detect tags by using PHP regex to filter content in Facebook groups so you can get group name, status & number of current users, urls..etc.

Hawker said:
4. Insert that into a spreadsheet or save a report of some sort.

Of course you can use PHP to create and push data into an Exel file or insert data into database instead.

Ok I only show ways to do, not go into details so you can have directions to do OR you can use other ways.

Hope it helps!

How Can I do This? Grab data from a page and insert into spreadsheet?

Hawker

Well-known member

fwh

Administrator

Latest posts New threads

Latest posts

New threads

Latest Hosting Offers New Reviews

Latest hosting offers

Popular Contributors - Past 30 Days

Sponsors

Tag Cloud