Exporting Facebook group comments to Excel using Power Query?

I am the admin of a social gambling club full of friends. Each week, all members place one bet on our common sports betting gambling account (e.g. BetFair or the like)(all 50ish members use the same account). The members then post the details (such as what the bet was, and how much their wager amount was) of their weekly bet on the weekly Facebook Group thread (each separate week has a new parent post. It is a Secret Group, which I am an admin in). I then download the results of each bet placed on the sports betting website to Excel and have to manually match the bet posted on facebook with the bets placed on our sports betting account (which takes 30-40 mins per week). At the end, I have a members name in one column, and then the columns to the right contain the bet information (wager amount, bet result, sport type, etc). That bet result information then informs calculation and output sheets to track member progress.

I am looking for a way to make the process of matching the facebook information more simplified by getting the Facebook data into excel and getting each member to post the unique bet ID generated by from the sports betting website (a string of text and numbers that is identical between bets placed on that account except for the fact that the last digit increases numerically by 1 as each bet is placed). Then use formulas to match the sports betting account information up with the facebook information automatically.

I thought Power Query would be able to help me with this task, however it seems that it cant access Facebook Group comment information. I heard of a potential workaround by creating a dummy admin facebook profile that receives notifications to email, and then using Power Query to query the microsoft exchange account associated with that facebook profile. However, it seems that the Excel 2016 version i have downloaded does not allow me to query Microsoft Exchange!

So, does anyone have any suggestions on how I can easily export Facebook group comment information to Excel for processing? Or alternatively, can anyone see a simpler/more efficient way of matching up the information in the bet account with each member?

Hi Marvin,

I can log into Facebook through power query and am able to return my own posts and comments. But I am unable to find and query the specific group that I want to.