BTW, in the Project Settings for SuperTiled2Unity you can assign the default material that you want all your Tilemap and Sprite renderers to use so for most people this will be the easiest/best way to use a custom material.
If you want sometime a bit more complicated like, say, different materials for different Tiled layers then you'll want to use a custom importer.