The sentence should read: "It was he at the door."
Here's why:
* Subject Pronoun: "He" is the subject pronoun, used when the pronoun is the subject of the verb.
* Object Pronoun: "Him" is the object pronoun, used when the pronoun is the object of the verb or a preposition.
In this sentence, "he" is the subject of the implied verb "was."