Her result in the fourth round of the series at Hamburg lifted Hewitt to fourth place overall with three races remaining.
The Christchurch athlete was on the pace throughout the race but couldn't match the finishing power and speed of the winner, Sweden's Lisa Norden, silver medallist Emma Moffatt, of Australia, and third-placed Aileen Morrison, of Ireland.
Hewitt posted a time of one hour 53 minutes 59 seconds, just 6sec behind Norden.
Fellow New Zealanders Teresa Adam and Rebecca Kingsford finished 41st and 50th respectively.
Moffatt takes over the lead in the series rankings on 2110 points, followed by Japan's Mariko Adachi on 2106, Chile's Barbara Riveros Diaz on 2082 and Hewitt on 1868.
The series continues next weekend with round five in London.
Leading results:-
Elite women: Lisa Norden (Sweden) 1hr 53 min 53sec 1, Emma Moffatt (Australia) 1:53.53 2, Aileen Morrison (Ireland) 1:53.55 3, Kate Roberts (South Africa) 1:53.57 4, Vicky Holland (Britain) 1:53.57 5, ANDREA HEWITT (NZ) 1:53.59 6. Also: Teresa Adam (NZ) 1:59.54 41, Rebecca Kingsford (NZ) 2:02.54 50.
