I used udev to run the script as soon as the drive is mounted. The tricky part was ensuring the drive would mount automatically when inserted, even if I wasn't logged in. I tried a range of different tools, and eventually settled on autofs.