Support » Plugin: CF7 Google Sheets Connector » Error in Google Request

  • 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] => fake@email.com
        [site-title] => WordPress Blog
        [site-description] => Blog
        [site-url] => http://192.168.1.105
        [site-admin-email] => fake@email.com
        [user-login] => 
        [user-email] => 
        [user-url] => 
        [user-first-name] => 
        [user-last-name] => 
        [user-nickname] => 
        [user-display-name] => 
        [your-name] => Matt
        [your-email] => matt@email.com
        [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 months, 2 weeks ago by Jan Dembowski.
    • This topic was modified 6 months, 2 weeks ago by Jan Dembowski. Reason: Formatting
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Abdullah 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

    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.