• Resolved mattgg

    (@mattgg)


    Hello,

    I have successfully installed the plugin, created a sheet, gave the plugin access (I can see the access granted in my Google Account settings), but when I try to submit I just get the Error in Google Request error in the logs. I’ve confirmed both my spreadsheet name and tab name are just lowercase letters and match what’s in my Contact Form.
    Do you have any suggestions?

    Thanks

    23 September 2019 07:00:51 	 PHP 7.3.9Array
    (
        [date] => September 23, 2019
        [time] => 7:00 am
        [serial-number] => 
        [remote-ip] => 172.17.0.1
        [user-agent] => Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36
        [url] => http://192.168.1.105/
        [post-id] => 5588
        [post-name] => test-page
        [post-title] => Test Page
        [post-url] => http://192.168.1.105/
        [post-author] => matt
        [post-author-email] => [email protected]
        [site-title] => WordPress Blog
        [site-description] => Blog
        [site-url] => http://192.168.1.105
        [site-admin-email] => [email protected]
        [user-login] => 
        [user-email] => 
        [user-url] => 
        [user-first-name] => 
        [user-last-name] => 
        [user-nickname] => 
        [user-display-name] => 
        [your-name] => Matt
        [your-email] => [email protected]
        [address-one] => my address
        [address-two] => 
        [city] => My City
        [state] => CA
        [zipcode] => 90210
        [country] => United States
        [ERROR_MSG] => Error in Google Request
        [TRACE_STK] => #0 /var/www/html/wp-content/plugins/cf7-google-sheets-connector/lib/asimlqt/php-google-spreadsheet-client/src/Google/Spreadsheet/DefaultServiceRequest.php(146): Google\Spreadsheet\DefaultServiceRequest->execute(Resource id #24)
    #1 /var/www/html/wp-content/plugins/cf7-google-sheets-connector/lib/asimlqt/php-google-spreadsheet-client/src/Google/Spreadsheet/ListFeed.php(78): Google\Spreadsheet\DefaultServiceRequest->post('https://spreads...', '<entry xmlns="h...')
    #2 /var/www/html/wp-content/plugins/cf7-google-sheets-connector/lib/google-sheets.php(83): Google\Spreadsheet\ListFeed->insert(Array)
    #3 /var/www/html/wp-content/plugins/cf7-google-sheets-connector/includes/class-gs-service.php(175): cf7gsc_googlesheet->add_row(Array)
    #4 /var/www/html/wp-includes/class-wp-hook.php(286): Gs_Connector_Service->cf7_save_to_google_sheets(Object(WPCF7_ContactForm))
    #5 /var/www/html/wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters('', Array)
    #6 /var/www/html/wp-includes/plugin.php(465): WP_Hook->do_action(Array)
    #7 /var/www/html/wp-content/plugins/contact-form-7/includes/submission.php(214): do_action('wpcf7_mail_sent', Object(WPCF7_ContactForm))
    #8 /var/www/html/wp-content/plugins/contact-form-7/includes/submission.php(34): WPCF7_Submission->submit()
    #9 /var/www/html/wp-content/plugins/contact-form-7/includes/contact-form.php(740): WPCF7_Submission::get_instance(Object(WPCF7_ContactForm), Array)
    #10 /var/www/html/wp-content/plugins/contact-form-7/includes/rest-api.php(280): WPCF7_ContactForm->submit()
    #11 /var/www/html/wp-includes/rest-api/class-wp-rest-server.php(946): wpcf7_rest_create_feedback(Object(WP_REST_Request))
    #12 /var/www/html/wp-includes/rest-api/class-wp-rest-server.php(329): WP_REST_Server->dispatch(Object(WP_REST_Request))
    #13 /var/www/html/wp-includes/rest-api.php(309): WP_REST_Server->serve_request('/contact-form-7...')
    #14 /var/www/html/wp-includes/class-wp-hook.php(286): rest_api_loaded(Object(WP))
    #15 /var/www/html/wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters(NULL, Array)
    #16 /var/www/html/wp-includes/plugin.php(531): WP_Hook->do_action(Array)
    #17 /var/www/html/wp-includes/class-wp.php(387): do_action_ref_array('parse_request', Array)
    #18 /var/www/html/wp-includes/class-wp.php(737): WP->parse_request('')
    #19 /var/www/html/wp-includes/functions.php(1105): WP->main('')
    #20 /var/www/html/wp-blog-header.php(16): wp()
    #21 /var/www/html/index.php(17): require('/var/www/html/w...')
    #22 {main}
    )
    • This topic was modified 6 years, 8 months ago by Jan Dembowski.
    • This topic was modified 6 years, 8 months ago by Jan Dembowski. Reason: Formatting
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author WesternDeal

    (@westerndeal)

    Hi @mattgg,

    Have you updated the plugin to the latest version? After update reauthenticate again by taking fresh authentication code and then test.

    Let us know if you still find the issue.

    Thanks
    Abdullah

    Thread Starter mattgg

    (@mattgg)

    It looks like I had a column name not matching exactly. It works now, thanks.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Error in Google Request’ is closed to new replies.