I run a flag football league and use Discord as our home for information.
I keep stats for the players and manually enter them into google sheets. We have around 80-90 people in the league and 11 statistical categories for each player.
I'd like a bot that links a player in the server to their corresponding row on the google sheet, so when they run a command - such as /stats - they bot would pull all their stats and they could see them on a certain channel in the discord.
We have 10 teams, so it would also be cool if the bot could crunch the team's stats and W/L record.
I have 4 google sheets I run, one for teams, one for passing stats, one for receiving stats, and one for defensive stats. I've attached one image to show you the sheets if you'd like.
currently, I just snip an image from my computer off of the google sheets and add that photo to the stat channel once a week.
The sooner the better for something like this to get working! I'd need a way for players who come into the server to get connected to their "row" or name on the google sheets if possible.
5 freelancers are bidding on average $140 for this job
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me.