This is the Alteryx workflow I've currently got:
I know the Google Sheets Input tool is deprecated, but I'm working on a version of Alteryx provided by my company that's still using it, hence its presence here.
When I run the workflow, the error that I get at the very end is HTTP/1.1 401 Unauthorized, despite having set the headers (Authorization and Content-Type) correctly.
From what I've found so far on the forum the issue is that the API expects Basic authentication which is a Base64 encoded username:password string (which I have already prepared), but I've got no idea how to marry the two, so that it all works together.
Basic Authentication:
