In Magic the Gathering, when does Merrow Reejerey's second effect activate?

Casting a spell means it goes onto the stack and resolves. A Merfolk spell is anything with the subtype of Merfolk, so a Merfolk sorcery would trigger it just like a Merfolk creature would.