You are tasked with preparing a dataset of customer transactions for analysis. The dataset has issues such as missing values, duplicate entries, and inconsistent formatting of date and currency fields. You want to automate this data cleaning process and make it repeatable using Google Cloud tools. Which of the following would be the most efficient approach to handle these tasks?