✔️ Automatically retrieve search analytics from Google Search Console™

 ✔️ No downloads required – work entirely within Google Sheets™

 ✔️ Retrieve, analyze, and back up search analytics data with ease

 ✔️ Powerful reporting, URL inspection, and visualization features

 ✔️ Flexible output: active sheet, new sheet, or existing sheet

🎯 How GSC in Sheets™ is useful

 GSC in Sheets™ simplifies and supercharges your SEO reporting and website performance tracking—all within Google Sheets™.

If you need daily, weekly, and monthly reports with performance insights without the hassle of exporting, importing, and manual formatting, this tool saves you tons of time and streamlines your schedule.

➤ Analyze Website Traffic Trends – Compare time-series data (daily, weekly, monthly) to spot growth patterns and seasonal trends.

➤ Monitor Keyword Performance – Instantly pull data on queries, pages, clicks, impressions, CTR, and average positions.

➤ Perform Technical SEO Audits – Use URL inspection integration to pinpoint crawling, indexing, and canonicalization issues.

➤ Data Backups – Preserve historical search analytics beyond Google’s 16-month retention limits.

 ➤ Generate Dynamic Reports – Create visually appealing heatmaps and customizable reports for in-depth analysis.

 ➤ Streamline Data Management – Enjoy flexible output options with intelligent formatting and automated sheet management.

🔑 KEY FEATURES

1️⃣ Google Search Console™ Data Retrieval

 🔗 Integrates directly with the Google Search Console™ API using secure OAuth2 authentication.

 🌍 Access search analytics from all verified properties (sites and domain properties).

Search Type Support:

 🌐 Web Search

 🖼️ Image Search

 🎥 Video Search

 📰 News

🔎Discover

 🗞️ Google News™

Advanced Dimension Grouping & Filtering:

 🔎 Query – Understand which keywords are driving traffic.

 📄 Page – Analyze the performance of specific landing pages.

 🌍 Country – Identify regional trends and opportunities.

 📱 Device – Compare mobile, desktop, and tablet performance.

 📅 Date – Track performance changes over time.

 ⭐ Search Appearance – Evaluate the impact of rich results and structured data.

Advanced Filtering Operations:

 ✅ Contains /  ❌ Does not contain

 ✅ Equals /  ❌ Does not equal

 📝 Matches regex / 🚫 Doesn’t match regex

2️⃣ Reporting Capabilities & Visualization

📈 Dynamic Time-Series Reports – Compare key metrics across different time periods (daily, weekly, monthly) with support for ISO week (e.g., 2025-W10) and month-year labels (e.g., Jan 2025).

 🔥 Heatmap Visualization – Automatically apply conditional formatting to highlight performance trends; green indicates improvements while red flags declines.

 📝 Flexible Output Options – Choose where to display your data: active sheet, new sheet (customizable names), or existing sheet (with options to clear data first). Auto-resize columns and format CTR as percentages and positions to two decimal places.

3️⃣ URL Inspection Integration

🔍 Batch URL Inspection – Quickly check indexing status, crawl details, and canonical tag setups across multiple URLs.

 Retrieve comprehensive details including:

 ✅ Indexed Status & Coverage State

 📅 Last Crawled Date

 🔄 Google vs. User Canonical

 🚫 Indexing, Robots.txt, and Fetch Status

 🤖 Crawling User Agent

🛠️ How to get Search Console™ data into Sheets™?

1) Install the GSC in Sheets™ Addon.

2) Open your spreadsheet and go to Extensions > GSC in Sheets™.

3) Grant permission for Search Console™ data linked to your Google™ account and open the side panel.

4) Select which website’s data you want.

5) Choose a predefined date range (last 7, 28, 30, 90, or 365 days, last month, or all time covering 16 months).

6) Select the search type (Web, Image, Video, News, Discover, or Google News™).

7) Decide if you want plain data or enable reporting mode for day-over-day, week-over-week, or month-over-month analysis.

8) Enable the heatmap option if you want color coding (light green for improvements, light red for declines).

9) Use the group-by option to organize dimensions (like query, page, etc.) for detailed data.

10) Select the row limit for your data.

11) Enable URL inspection integration if you want technical SEO insights (indexing status, last crawl date, canonical details, etc.).

12) Apply filters by page, query, country, device, or search appearance using operators like Contains, Equals, Does not contain, Does not equal, Matches regex, or Doesn’t match regex.

13) Choose your output location – active sheet, new sheet (you can name it), or existing sheet (with an option to clear data).

14) Hit “Get Data” to instantly receive your GSC data with all your requirements.