This is the gadget I made up out of bits in the junk box. I will find loading the foto more difficult than making the kludge shewn.
Going from left to right we have
1. !/2" BSP nipple.
2. 1/2" to 1/4" reducing bush.
3. 1/4 to1/2 thingo
4. A bit cut off a 3/8" bolt
5. Another 1/2" nipple
6. Not in the foto but you need sealing washers betweenthe gas bottles at each end. Those blue (orange) polyurethane washers that go between the garden tap and the hose are a good source except the the head gardener gets ****** 'cause her tap leaks.
The bit of cut off bolt is the only tricky bit as you must grind one end to a taper and hacksaw a screwdriver slot in the other then use your hacksaw to cut a shallow groove down the long axis to give the gas a route thru the thread.
The final step before assembly is to run a 3/8" tap thru the 1/4 to 1/2" reducing thingo.
Assembly.
Screw 4 into 3 then 3 into 5. The pointy end of 4 should be flush with the end of 3.
Fit a seal into 5 and screw firmly onto soda stream (A tad more than fingertite should be enough)
Get a screwdriver and screw 4 into the bottle until the gas starts to escape and back off a turn
Remove the assy and put the turn back then assemble the lot
Dont forget the seal at (1). I found I had to cut a few mil of (1) to get the seal to seat.
Its not rocket science and you can buy all the bits including the tap for $20.00.
One other thing. A 3/8 bolt (9.5mm) is as big as you can go with this configuration as 10mm.(the metric equivalent) does not leave enough meat in the skinny end of item (3)
One other thing. This suits my supply bottle. There are other threads out there so you must check your bottle