No, you never need to provide these to Supermetrics Uploader. You authenticate to Google Analytics using OAuth, a secure authentication method recommended by Google. This means that you never have to type your password to Supermetrics Uploader, as the authentication happens on a Google-hosted webpage.
Supermetrics Uploader will only have rights to access your Google Analytics data, nothing else on your Google account. You can revoke Supermetrics Uploader's right to access your data at any point from your Google Account control panel.