Connecting photometric and spectroscopic granulation signals with CHEOPS and ESPRESSO