Pulse Check send email if no data exist

Greetings everyone! I'm exploring the possibility of conducting a pulse check in Metabase to determine if a table is empty. The goal is to receive an email notification if the table contains no data. I've crafted a query that checks each row, and my intention is to trigger an email notification when the row count is zero. However, I'm unsure about the steps to integrate this with an email notification. Any guidance on incorporating email notifications would be greatly appreciated!

SELECT COUNT(*) AS row_count
FROM (
    SELECT segments_date,
           customer_id,
           SUM(metrics_impressions) AS total_impressions,
           SUM(metrics_cost_micros)/1000000.0 AS total_cost
    FROM GOOGLEADS.EXTRACTS.DEVICE_AD_PERFORMANCE
    WHERE segments_date BETWEEN CURRENT_DATE() - 1 AND CURRENT_DATE()
    GROUP BY segments_date, customer_id
) AS subquery