primemovr :
No. I already have one of those. I am talking about the m.2 to sata but it uses the pcie "mode" rather than the ssd/sata mode. The motherboard says that if I use the m.2 for regular ssd/sata devices (non-pcie), it will block sata channels, making the conversion useless.
What you want to do is not possible. A Sata SSD must be connected to the motherboard through a Sata channel. A Sata SSD and PCIe SSD use 2 different protocols for communicating with the motherboard chipset. An Intel chipset like Z270 supports only 6 Sata ports total, no more, whether that's through the M.2 slot or the 6 Sata ports built onto the motherboard.
The Syba SI-PEX40064 "PCI-Express to Sata adapter" i use, works because it has it's own Marvell 88SE9215 controller chip mounted on the card itself, that adds 4 Sata ports to your motherboard through a PCI-Express slot larger than x1. The card itself is PCIe x2, so it will not fit into a smaller PCIe x1 slot.
Any high end Intel motherboard with more than 6 Sata ports does this by mounting an extra JMicron or Marvell controller chip to operate the extra ports.