Monitoring Mentions In Facebook Posts

ο»Ώ

Document image

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:

Document image

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.

  1. 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.

Document image
  1. make that sheet permission to be accessible (editor):
Document image

Let's add the post URL of my last post that got quite a few likes:

Document image

Let's add one of of Jon's post he made on another group that received likes we will collect too:

Document image

Add those posts to our Sheet:

Document image

Create a new Recipe:

Document image

Check the "Process only new results" box. That way, TexAu will only process unique post likers profiles each time we launch/schedule the recipe.

Document image

Create a local variable called "FbPostLikers", leaving the "variable value" field empty. Click "Add"

Document image

Now add the "Extract Facebook post likers New" spice on the dropdown menu:

Document image

Now add your two cookies with the chrome extension, and add the local variable we created before:

Document image

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:

Document image
Document image

Now, for the google sheet URL, add the shareable Google sheet URL we created before:

Document image

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:

Document image

Now, let's add those columns and map variables from the previous spice, click "Add Columns", add those, then save:

Document image

Then:

  • Connect to your google account
  • Start row = 2 (because row 1 is our header)
  • Sheet name: "Likers".
  • Push data to existing rows: empty
Document image

After that, click the CSV/Sheet icon from the recipe menu:

Document image

Select our first google sheet source data with the post URL:

Document image

Add our google sheet shareable URL link and map the first column A:

Document image
Document image

Finally, launch the recipe by hitting the "Submit Google Sheet" button:

Document image
Document image
Document image

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 πŸ˜›.

Document image
Document image
Document image

Oh, I see some familiar faces over there ;-)

Document image

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.

Document image

That's it for today, automation cooks!

ο»Ώ