Looking at the log, errors from the gsheetconnector-for-elementor-forms plugin are preventing it from functioning:
PHP Deprecated: Creation of dynamic property Google\Service\Sheets\CellFormat::$backgroundColor
PHP Deprecated: Creation of dynamic property Google\Service\Sheets\Spreadsheet::$properties
…
Root Cause
The server is running PHP 8.2 or 8.3. In PHP 8.2+, creating “dynamic properties” on classes is deprecated, and in PHP 8.3, it becomes a fatal error that blocks the script from running. Therefore, the lead is never sent to Google Sheets.
The Google API Client library included in the plugin is too old and not compatible with PHP 8.2/8.3.
I also note that with PHP version 8.2 or higher, automation no longer works and contacts are no longer inserted. This is due to a deprecated library version. Unfortunately, it has become unusable and absolutely requires a fix.
Please update soon.