Anytime God makes an appearance on Planet Earth in Scripture, I think of the One known as Jesus of Nazareth. Is that what you meant?
Something close to that. Really. Go read it. It is the 'Angel of the Lord' in the burning bush, who calls himself YHWH and I AM, and accepts worship.
No man has seen God, but many men have seen God, even walked with him, and ate with him - That has to be quantified, as both statements are true according to the Bible... As is this one:
Hear O Israel! Our God is one God!