Hi which cable do I need to backup my time machine on my new MacBook Air?

Depends on the drive you are using.

Generally, however, if it is a USB drive, you need an appropriate USB-A to USB-C adapter or a USB-C cable that has the same connector at one end that matches the connector on the drive.