In this tutorial, we are going to see how to use TexAu to Monitor Facebook group Posts and pull active members' data from Facebook groups. Active members are the members who like and comment on posts on Facebook.
How it started?
A few days ago, one of our users Johnathan Montgomery, asked me for some help to solve his use case.
He is a health and fitness coach and entrepreneur 💪💪💪
He wanted to monitor and scrape all the likers and commenters of certain posts in his Facebook group:
So now, I'm going to create a simple TexAu Recipe to achieve this.
Note: this recipe will be executed on the Desktop app. If using the cloud, use proxies as usual.
Step 1: Create a Google Sheet and make it public
Create a Google Sheet with 1st column containing your manually pasted post that we will process.
Label that first sheet "FB Post list", this will be the source data of our custom recipe.
- Make that sheet permission to be accessible (editor):
Step 2: Add the post URLs in the first column
Let's add the post URL of my last post that got quite a few likes, you can add as many as you want.
NOTE: TexAu Also provides a way to extract posts, in case if you would like to add all the posts, you can first scrape all the post's URLs and then copy-paste them in the Google Sheet.
Let's add one more post from a different group that received likes too:
Add them to your Gsheet and make it ready.
Step 3: Create a TexAu Recipe
Go to the TexAu Recipes page and click on Create A New Recipe button. This will take you to TexAu's advanced Workflow (Recipe) builder page.
Make sure to check the box "add only new results" so only new post likers will be added each time we launch/schedule the recipe.
Step 4: Building your Recipe
- First, we are going to make a local variable called:
FbPostLikerswithout any value as this is going to be used to map the Sheet column.
- Whenever you want to use CSV or Google Sheet in Recipes, always create a local variable for the columns and leave the value field empty.
- Now let's add our first automation, "Extract Facebook post likers New" spice on the dropdown menu.
- It says "New" because Facebook recently rolled out a new UI and TexAu still supports all the old and New UI based automation 😉
- Now add your 2 cookies with the chrome extension, and add the local variable we created before.
- NOTE: If you don't have TexAu Chrome Extension, make sure to download one, it will save you hours of time in pulling cookes.
- Now click the blue "+" button to add a new Spice. This time we will send the results (post likers) to a new sheet of the same workbook:
- Now for the google sheet URL, add the shareable Google sheet URL we created before:
- We will query each post URL added in the list so it returns all the likers of each post, their profile URL, full name, their reaction type (smile whatever) and timestamp (date/hour) as follows in the next sheet of the workbook:
- Now let's add those columns and map variables from the previous spice, click "Add Columns", add those then save:
Step 5: Connecting your Google Account to push data
To submit data from TexAu to a Google Sheet, we need to connect Google Sheet to TexAu first.
- The first click on Configure, select your account
- Allow TexAu to access Google Sheet to write
- Once done, click save and close the window.
Now, you should be able to push data from TexAu to a Google Sheet.
- Start row = 2 (because row 1 is our header)
- Sheet name: "Likers"
- Push data to existing rows: empty
Step 6: Running the TexAu Recipe with CSV / Google Sheet
To run TexAu Recipe with CSV or Google Sheet input, click on CSV/Sheet option on the top bar and select if you want to use CSV or a Google Sheet.
- Select our first google sheet source data with the post URL:
- Add your Google Sheet shareable URL link and map the first column A:
Step 7: Running TexAu Recipe
- To run TexAu Recipe with CSV/Sheet, once you have added all the details, click on the "Submit Google Sheet" button ANNNNNNDDDDD VOILA!!!!!
- Your workflow will start running.
Each time you process the recipe, only new likers will be added. Jonathan had 9 likes for his post in the Dave Swift group, I had 42 total for mine.
And you can see all the data has been added to this Google Sheet we created.
You can see the same on the TexAu Results page as well.
The recipe will still be marked as processing in orange in the "Result" tab. Why? Because it will listen to every new post URL you will paste on the first sheet and will pile up the new post likers on the second sheet every day ("wait for new entries"):
If you liked this tutorial and want to see more, make sure to subscribe to our mailing list below. TexAu is a growth automation platform to easily extract data and help you with your lead generation. TexAu is used by thousands of sales and marketing teams from small to enterprise companies across the globe.
Hit Subscribe button at the corner ↘️ to receive the latest guides, tutorials, and ebooks (only available to subscribers).