Balancing sustainability and disruption of supply chains requires organizational ambidexterity. Sustainable supply chains prioritize efficiency and economies of scale and may not have sufficient redundancy to withstand disruptive events. There is a developing body of literature that attempts to reconcile these two aspects. This study gives a data-driven literature review of sustainable supply chain management trends toward ambidexterity and disruption. The critical review reveals temporal trends and geographic distribution of literature. A hybrid of data-driven analysis approach based on content and bibliometric analyses, fuzzy Delphi method, entropy weight method, and fuzzy decision-making trial and evaluation laboratory is used on 273 keywords and 22 indicators obtained based on the experts’ evaluation. The most important indicators are identified as supply chain agility, supply chain coordination, supply chain finance, supply chain flexibility, supply chain resilience, and sustainability. The regions show different tendencies compared with others. Asia and Oceania, Latin America and the Caribbean, and Africa are the regions needs improvement, while Europe and North America show distinct apprehensions on supply chain network design. The main contribution of this review is the identification of the knowledge frontier, which then leads to a discussion of prospects for future studies and practical industry implementation.