Support » Plugin: CF7 Google Sheets Connector » CF7 Google Sheets Connector PRO Error Messages – Won’t Connect to Sheets

  • Fails to populate the google sheet – here is the debug log.

    6 June 2019 18:00:37 PHP 7.2.15Array
    (
    [customer-name] => Amy Pena
    [email] => apena@petroms.com
    [phone-number] => 713-816-5107
    [Operator] => Operator
    [Location] => Rig Location
    [Date/Time Needed] => 06/10
    [Order Request] => Order
    Order
    Order
    Order
    [ERROR_MSG] => Error in Google Request
    [TRACE_STK] => #0 /home/content/p3pnexwpnas04_data03/60/2988160/html/wp-content/plugins/cf7-google-sheets-connector-pro/lib/asimlqt/php-google-spreadsheet-client/src/Google/Spreadsheet/DefaultServiceRequest.php(146): Google\Spreadsheet\DefaultServiceRequest->execute(Resource id #164)
    #1 /home/content/p3pnexwpnas04_data03/60/2988160/html/wp-content/plugins/cf7-google-sheets-connector-pro/lib/asimlqt/php-google-spreadsheet-client/src/Google/Spreadsheet/ListFeed.php(78): Google\Spreadsheet\DefaultServiceRequest->post(‘https://spreads…’, ‘<entry xmlns=”h…’)
    #2 /home/content/p3pnexwpnas04_data03/60/2988160/html/wp-content/plugins/cf7-google-sheets-connector-pro/lib/google-sheets.php(83): Google\Spreadsheet\ListFeed->insert(Array)
    #3 /home/content/p3pnexwpnas04_data03/60/2988160/html/wp-content/plugins/cf7-google-sheets-connector-pro/includes/class-gs-service.php(499): CF7GSC_googlesheet->add_row(Array)
    #4 /home/content/p3pnexwpnas04_data03/60/2988160/html/wp-includes/class-wp-hook.php(286): Gs_Connector_Service->cf7_save_to_google_sheets(Object(WPCF7_ContactForm))
    #5 /home/content/p3pnexwpnas04_data03/60/2988160/html/wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters(”, Array)
    #6 /home/content/p3pnexwpnas04_data03/60/2988160/html/wp-includes/plugin.php(465): WP_Hook->do_action(Array)
    #7 /home/content/p3pnexwpnas04_data03/60/2988160/html/wp-content/plugins/contact-form-7/includes/submission.php(214): do_action(‘wpcf7_mail_sent’, Object(WPCF7_ContactForm))
    #8 /home/content/p3pnexwpnas04_data03/60/2988160/html/wp-content/plugins/contact-form-7/includes/submission.php(34): WPCF7_Submission->submit()
    #9 /home/content/p3pnexwpnas04_data03/60/2988160/html/wp-content/plugins/contact-form-7/includes/contact-form.php(729): WPCF7_Submission::get_instance(Object(WPCF7_ContactForm), Array)
    #10 /home/content/p3pnexwpnas04_data03/60/2988160/html/wp-content/plugins/contact-form-7/includes/rest-api.php(280): WPCF7_ContactForm->submit()
    #11 /home/content/p3pnexwpnas04_data03/60/2988160/html/wp-includes/rest-api/class-wp-rest-server.php(946): wpcf7_rest_create_feedback(Object(WP_REST_Request))
    #12 /home/content/p3pnexwpnas04_data03/60/2988160/html/wp-includes/rest-api/class-wp-rest-server.php(329): WP_REST_Server->dispatch(Object(WP_REST_Request))
    #13 /home/content/p3pnexwpnas04_data03/60/2988160/html/wp-includes/rest-api.php(309): WP_REST_Server->serve_request(‘/contact-form-7…’)
    #14 /home/content/p3pnexwpnas04_data03/60/2988160/html/wp-includes/class-wp-hook.php(286): rest_api_loaded(Object(WP))
    #15 /home/content/p3pnexwpnas04_data03/60/2988160/html/wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters(”, Array)
    #16 /home/content/p3pnexwpnas04_data03/60/2988160/html/wp-includes/plugin.php(531): WP_Hook->do_action(Array)
    #17 /home/content/p3pnexwpnas04_data03/60/2988160/html/wp-includes/class-wp.php(387): do_action_ref_array(‘parse_request’, Array)
    #18 /home/content/p3pnexwpnas04_data03/60/2988160/html/wp-includes/class-wp.php(737): WP->parse_request(”)
    #19 /home/content/p3pnexwpnas04_data03/60/2988160/html/wp-includes/functions.php(1105): WP->main(”)
    #20 /home/content/p3pnexwpnas04_data03/60/2988160/html/wp-blog-header.php(16): wp()
    #21 /home/content/p3pnexwpnas04_data03/60/2988160/html/index.php(17): require(‘/home/content/p…’)
    #22 {main}
    )

Viewing 1 replies (of 1 total)
  • Plugin Author Abdullah WesternDeal

    (@westerndeal)

    Hi @apenpetroms,

    Sorry for the trouble.

    The error – Error in Google Request means you are using incorrect format of Google Sheet Header Name.

    It must only have small alphabets and hyphen. change Operator to operator, Date/Time Needed to date-time-needed, Order Request to order-request and so on.

    We have stated in our document that the header name must not have capital letters, number as initial and special characters like underscores, double or single code, space etc.

    Hope this helps. let us know.

    Thanks
    Abdullah

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.