Monitoring Mentions In Facebook Posts
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 specific posts in his Facebook group:
Note: We will run this automation recipe on the Desktop app. If you intend to use the TexAu cloud version in your browser, please use proxies.
- create a google sheet with 1st column containing your manually pasted post that we will process.
Name the header column of that Sheet as "FB Post URLs". This column will be the data source of our custom recipe.
- make that sheet permission to be accessible (editor):
Let's add the post URL of my last post that got quite a few likes:
Let's add one of of Jon's post he made on another group that received likes we will collect too:
Add those posts to our Sheet:
Create a new Recipe:
Check the "Process only new results" box. That way, TexAu will only process unique post likers profiles each time we launch/schedule the recipe.
Create a local variable called "FbPostLikers", leaving the "variable value" field empty. Click "Add"
Now add the "Extract Facebook post likers New" spice on the dropdown menu:
Now add your two cookies with the chrome extension, and add the local variable we created before:
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:
- Connect to your google account
- Start row = 2 (because row 1 is our header)
- Sheet name: "Likers".
- Push data to existing rows: empty
After that, click the CSV/Sheet icon from the recipe menu:
Select our first google sheet source data with the post URL:
Add our google sheet shareable URL link and map the first column A:
Finally, launch the recipe by hitting the "Submit Google Sheet" button:
Each time we process the recipe, it will only add new likers to the Sheet. Jonathan had nine likes for his post in the Dave Swift group, and I had 42 total for mine. I guess you owe me a cookie, Jon 😛.
Oh, I see some familiar faces over there ;-)
When you schedule a recipe from Google Sheets using the setting "wait for new entries", it will appear in orange in the TexAu Results menu. Why? Because TexAu will monitor every new post URL, and every time you paste a new row on the first Sheet, the results will pile up, showing new post likers on the second Sheet.
That's it for today, automation cooks!