Use the GtkWindow::close-request signal: it’s exactly what you’re looking for.
GtkWindow::close-request