From this blog, it is clear that a user cannot directly make transactions between Google Pay and the cash app. One needs to add the cash app card to start the process of a money transfer.