The story
From the idea that the mineral fools people (especially those who are fools) into mistakenly thinking that they have found gold. Regarding minerals that were named for deceptive appearance that prompts confusion with others, compare also apatite.
Etymology from Wiktionary, CC BY-SA 4.0.