Summarize this blog post with:
Keeping track of how your website is performing in Google Search can get messy when you’re constantly switching between reports and manually pulling SEO data. Two Minute Reports brings your Google Search Console data into Google Sheets, making it easier to monitor your search performance and share SEO reports with clients.
How to connect Google Search Console to Google Sheets?
You can import your Google Search Console data to Google Sheets via two methods:
Method 1: Connecting Google Search Console to Google Sheets using the Two Minute Reports Hub.
Method 2: Connecting Google Search Console to Google Sheets using the pre-built templates.
Let’s get started with the first method.
Method 1: Connect GA4 to Google Sheets using Two Minute Reports Hub
The Two Minute Reports Hub is your dedicated workspace for managing all your GSC accounts and clients in one place. Here’s how to get started.
Step 1: Creating a Connection
1. Go to hub.twominutereports.com and click Connections → Create Connection.
2. Inside the dialog box, complete these three steps:
- Select the Google Search Console connector from the list of options.
- Next, authorize your connection by entering your login credentials.
- Once authenticated, enable the GSC accounts you want to track performance. Please note that you cannot query disabled accounts.
3. Once done, navigate back to the Hub Homepage and click Google Sheets → New Google Sheets Report.
4. Click Use Template and follow the on-screen instructions to launch the Two Minute Reports add-on in your spreadsheet.
Step 2: Configure and Run Your Query
1. Once you’ve installed the add-on, navigate to Menu → Data Queries and click Add.
2. Select the Google Search Console accounts that you want to include from the sidebar.
3. If you're managing multiple clients, go to Clients → Manage Clients (in the sidebar), map your Google Search Console accounts to the relevant clients, and click Save & Close.
4. Choose the relevant GSC report you want to create – Analytics report, URL inspection report and Sitemaps report. Once done, enter the necessary information needed to create your report. For example, if you select the Analytics report, you can choose metrics such as clicks, impressions, CTR, and position.
5. Click Run Query to pull the data into your chosen sheet and cell.
Next, automate your query. This lets you set up predefined schedules so your clients receive updated website performance insights at set intervals.
You can either click ‘Save & Automate’ or navigate to Menu → Schedule Refresh. Either way, the steps remain the same. For now, let’s click ‘Save & Automate’. Then, follow the steps below:
- First, enter your schedule name.
- Next, select the queries to include in this schedule. You can choose multiple queries if you want them to refresh on the same schedule.
- Then, choose how often you want to refresh: hourly, daily, weekly and monthly.
- Specify the exact time and timezone for the refreshes to occur.
Once you are done with the above steps, you can set up your GSC reports to be delivered via email. Here’s how you can:
- To enable email delivery, move the toggle to ‘Email’.
- Next, select the Sheet to report.
- Enter the email addresses of your recipients – your clients, team members or stakeholders.
- Select whether you need to attach the report as a PDF, Excel/CSV or both.
- Write a customized email subject and body message to include with each report.
And that’s it. Your schedule is now saved. From here on, your clients will receive the latest website performance insights delivered to their inbox automatically.
Method 2: Using Google Search Console Google Sheets Template
With Two Minute Reports’ pre-built GSC templates for Google Sheets, you can create custom reports within minutes. Here’s how you can:
1. In the template gallery, select the Google Search Console Page and Query Analysis template
2. Next, click ‘Get Template for Free’ to open the Google Sheets template.
3. Then, click Use Template. You’ll land on the Google Sheets dashboard.
4. Click Use to launch the Two Minute Reports sidebar in your spreadsheet.
5. Finish importing your template by selecting the required Google Search Console accounts from the dropdown. Once done, click Submit to create your report.
6. Click Run Query to fill this template with the necessary data.
7. And that’s it. Your GSC data is populated across relevant sections, helping you give a detailed overview of what’s happening on your website and what needs to be improved.
Click the template link below to get started.
Why Import Google Search Console data to Google Sheets?
Importing Google Search Console data into Google Sheets gives you more flexibility to analyze, organize, and report on your SEO performance. Here’s how:
1. Centralize your SEO data
Import your GSC data directly into Google Sheets instead of manually exporting reports. Track your key SEO metrics such as clicks, impressions, CTR, and average position across multiple pages in one place for easier monitoring and reporting.
2. Analyze SEO Performance
Google Sheets gives you the flexibility to analyze your Search Console data using formulas, filters, pivot tables, and charts. Identify trends, compare performance, and customize SEO reporting based on your client’s requirements.
3. Automate GSC Reporting
With Two Minute Reports’ Schedule Refresh, you can automate GSC reporting on custom schedules such as hourly, daily, weekly or monthly. Once you set the schedule, your clients will receive the latest, up-to-date website performance insights in their inbox automatically.
4. Build Customized Reports
Create reports around the metrics and dimensions that matter to your SEO goals. Filter data by queries, pages, devices, countries, search type, and date ranges to build focused reports for your team or clients.
Important metrics used in the Google Search Console Google Sheets Reports
The Google Search Console integration with Google Sheets lets you extract key performance metrics to understand how your campaigns perform and drive engagement. Here are some of the most useful Google Search Console metrics you can track and optimize:
Ready to Connect your Google Search Console to Google Sheets?
Your Google Search Console data can reveal more than how much organic traffic you’re getting. It can show which search queries bring your pages into Google, which pages are gaining visibility, and where your SEO efforts have room to grow. With Two Minute Reports, bring that data into Google Sheets and build flexible reports that make these patterns easier to track and act on.
Try Two Minute Reports free for 14 days and turn your Search Console data into a clearer view of your SEO performance.
Frequently Asked Questions
You can connect Google Search Console to Google Sheets through Two Minute Reports Hub or by installing the TMR add-on from the Google Workspace Marketplace. Once connected, select the Search Console property you want to work with, choose your metrics, configure your query, and pull your SEO data directly into Google Sheets for analysis and reporting.
You can pull key Google Search Console metrics such as clicks, impressions, CTR, and position into Google Sheets. You can also break down your data using dimensions such as date, page, query, country, device, and search type, allowing you to analyze search performance based on your SEO reporting needs.
After connecting your Search Console property and setting up your queries, you can schedule automatic data refreshes. Go to Menu → Schedule Refresh, select the queries you want to run, choose a refresh frequency such as daily, weekly, hourly, or monthly, and save your schedule. Your GSC data will then refresh automatically based on your selected schedule, so you don't have to manually export data from Search Console.
Yes. With Two Minute Reports’ Google Search Console reporting tool, agencies can connect and manage Search Console properties for multiple clients and pull their SEO data into Google Sheets. When creating a query, you can select the relevant property, configure metrics, dimensions, and date ranges, and create custom marketing dashboards or client reports without manually exporting data from each Search Console account.
Yes. You can try Two Minute Reports free for 14 days. During the trial, you can connect Google Search Console to Google Sheets, pull your SEO data, configure queries, and explore how it fits into your SEO reporting workflow.
Meet the Author
Shabika VenkidachalamShabika, at her core, is a storyteller who believes even data-heavy topics can be infused with heart. At Two Minute Reports, she blends creative writing with user intent to create clear, purposeful content that is deeply human. Away from her desk, she finds inspiration in nature, where creativity flourishes without distractions.
