The hosts restricted the Kiwis to a modest 139 for seven following a fiery spell of fast bowling by Shukla and then overhauled the target with five balls to spare.
Shukla, who was included in place of Vikramjeet Malik, was called on to bowl fourth over of the innings and he removed Hamish Rutherford (11) with his first ball, skipper McCullum (0) with third and Derrek de Boorder (0) on fifth.
Down the order Nathan McCullum (28) and Ian Butler (25) added some useful runs.
Royals' 12th victory on the trot at home ensured that Royals finished atop on Group A with 16 points and will now play their semifinal at home.
More From This Section
Royals wins also keeps Mumbai Indians in hunt for the semifinals. Mumbai are third in the table with six points behind Volts (10). Mumbai now need to win tomorrow's match against Perth Scorchers and also have a better Net-Run-Rate.
Hodge hit three sixes and five fours and completed his half-century and team's win with a cover drive off Ian Butler.
Before Hodge arrived on the scene, opener Ajinkya Rahane hit a measured 52 off 48 balls to stabilise the innings. Hodge and Rahane formed a 44-run stand for fifth wicket to repair the damage.
After Rahane's departure, the veteran Australian single handedly took the side to victory in an exciting finish.