pages 12.1 mail merge

I have a decently large spreadsheet which I would like to use as a mail merge. Rather than merge the entire data set I would like to be able to select a range often of one entry and use that, via mail merge to populate a complicated template, is this possible with the new release of pages?

I use word and excel at the moment but I would prefer to stick with native apps not least because I find Numbers as a stand alone app more intuitive than excel, and Macos doesn't always play nice with MS office apps.

I have noticed that if I filter the spreadsheet in numbers those records are what shows in the mail merge but if I filter it down to one entry the entire sheet vanishes from the mail merge options.