Petrol and diesel are always cheapest from a supermarket and these are often open 24 hours a day (with credit cards).  Near Brantôme, Carrefour has the cheapest petrol, other shops nearby with cheap petrol include Auchan or E.Leclerc.