Given an address or coordinates, Geocodio will return statistical boundaries from Statistics Canada.
Census Metropolitan Area or Census Agglomeration
Note that Canadian addresses must be accompanied by "Canada" given exactly, whether as a column in the spreadsheet (multi-column format) or in the address (single-column format). See examples here.
If you'd prefer to use an API, you can see our technical documentation here.