Yes, to be able to import Keyword statistics in Piwik from Google Search Console, a connection to a Google account is required. This account needs to have access to the Search Console data for the website you would like to query the data for.
If you don’t have set up Search Console yet, go to Google Webmaster Tools. Add your website as new property and follow the instructions to verify you are the site owner. That’s all. Now Piwik should be able to import the keywords if you grant access to your account in Piwik > Administration > Search Performance. Learn more in our user guide.