Step 1: establish the flow you actually need
Flow is usually derived one of two ways. Either you have a volume and a deadline — an excavation holding a known quantity of water that has to be clear by a given time — or you have a rate of ingress that has to be matched or exceeded.
For a volume and a deadline, divide one by the other and add margin for the water still arriving while you pump. For an ingress rate, measure it if you can: a pump sized exactly to the inflow never gets ahead and runs continuously.
Round up to the model above your calculated figure rather than the one below. Capacity falls as head rises, so a pump quoted at your exact requirement will deliver less than that at your actual duty point.