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.
Please
"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction.
You do not need to pay me a penny until the work is complete as per your satisfaction.
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.
Hi thanks for bid on this job
I have seen that you are looking for developer to make bot for get data from sites
I have already made so many bots like this
I can show you my past work
If you hire me I will do my best for you
please send me message and let's start work
Thanks
Hi, I have a lot of experience with both discord's API and google spreadsheet's API, and I've made bots before that do exactly what you want and more, fetch/modify spreadsheets data and rows through discord bot commands, then displays it in discord as embed messages.
I can make this for you reliably fast.