How to connect and authenticate in web3 dapp using requests only (CLI)? Is it even possible?

Perhaps my question is not formulated correctly because I don’t know how else to call it, therefore, here I will give a basic example:

Usually, I have a browser on which Metmask or Phantom is installed and I go to any site, connect the wallet to the site, then, for example, approve something.
So my question is, can I do these actions by just using requests? I mean to write a nodejs/golang script that will work with web3.js or @solana/web3.js and thereby also connect to websites approve a transaction to authenticate, confirm them and so on? Is it possible?

I need to work with websites on Solana blockchain tho, but I have no clue how to do that 🙁

I’m trying to connect to website that requires a solana wallet and authenticate by approving a transaction. I want to login, but I need to do that by using requests only.