I have been utilizing the Google Analytics Reporting API v4 to get universal analytics data. My request has ran fine until trying to push the final dataframe to a Gsheet utilizing Gspread.
There are what appears to be package incompatibility issues between gspread and google-auth, see below. I am on windows, utilizing a jupyter notebook, python version 3.9
When Running pip install gspread
ERROR: pip's dependency resolver does not currently take into account all the packages that are installed. This behaviour is the source of the following dependency conflicts. google-api-python-client 2.50.0 requires google-auth<3.0.0dev,>=1.16.0, but you have google-auth 1.12.0 which is incompatible. google-api-core 2.8.1 requires google-auth<3.0dev,>=1.25.0, but you have google-auth 1.12.0 which is incompatible.
When running pip install --upgrade google-auth
ERROR: pip's dependency resolver does not currently take into account all the packages that are installed. This behaviour is the source of the following dependency conflicts. gspread 5.7.0 requires google-auth==1.12.0, but you have google-auth 2.14.1 which is incompatible.
What is the best way to resolve dependency conflicts (if you can)? I'm new to this and unsure how to research if there is a particular version of google-auth that will satisfy all packages in my specific case.
