Yes, to be able to import Keyword statistics in Matomo (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 Matomo should be able to import the keywords if you grant access to your account in Matomo > Administration > Search Performance. Learn more in our user guide.