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

  • Resolved stewartjp98

    (@stewartjp98)


    Getting an error when sending the form data to Google Sheets. I’ve read many other posts regarding this error message but I can’t find anything I’m doing wrong. The email response works perfectly. Help would be much appreciated. The error message is shown below:

    [ERROR_MSG] => Error in Google Request
    [TRACE_STK] => #0 /opt/bitnami/apps/wordpress/htdocs/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 #16)
    #1 /opt/bitnami/apps/wordpress/htdocs/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…&#8217;, ‘<entry xmlns=”h…’)
    #2 /opt/bitnami/apps/wordpress/htdocs/wp-content/plugins/cf7-google-sheets-connector/lib/google-sheets.php(80): Google\Spreadsheet\ListFeed->insert(Array)
    #3 /opt/bitnami/apps/wordpress/htdocs/wp-content/plugins/cf7-google-sheets-connector/includes/class-gs-service.php(175): CF7GSC_googlesheet->add_row(Array)
    #4 /opt/bitnami/apps/wordpress/htdocs/wp-includes/class-wp-hook.php(286): Gs_Connector_Service->cf7_save_to_google_sheets(Object(WPCF7_ContactForm))
    #5 /opt/bitnami/apps/wordpress/htdocs/wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters(”, Array)
    #6 /opt/bitnami/apps/wordpress/htdocs/wp-includes/plugin.php(465): WP_Hook->do_action(Array)
    #7 /opt/bitnami/apps/wordpress/htdocs/wp-content/plugins/contact-form-7/includes/submission.php(214): do_action(‘wpcf7_mail_sent’, Object(WPCF7_ContactForm))
    #8 /opt/bitnami/apps/wordpress/htdocs/wp-content/plugins/contact-form-7/includes/submission.php(34): WPCF7_Submission->submit()
    #9 /opt/bitnami/apps/wordpress/htdocs/wp-content/plugins/contact-form-7/includes/contact-form.php(740): WPCF7_Submission::get_instance(Object(WPCF7_ContactForm), Array)
    #10 /opt/bitnami/apps/wordpress/htdocs/wp-content/plugins/contact-form-7/includes/rest-api.php(280): WPCF7_ContactForm->submit()
    #11 /opt/bitnami/apps/wordpress/htdocs/wp-includes/rest-api/class-wp-rest-server.php(946): wpcf7_rest_create_feedback(Object(WP_REST_Request))
    #12 /opt/bitnami/apps/wordpress/htdocs/wp-includes/rest-api/class-wp-rest-server.php(329): WP_REST_Server->dispatch(Object(WP_REST_Request))
    #13 /opt/bitnami/apps/wordpress/htdocs/wp-includes/rest-api.php(309): WP_REST_Server->serve_request(‘/contact-form-7…’)
    #14 /opt/bitnami/apps/wordpress/htdocs/wp-includes/class-wp-hook.php(286): rest_api_loaded(Object(WP))
    #15 /opt/bitnami/apps/wordpress/htdocs/wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters(”, Array)
    #16 /opt/bitnami/apps/wordpress/htdocs/wp-includes/plugin.php(531): WP_Hook->do_action(Array)
    #17 /opt/bitnami/apps/wordpress/htdocs/wp-includes/class-wp.php(387): do_action_ref_array(‘parse_request’, Array)
    #18 /opt/bitnami/apps/wordpress/htdocs/wp-includes/class-wp.php(737): WP->parse_request(”)
    #19 /opt/bitnami/apps/wordpress/htdocs/wp-includes/functions.php(1105): WP->main(”)
    #20 /opt/bitnami/apps/wordpress/htdocs/wp-blog-header.php(16): wp()
    #21 /opt/bitnami/apps/wordpress/htdocs/index.php(17): require(‘/opt/bitnami/ap…’)
    #22 {main}

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • I was getting the same error, while I was trying to use this plugin for serial numbers, which is very good for generating specific IDs. After disabling it, works well. But I need the plugin. Bad situation.

    https://wordpress.org/plugins/contact-form-7-serial-numbers/

    Plugin Author westerndeal

    (@westerndeal)

    Hi @stewartjp98,

    It seems you have not sent us a full error log. You can send us full log by submitting a support ticket.

    Anyhow, If data is not entered to your sheet then you might be using an incorrect format of Google Sheet Header Name.

    It must only have small alphabets and hyphen. Example Your Name must be your-name, Date must be date, etc. Make sure it doesn’t have capital letters, number as initial and special characters like underscores, double or single code, space, etc.

    @sirdik

    You can use Flamingo Plugin for serial numbers which is of CF7 itself.

    As Contact Form 7 Serial Number is 3rd party plugin and has own custom code so it will not work with ours.

    But we do have a solution to get Contact Form 7 Serial Number to Google Sheet if you are using the pro version CF7 Google Sheet Connector.

    Thanks
    Abdullah

    Hi @westerndeal

    same error here:

    21 September 2019 07:28:05 	 PHP 7.2.22Array
    (
        [date] => 21. September 2019
        [time] => 7:28
        [serial-number] => 
        [remote-ip] => 91.67.114.44
        [user-agent] => Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36
        [url] => https://staging.my-domain.com/
        [post-id] => 89
        [post-name] => start
        [post-title] => Startseite
        [post-url] => https://staging.my-domain.com/
        [post-author] => mmichely
        [post-author-email] => my-name@my-domain.com
        [site-title] => Michely Web Engineering UG
        [site-description] => 
        [site-url] => https://staging.my-domain.com
        [site-admin-email] => my-name@my-domain.com
        [user-login] => 
        [user-email] => 
        [user-url] => 
        [user-first-name] => 
        [user-last-name] => 
        [user-nickname] => 
        [user-display-name] => 
        [your-name] => Name
        [your-email] => email@bla.com
        [your-subject] => sadf
        [your-message] => blub
        [ERROR_MSG] => Error in Google Request
        [TRACE_STK] => #0 /path/to/www/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 #663)
    #1 /path/to/www/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 /path/to/www/wp-content/plugins/cf7-google-sheets-connector/lib/google-sheets.php(83): Google\Spreadsheet\ListFeed->insert(Array)
    #3 /path/to/www/wp-content/plugins/cf7-google-sheets-connector/includes/class-gs-service.php(175): cf7gsc_googlesheet->add_row(Array)
    #4 /path/to/www/wp-includes/class-wp-hook.php(286): Gs_Connector_Service->cf7_save_to_google_sheets(Object(WPCF7_ContactForm))
    #5 /path/to/www/wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters('', Array)
    #6 /path/to/www/wp-includes/plugin.php(465): WP_Hook->do_action(Array)
    #7 /path/to/www/wp-content/plugins/contact-form-7/includes/submission.php(214): do_action('wpcf7_mail_sent', Object(WPCF7_ContactForm))
    #8 /path/to/www/wp-content/plugins/contact-form-7/includes/submission.php(34): WPCF7_Submission->submit()
    #9 /path/to/www/wp-content/plugins/contact-form-7/includes/contact-form.php(740): WPCF7_Submission::get_instance(Object(WPCF7_ContactForm), Array)
    #10 /path/to/www/wp-content/plugins/contact-form-7/includes/rest-api.php(280): WPCF7_ContactForm->submit()
    #11 /path/to/www/wp-includes/rest-api/class-wp-rest-server.php(946): wpcf7_rest_create_feedback(Object(WP_REST_Request))
    #12 /path/to/www/wp-includes/rest-api/class-wp-rest-server.php(329): WP_REST_Server->dispatch(Object(WP_REST_Request))
    #13 /path/to/www/wp-includes/rest-api.php(309): WP_REST_Server->serve_request('/contact-form-7...')
    #14 /path/to/www/wp-includes/class-wp-hook.php(286): rest_api_loaded(Object(WP))
    #15 /path/to/www/wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters(NULL, Array)
    #16 /path/to/www/wp-includes/plugin.php(531): WP_Hook->do_action(Array)
    #17 /path/to/www/wp-includes/class-wp.php(387): do_action_ref_array('parse_request', Array)
    #18 /path/to/www/wp-includes/class-wp.php(737): WP->parse_request('')
    #19 /path/to/www/wp-includes/functions.php(1105): WP->main('')
    #20 /path/to/www/wp-blog-header.php(16): wp()
    #21 /path/to/www/index.php(17): require('/path/to/www/...')
    #22 {main}
    )
    • This reply was modified 1 year, 2 months ago by michelyweb.
    Plugin Author westerndeal

    (@westerndeal)

    Hi @michelyweb,

    We have released an update. Have you updated the plugin to the latest version?

    After update reauthenticate again using a fresh authentication code.

    Let us know if you still find any issue.

    Thanks
    Abdullah

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Error in Google Request’ is closed to new replies.