When you first connect to Google in your Hub, make sure you are logged out of all extra Google accounts. Being logged into multiple Google accounts may result in errors.
You will be asked to grant permissions to your Google account. To use Google Search Console, you must select View search console data for your verified sites .
Be sure to select Allow "Tables" to be modified in reports on the connector configuration page.
If you have selected Site Impression under Tables, you will not be able to select either discover or google news for your Property Parameter.
Google Search Console collects live data only. Backfilling and data warehousing are not available for this connector, and Google's API provides only the most recent 16 months of historical data. We recommend the following alternative solutions for ongoing collection of historical data beyond the most recent 16 months.
Export to BigQuery or MySQL
Our Enterprise plan offers the ability to export data to BigQuery and MySQL. Follow the instructions in How to Export to BigQuery or How to Export to MySQL to set up an initial backfill of your historic Google Search Console data, followed by a regularly scheduled rolling update with the latest data. This scheduled export will append the newest data to the historic data on an ongoing basis, allowing you to collect data beyond 16 months. Use the Spreadsheets Add-on
With our Spreadsheets add-on, you can use Google Sheets as a destination for your Google Search Console data. To store historic data as well as the latest data, create a new Google Sheets spreadsheet and enable the Power My Analytics Spreadsheets add-on. In the first sheet of the spreadsheet (Sheet1), create a report with a date range of the last 16 months:
Make sure to give this report a distinct name like "Historic data".
Next, create a new sheet (Sheet2) in the spreadsheet. Create a new report and set the date range to Custom start to date. Set the start date to today's date.
Make sure to give your report a distinct name like "Current data".
After creating your reports, go to the Sheets sidebar and delete the "Historic data" report. The first sheet of your spreadsheet will still contain the data, but it will no longer be updated. This is necessary to avoid data loss, as scheduling a refresh in the Sheets sidebar will cause all reports to refresh, and refreshing the "Historic data" report would cause the loss of any data older than 16 months.
Next, click on the alarm clock icon to create a scheduled refresh of your current data.
You can select a monthly, weekly, or daily refresh (hourly refresh is only available to Enterprise users).
Select a refresh time, then click Save.