Just after I posted, I noticed you are connected to Mexico, so unsure of your vehicle insurance status.
Will the vehicle you intend to drive into Canada already have U.S., or other, insurance which allows you to take it into Canada (that is between you and your insurer)? If so, no further insurance is required. Regardless, you have to have proper insurance on your vehicle to enter Canada.
The only temporary (Canadian) insurance for foreigners who wish to drive in Canada, that I know of, is related to visitors who, after arrival, wish to drive a Canadian registered/insured vehicle and wish to have temporary insurance to do so. This type of insurance can be obtained from a Canadian based insurance company (depending on province, some are private, while other are government).
But I know of no Canadian-based insurer who will insure a foreigner who wishes to enter the country with their own vehicle for a holiday.
Unless I am misunderstanding what you are trying to do,
Marv