Connect your Google Search Console to Spreadsheets
Effortlessly connect your Google Search Console account to Google Sheets or Microsoft Excel for simplified reporting and analysis.
Why use Superjoin’s Google Sheets-Google Search Console Integration?
Quick and Easy Integration
We’ve meticulously organized the data points to ensure easy accessibility in a format you’re already familiar with.
Preview your imports visually
Get a sneak peek of your data. Select columns, apply filters & limits as per your need before importing.
Automatic Refreshes
Enjoy one-click refreshes or schedule regular updates to ensure your sheets are always up to date.
Power of Google Sheets
Benefit from Google Sheets’ collaborative data analysis & other powerful capabilities.
Step-by-step walkthrough: How to connect Google Search Console to Google Sheets
Get Add-ons
Head over to Extensions
, select Add-ons
and choose Get Add-ons
. This action will redirect you to the Google Workspace Marketplace.
Search Superjoin
In the Google Workspace Marketplace pop-up window, search for “Superjoin”.
Click on Install
Click on the Install
button to install Superjoin.
Launch Superjoin
Once installed, navigate back to the Extensions
menu tab in Google Sheets. Launch Superjoin from here. You should now see Superjoin running as a side panel on the right side of your screen.
Navigate to Queries
To begin, you can navigate to Queries
, choose to Create new query
.
Connect a New Source
Navigate to Sources
, select Connect to a new source
and search for Google Search Console
.
Link Account
Click on the Connect
button and follow the on-screen instructions to link your account.
Preview Data
After connecting your account, a data preview window will appear, allowing you to modify your metrics and apply various filters to refine your data.
Import Data
After previewing the data, click on Import
and wait for a few seconds. This action transfers all data from your Google Search Console account into Google Sheets.
Setup Auto-Refresh
You can schedule a Refresh
to automatically update your data daily, weekly, or monthly at a specific time.
Why use Superjoin’s Google Sheets-Google Search Console Integration?
Quick and Easy Integration
We’ve meticulously organized the data points to ensure easy accessibility in a format you’re already familiar with.
Preview your imports visually
Get a sneak peek of your data. Select columns, apply filters & limits as per your need before importing.
Automatic Refreshes
Enjoy one-click refreshes or schedule regular updates to ensure your sheets are always up to date.
Power of Google Sheets
Benefit from Google Sheets’ collaborative data analysis & other powerful capabilities.
Step-by-step walkthrough: How to connect Google Search Console to Google Sheets
Get Add-ons
Head over to Extensions
, select Add-ons
and choose Get Add-ons
. This action will redirect you to the Google Workspace Marketplace.
Search Superjoin
In the Google Workspace Marketplace pop-up window, search for “Superjoin”.
Click on Install
Click on the Install
button to install Superjoin.
Launch Superjoin
Once installed, navigate back to the Extensions
menu tab in Google Sheets. Launch Superjoin from here. You should now see Superjoin running as a side panel on the right side of your screen.
Navigate to Queries
To begin, you can navigate to Queries
, choose to Create new query
.
Connect a New Source
Navigate to Sources
, select Connect to a new source
and search for Google Search Console
.
Link Account
Click on the Connect
button and follow the on-screen instructions to link your account.
Preview Data
After connecting your account, a data preview window will appear, allowing you to modify your metrics and apply various filters to refine your data.
Import Data
After previewing the data, click on Import
and wait for a few seconds. This action transfers all data from your Google Search Console account into Google Sheets.
Setup Auto-Refresh
You can schedule a Refresh
to automatically update your data daily, weekly, or monthly at a specific time.
Why use Superjoin’s Excel-Google Search Console Integration?
Quick and Easy Integration
We’ve meticulously organized the data points to ensure easy accessibility in a format you’re already familiar with.
Preview your imports visually
Get a sneak peek of your data. Select columns, apply filters & limits as per your need before importing.
One-Click Refreshes
Enjoy one-click refreshes to ensure your sheets are always up to date.
Power of Microsoft Excel
Benefit from Microsoft Excel’s powerful data analysis & visualization capabilities.
Step-by-step walkthrough: How to connect Google Search Console to Microsoft Excel
Launch Add-ins
Click on Add-ins
on the right side of the Excel toolbar.
Get Add-in
Click on the searchbar and type “Superjoin”. The results would show our add-in under the More search results
section.
Authenticate with your Microsoft Account
Once Superjoin launches as a side panel, just click on Sign in with Microsoft
and follow the steps to authenticate your Microsoft Office account with Superjoin.
Launch Superjoin
You should now see Superjoin running as a side panel on the right side of your screen.
Navigate to Queries
To begin, you can navigate to Queries
, choose to Create new query
.
Connect a New Source
Navigate to Sources
, select Connect to a new source
and search for Google Search Console
.
Link Account
Click on the Connect
button and follow the on-screen instructions to link your Google Search Console account.
Configure Data Selection
After connecting your account, a data preview window will appear, allowing you to select your metrics and dimensions, apply date ranges, and set various filters to refine your Search Console data.
Import Data
Once you’ve configured your data selection, click the “Import” button to bring your Google Search Console data into Microsoft Excel.
Refresh Data
Your data has been imported successfully! You can refresh your data at any time by clicking the refresh button in the Superjoin panel.
Hope this guide helped you connect Google Search Console to your spreadsheet using Superjoin.
If you have any questions or need further assistance, please don’t hesitate to reach out to our support team support@superjoin.ai. Thank you!
Was this page helpful?