You are tasked with creating an automated SQL data pipeline using BigQuery. The pipeline must perform an aggregate SQL transformation on a specified BigQuery table every two hours and subsequently append the transformation results to another pre-existing BigQuery table. Additionally, the pipeline needs to be robust, capable of retrying in case of errors. It is crucial that the pipeline is also configured to send an email notification after it encounters three consecutive failures. What steps should you take to achieve this configuration? | Google Professional Data Engineer Quiz