Edit: A lot of people say, that GWM needs a melee weapon attack, but they miss Jesses point: While GWM requires a melee attack with a heavy weapon, Sharpshooters only criteria is an attack with a ranged weapon (not a ranged weapon attack). Jesse bases his claim on the fact, that a crossbow is still a ranged weapon, even if used as an improvised weapon for melee combat. That’s why it deals 1d4(!)+20 damage. (It works with any ranged, heavy weapon btw., so Longbow qualifies too.) Of course Jesse is playing the devils advocate here and of course, no somewhat sane Walter will allow this in any campaign ever, as it’s obviously not the intention behind these feats. But you could read it that way and that’s Jesses (paperthin) point. Besides: he finds the image of a barbarian running around recklessly smashing a crossbow over everyone’s head to just be hilarious.
This doesn't really work as far as I can tell, RAW or RAI. While it is the case that in theory a Melee Attack with a Heavy Ranged Weapon would satisfy both criteria, there is no weapon that can normally perform such an attack, as far as I'm aware. Using a Heavy Crossbow or a Longbow to make a Melee Attack would be attacking with an Improvised Melee Weapon, which is both not a Ranged Weapon and does not have the Heavy property, so neither Feat would be useful.
If we are being generous we could say that attacking with a Heavy Crossbow would be like a Club and a Longbow would be like a Staff, and per the Improvised Weapons rules we could use those weapon stats for our Improvised Weapon, however, note that neither of these have the Heavy property, so you would be unable to use either Feat in this case as well. (The Heavy property, particularly on Ranged Weapons, seems to be not about the weight of the weapon (an intrinsic property of the thing), but about the strength required to attack with such a weapon in it's intended manner. In this way it would make sense that neither Feat would work.)
As far as I can see, the rule for using a ranged weapon for melee is just: "If a character uses a ranged weapon to make a melee attack, or throws a melee weapon that does not have the thrown property, it also deals 1d4 damage." That says nothing about changing the traits of the weapon, nor that the weapon is treated as an improvised weapon for the purposes of the attack- the rules for improvised weapons are a seperate clause within the same paragraph. As such, I'd argue that hitting someone with the butt of your heavy crossbow is effectively an attack with a martial weapon, damage 1d4 bludgeoning, with the traits Ammunition (range 100/400), heavy, loading and two-handed- of which ammunition doesn't apply because it's not a ranged attack, and thus loading doesn't constrain multiattack (because only being able to load 1 piece of ammo per round doesn't affect the bonks per round). Per the thrown weapon rules, I'd also argue that bonking people with a crossbow would rely on the attacker's dex, because it doesn't have the finesse property and as a ranged weapon it's dex based.
If you look at the Ammunition Property it says "If you use a weapon that has the ammunition property to make a melee attack, you treat the weapon as an improvised weapon", which I read as meaning your weapon is an Improvised Weapon rather than a Ranged Weapon. Although I do concede that the improvised weapons rule says that if you are using a Ranged Weapon to make a Melee Attack it will deal 1d4 damage, which I assume means that you can't use the rule that says that you can treat it like another similar weapon, which I think is odd, but ok.
(Also, if you want to be very nitpicky about it, the ammunition property says you can't make ranged attacks without loaded ammunition, but any type of attack will spend your ammunition. However, I don't think that's a fair reading, and I think the ammunition property simply does not apply, because you are using it as an Improvised Weapon and therefore none of the Properties apply.)
I suppose if you really wanted to get into the details, the rules in the Ammunition section would not apply to weapons that are Ranged Weapons, but do not have the Ammunition Property, like the Dart or Net. But I feel like it would be most reasonable to rule that these are also considered Improvised Weapons and not Ranged Weapons that deal 1d4 damage if used to make a Melee Attack. (Although the Net can not deal damage as per it's Special Property, so that doesn't really apply to it, so you would be left with the Dart, which doesn't have the Heavy Property, and thus isn't really relevant to the greater discussion here.)
Looks like I was dead wrong here- turns out there's another JC tweet that says: "If you use a weapon in a way that turns it into an improvised weapon—such as smacking someone with a bow—that weapon has none of its regular properties, unless the DM rules otherwise." So bonking people with a crossbow wouldn't count for GWM because the crossbow isn't heavy when you're not shooting it
So JC supports the reading that the weapon becomes an Inprovised Weapon that doesn't have any properties then. (Honestly, I feel like Improvised Weapons, along with Unarmed Attacks, could probably be on the table of weapons.)