prem-ium / youtube-analytics-bot

🤖 Discord bot to receive YouTube Analytics statistics such as views, estimated ad revenue, & more!🕵📊

Hi there , I'm Prem-ium (Prem Patel)

🧠 Premium Software Engineer

🤝 Open to Opportunities

📫 Let's get in touch

🎯 Connect with me on

✉ Email me at: premiumcspatel [at] gmail.com (No spam or marketing please!)

🚀 About Me

• 🎓 I graduated with a Bachelor of Science in Computer Science w/ Magna Cum Laude honors.
• 🔭 Currently actively developing my YouTube Analytics & Brokerage Trading Automation projects.

• 🌱 I’m currently further expanding my knowledge in Ruby
• ⚡ Fun fact I love eating spicy food 🌶️ & talking about space🌌🧑‍🚀

📈 My Github Stats:

🔧 Languages & Tools I Primarily Use

📌More Stats

🎯 Metrics

💫 Repo Star Data

📝 Habits

📂 Featured Repos

youtube-analytics-bot's Issues

I have got a forbidden error during collect the revenue information

googleapiclient.errors.HttpError: <HttpError 403 when requesting https://youtubeanalytics.googleapis.com/v2/reports?ids=channel%3D%3DMINE&startDate=2023-01-01&endDate=2023-04-11&metrics=views%2CestimatedMinutesWatched%2CsubscribersGained%2CsubscribersLost%2CestimatedRevenue%2Ccpm%2CmonetizedPlaybacks%2CplaybackBasedCpm%2CadImpressions%2Clikes%2Cdislikes%2CaverageViewDuration%2Cshares%2CaverageViewPercentage%2CsubscribersGained%2CsubscribersLost&alt=json returned "Forbidden">

HttpAccessTokenRefreshError: invalid_grant: Token has been expired or revoked.

Exception:
oauth2client.client.HttpAccessTokenRefreshError: invalid_grant: Token has been expired or revoked.

Traceback:

Traceback (most recent call last):
  File "c:\Users\Frost\Desktop\CodingProjects\youtube-analytics-bot\main.py", line 138, in get_stats
    response = execute_api_request(
  File "c:\Users\Frost\Desktop\CodingProjects\youtube-analytics-bot\main.py", line 85, in execute_api_request
    return client_library_function(**kwargs).execute()
  File "C:\Python310\lib\site-packages\googleapiclient\_helpers.py", line 130, in positional_wrapper
    return wrapped(*args, **kwargs)
  File "C:\Python310\lib\site-packages\googleapiclient\http.py", line 923, in execute
    resp, content = _retry_request(
  File "C:\Python310\lib\site-packages\googleapiclient\http.py", line 191, in _retry_request
    resp, content = http.request(uri, method, *args, **kwargs)
  File "C:\Python310\lib\site-packages\oauth2client\transport.py", line 186, in new_request
    credentials._refresh(orig_request_method)
  File "C:\Python310\lib\site-packages\oauth2client\client.py", line 761, in _refresh
    self._do_refresh_request(http)
  File "C:\Python310\lib\site-packages\oauth2client\client.py", line 819, in _do_refresh_request
    raise HttpAccessTokenRefreshError(error_msg, status=resp.status)
oauth2client.client.HttpAccessTokenRefreshError: invalid_grant: Token has been expired or revoked.

Task:

Find a way to prevent token from having to be refreshed / re-authenticated every couple of weeks manually when credentials.json expire.

Notes/Potential Patches:

• The --noauth_local_webserver command line argument may be used however it requires a verification code to be sent through the terminal. There is also the issue of how to send the URL from the terminal to Discord for ease of access and if possible input verification code without having to remote into PC/Docker to rebuild the image & container with updated credentials.json.

Example output:

python main.py --noauth_local_webserver
2023-02-09 23:23:02 INFO     discord.client logging in using static token
2023-02-09 23:23:03 INFO     discord.gateway Shard ID None has connected to Gateway (Session ID: XX).
Updating dates to 2023-02-01 - 2023-02-09

Go to the following link in your browser:
https://accounts.google.com/o/oauth2/auth?client_id=XX-XX.apps.googleusercontent.com&redirect_uri=urn%X%X%X%3A2.0%3Aoob&scope=https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fyoutube.readonly+https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fyt-analytics-monetary.readonly&access_type=offline&response_type=code

Enter verification code: 

An ideal potential middle ground solution would be to retrieve the URL from the terminal, send it as a message on discord, allow the user to authenticate, and send the code inside of discord for the bot to receive, parse, and push to terminal as input.

• refresh_token() method fails to solve this issue as well and will be stripped in next commit.