Dosn't work

Hello.
Now I debugging code.

1. logs file crash bcs in string 335 $error is a array
2.

Error refreshing the OAuth2 token, message: '{
  "error" : "invalid_request",
  "error_description" : "Missing required parameter: refresh_token"
}''
#0 /var/www/html/dreamFactory/web/app/plugins/ns-google-sheets-connector/lib/php-google-oauth/auth/Google_OAuth2.php(244): Google_OAuth2->refreshTokenRequest(Array)
#1 /var/www/html/dreamFactory/web/app/plugins/ns-google-sheets-connector/lib/php-google-oauth/Google_Client.php(315): Google_OAuth2->refreshToken(NULL)
#2 /var/www/html/dreamFactory/web/app/plugins/ns-google-sheets-connector/lib/google-sheets.php(50): Google_Client->refreshToken(NULL)
#3 /var/www/html/dreamFactory/web/app/plugins/ns-google-sheet'...

Ok. Plugin have bugs.
Fixes for correct work(part1):
1. set permissions for folder logs 777 recursive
2. Upgrade code in ns-google-sheets-connector.php – string 332

try{
			$log = fopen(plugin_dir_path(__FILE__) . "logs/log.txt", 'a');
            if(is_array($error)) {
                $error = implode(",", $error);
            }

			$result = fwrite($log, print_r(date('H:i:s')." \t PHP ".phpversion()." \t $error \r\n", TRUE));
			fclose( $log );
		} catch (Exception $e) {

		}

After that I see correct debug log

20:20:11 	 PHP 5.5.9-1ubuntu4.14 	 Error refreshing the OAuth2 token, message: '{
  "error" : "invalid_request",
  "error_description" : "Missing required parameter: refresh_token"
}',#0 /var/www/html/dreamFactory/web/app/plugins/ns-google-sheets-connector/lib/php-google-oauth/auth/Google_OAuth2.php(244): Google_OAuth2->refreshTokenRequest(Array)
#1 /var/www/html/dreamFactory/web/app/plugins/ns-google-sheets-connector/lib/php-google-oauth/Google_Client.php(315): Google_OAuth2->refreshToken(NULL)
#2 /var/www/html/dreamFactory/web/app/plugins/ns-google-sheets-connector/lib/google-sheets.php(50): Google_Client->refreshToken(NULL)
#3 /var/www/html/dreamFactory/web/app/plugins/ns-google-sheets-connector/ns-google-sheets-connector.php(297): googlesheet->auth()
#4 [internal function]: ns_google_sheets_connector->wpcf7_send_to_sheets(Object(WPCF7_ContactForm))
#5 /var/www/html/dreamFactory/web/wp/wp-includes/plugin.php(525): call_user_func_array(Array, Array)
#6 /var/www/html/dreamFactory/web/app/plugins/contact-form-7/includes/submission.php(163): do_action('wpcf7_mail_sent', Object(WPCF7_ContactForm))
#7 /var/www/html/dreamFactory/web/app/plugins/contact-form-7/includes/submission.php(28): WPCF7_Submission->submit()
#8 /var/www/html/dreamFactory/web/app/plugins/contact-form-7/includes/contact-form.php(614): WPCF7_Submission::get_instance(Object(WPCF7_ContactForm))
#9 /var/www/html/dreamFactory/web/app/plugins/contact-form-7/includes/controller.php(57): WPCF7_ContactForm->submit(true)
#10 /var/www/html/dreamFactory/web/app/plugins/contact-form-7/includes/controller.php(18): wpcf7_ajax_json_echo()
#11 [internal function]: wpcf7_control_init('')
#12 /var/www/html/dreamFactory/web/wp/wp-includes/plugin.php(525): call_user_func_array('wpcf7_control_i...', Array)
#13 /var/www/html/dreamFactory/web/wp/wp-settings.php(413): do_action('wp_loaded')
#14 /var/www/html/dreamFactory/web/wp-config.php(9): require_once('/var/www/html/d...')
#15 /var/www/html/dreamFactory/web/wp/wp-load.php(42): require_once('/var/www/html/d...')
#16 /var/www/html/dreamFactory/web/wp/wp-blog-header.php(12): require_once('/var/www/html/d...')
#17 /var/www/html/dreamFactory/web/index.php(5): require('/var/www/html/d...')
#18 {main}

So, the next
‘refresh_token’ => $refreshToken, – is null

=(

Congig screenshot

The access code expires very quickly, so when you generate it, post it in there really quickly and make sure there aren’t any spaces – it needs to be the raw code.

nope.

I debug plugin and it doesn’t work.

plugin crash in line 76 $worksheetFeed = $spreadsheet->getWorksheets();
file google-sheets.php

Fatal error: Call to a member function getWorksheets() on a non-object in /var/www/html/dreamFactory/web/app/plugins/ns-google-sheets-connector/lib/google-sheets.php on line 76

Does the “Access Code” field say ‘Already Activated’ – or is it blank, after you put your access code in there and hit save?