Sometimes data are not sent to google sheets

Hello @stefan22
Thanks for getting in touch,

1. Can you confirm that you are getting emails when form is filled?
Make sure that mail server is enabled from your hosting provider,
2. If you are getting emails and entries are not showing in sheet and CF7DB then can you enable the debug log from wp-config.php and provide me the debug.log with current date, if showing old errors then delete the existing log and then try to fill the form and see if shows any error.

Let me know to help you further!

Thanks
Abdullah

I found this

    [TRACE_STK] => #0 /www/doc/www.edusteps.sk/www/wp-content/plugins/cf7-google-sheets-connector-pro/lib/src/Http/REST.php(107): Google\Http\REST::decodeHttpResponse(Object(GuzzleHttp\Psr7\Response), Object(GuzzleHttp\Psr7\Request), 'Google\\Service\\...')
#1 [internal function]: Google\Http\REST::doExecute(Object(GuzzleHttp\Client), Object(GuzzleHttp\Psr7\Request), 'Google\\Service\\...')
#2 /www/doc/www.edusteps.sk/www/wp-content/plugins/cf7-google-sheets-connector-pro/lib/src/Task/Runner.php(187): call_user_func_array(Array, Array)
#3 /www/doc/www.edusteps.sk/www/wp-content/plugins/cf7-google-sheets-connector-pro/lib/src/Http/REST.php(66): Google\Task\Runner->run()
#4 /www/doc/www.edusteps.sk/www/wp-content/plugins/cf7-google-sheets-connector-pro/lib/src/Client.php(920): Google\Http\REST::execute(Object(GuzzleHttp\Client), Object(GuzzleHttp\Psr7\Request), 'Google\\Service\\...', Array, NULL)
#5 /www/doc/www.edusteps.sk/www/wp-content/plugins/cf7-google-sheets-connector-pro/lib/src/Service/Resource.php(238): Google\Client->execute(Object(GuzzleHttp\Psr7\Request), 'Google\\Service\\...')
#6 /www/doc/www.edusteps.sk/www/wp-content/plugins/wp_edusteps_sheets_connector/vendor/google/apiclient-services/src/Sheets/Resource/Spreadsheets.php(104): Google\Service\Resource->call('get', Array, 'Google\\Service\\...')
#7 /www/doc/www.edusteps.sk/www/wp-content/plugins/cf7-google-sheets-connector-pro/lib/google-sheets.php(411): Google\Service\Sheets\Resource\Spreadsheets->get('1XjgGsD21OIgEt3...')
#8 /www/doc/www.edusteps.sk/www/wp-content/plugins/cf7-google-sheets-connector-pro/includes/class-gs-service.php(634): CF7GSC_googlesheet_PRO->add_header('Testovaci formu...', 'Sheet1', Array, Array)
#9 /www/doc/www.edusteps.sk/www/wp-includes/class-wp-hook.php(308): Gs_Connector_Service->save_gs_settings(Object(WPCF7_ContactForm))
#10 /www/doc/www.edusteps.sk/www/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters(NULL, Array)
#11 /www/doc/www.edusteps.sk/www/wp-includes/plugin.php(517): WP_Hook->do_action(Array)
#12 /www/doc/www.edusteps.sk/www/wp-content/plugins/contact-form-7/includes/contact-form.php(1251): do_action('wpcf7_after_sav...', Object(WPCF7_ContactForm))
#13 /www/doc/www.edusteps.sk/www/wp-content/plugins/contact-form-7/includes/contact-form-functions.php(213): WPCF7_ContactForm->save()
#14 /www/doc/www.edusteps.sk/www/wp-content/plugins/contact-form-7/admin/admin.php(245): wpcf7_save_contact_form(Array)
#15 /www/doc/www.edusteps.sk/www/wp-includes/class-wp-hook.php(306): wpcf7_load_contact_form_admin()
#16 /www/doc/www.edusteps.sk/www/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters('', Array)
#17 /www/doc/www.edusteps.sk/www/wp-includes/plugin.php(517): WP_Hook->do_action(Array)
#18 /www/doc/www.edusteps.sk/www/wp-admin/admin.php(237): do_action('load-toplevel_p...')
#19 {main}
)
19 m?ˇja 2023 14:46:44 	 PHP 8.1.19 	 CF7GSC_googlesheet_PRO::remove_alternate_colors Error in removing alternate colors.{
  "error": {
    "code": 429,
    "message": "Quota exceeded for quota metric 'Read requests' and limit 'Read requests per minute' of service 'sheets.googleapis.com' for consumer 'project_number:1075324102277'.",
    "errors": [
      {
        "message": "Quota exceeded for quota metric 'Read requests' and limit 'Read requests per minute' of service 'sheets.googleapis.com' for consumer 'project_number:1075324102277'.",
        "domain": "global",
        "reason": "rateLimitExceeded"
      }
    ],
    "status": "RESOURCE_EXHAUSTED",
    "details": [
      {
        "@type": "type.googleapis.com/google.rpc.ErrorInfo",
        "reason": "RATE_LIMIT_EXCEEDED",
        "domain": "googleapis.com",
        "metadata": {
          "service": "sheets.googleapis.com",
          "consumer": "projects/1075324102277",
          "quota_metric": "sheets.googleapis.com/read_requests",
          "quota_limit_value": "300",
          "quota_location": "global",
          "quota_limit": "ReadRequestsPerMinutePerProject"
        }
      },
      {
        "@type": "type.googleapis.com/google.rpc.Help",
        "links": [
          {
            "description": "Request a higher quota limit.",
            "url": "https://cloud.google.com/docs/quota#requesting_higher_quota"
          }
        ]
      }
    ]
  }
}
 

Hello @stefan22

Thanks for the error log,
As you are using PRO version, please email us at [email protected]

Solution
1. Deactivate the plugin you are using named wp_edusteps_sheets_connector under wp-content/plugins/ not sure which plugin is this so deactivate and let me know through email,
As this support area is for FREE versions.

Thanks
Abdullah