My spouse and I are German nationals. We are going to buy a house in France from a couple where the husband is also German. The preliminary sale agreement was written in German. The notary tells us it is not possible for the authentic sale ...

....deed to be in German. Is this correct?

Yes. While it is possible to draft a private agreement in a foreign language under certain conditions, documents prepared by a notary must be written in French.