Connectors

/

Google Search Console

Data replication

Sync Google Search Console data anywhere.

Google Search Console is a Google service that helps site owners get the most out of their website. It offers ways for site owners to monitor, troubleshoot, and improve a site’s position on Google Search. It also provides reports and tools for measuring a site’s Search performance and traffic; learning what search queries lead to a site; optimizing website content; monitoring, testing, and tracking AMP pages; and much more, including the ability to test a site’s mobile usability.

  • Certified
  • Generally available
  • 15 streams
  • 8 entities
Sync Google Search Console dataRead the docs
Google Search Console

One connector

Everything Google Search Console can do in Airbyte

  • Sync to your warehouse

    Land 15 Google Search Console tables in 50+ destinations on a schedule you control.

  • Context store search

    Query synced Google Search Console data with filters, sorting and semantic search, without spending Google Search Console API rate limits.

  • Incremental syncs

    Pull only the records that changed since the last run instead of reloading everything.

  • One authorization

    Authenticate Google Search Console once. The same connection powers scheduled syncs and runtime actions.

Specifications

What to know before you sync Google Search Console

  • Support levelCertified
  • Available onCloud, Self-Managed Enterprise
  • Connector version2.1.9
  • Release stageGenerally available

Sync capabilities

  • Full Refresh SyncSupported
  • Incremental SyncSupported
  • Destinations50+ Airbyte connectors

Set up in 15 steps

  1. Go to the Google Search Console website and log in to your account.
  2. Click on the gear icon in the top right corner and select "Settings".
  3. Click on "Users and permissions" in the left-hand menu.
  4. Click on the blue "Add user" button.
  5. Enter the email address associated with your Airbyte account and select "Full" as the permission level.
  6. Click "Add" to save the user.
  7. Go to the Airbyte dashboard and click on "Sources" in the left-hand menu.
  8. Click on the "New Source" button in the top right corner.
  9. Select "Google Search Console" from the list of available sources.
  10. Enter a name for the source and click "Next".
  11. Enter the email address associated with your Google Search Console account and click "Next".
  12. Enter the password for your Google Search Console account and click "Next".
  13. Select the website or app you want to connect to Airbyte and click "Next".
  14. Review the settings and click "Create" to save the source.
  15. Wait for Airbyte to sync your data from Google Search Console.

15 streams

Every table you can sync from Google Search Console

  • Sites

  • Sitemaps

  • Full Analytics report

  • Analytics report by country

  • Analytics report by date

  • Analytics report by device

  • Analytics report by page

  • Analytics report by query

  • Analytics keyword report

  • Analytics keyword report by page

  • Analytics keyword report by site

  • Analytics page report

  • Analytics site report by page

  • Analytics site report by site

  • Analytics report by custom dimensions

3 actions

Supported Google Search Console actions

  • List

    Read live records straight from the Google Search Console API.

  • Get

    Fetch a single record by ID.

  • Context Store Search

    Query synced data with filters and sorting, with no API rate limits.

Full parameter-level details live in the Google Search Console entity reference.

Authentication

Authenticate Google Search Console once

    • Recommended

    OAuth

  • Service Account Key Authentication

Use cases

What teams build with Google Search Console

List all my verified sites in Search Console

Show me the sitemaps for my website

Get search analytics by date for the last 7 days

Show search performance broken down by country

What devices are people using to find my site?

Which pages get the most clicks?

What queries bring the most traffic to my site?

Which country has the highest CTR for my site?

What are my top 10 search queries by impressions?

Compare mobile vs desktop click-through rates

Which pages have the worst average position?

Show me search performance trends over the last month

Explore

Related connectors

GridlyMarketing AnalyticsStandard Sources cloudself-managed-enterprise
HubSpotMarketing AnalyticsCertified Sources cloudself-managed-enterprise
InstagramMarketing AnalyticsCertified Sources cloudself-managed-enterprise
IterableMarketing AnalyticsStandard Sources cloudself-managed-enterprise
KlaviyoMarketing AnalyticsCertified Sources cloudself-managed-enterprise
LemlistMarketing AnalyticsStandard Sources cloudself-managed-enterprise
All connectors

Common questions

Didn't find your answer?
Please don't hesitate to reach out.

Talk to sales

No. One Google Search Console authorization powers both the scheduled syncs that land data in your destination and the entity actions your agents call at runtime.

No. Entity actions read and write through the Google Search Console API as they are called, so they work immediately. Context store search is the exception: it queries data Airbyte has already synced, which is what lets it filter and sort without spending API rate limits.

ETL, an acronym for Extract, Transform, Load, is a vital data integration process. It involves extracting data from diverse sources, transforming it into a usable format, and loading it into a database, data warehouse or data lake. This process enables meaningful data analysis, enhancing business intelligence.

Google Search Console's API provides access to a wide range of data related to a website's performance in Google search results. The following are the categories of data that can be accessed through the API:

1. Search Analytics: This category includes data related to search queries, impressions, clicks, and click-through rates.

2. Sitemaps: This category includes data related to the sitemap of a website, such as the number of URLs submitted, indexed, and any errors encountered.

3. Crawl Errors: This category includes data related to any crawl errors encountered by Google while crawling a website, such as 404 errors, server errors, and soft 404 errors.

4. Security Issues: This category includes data related to any security issues detected by Google, such as malware or phishing.

5. Indexing: This category includes data related to the indexing status of a website, such as the number of pages indexed and any indexing errors encountered.

6. Structured Data: This category includes data related to the structured data markup on a website, such as the number of pages with structured data and any errors encountered.

7. Mobile Usability: This category includes data related to the mobile usability of a website, such as the number of pages with mobile usability issues and any errors encountered.

1. Go to the Google Search Console website and log in to your account.

2. Click on the gear icon in the top right corner and select "Settings".

3. Click on "Users and permissions" in the left-hand menu.

4. Click on the blue "Add user" button.

5. Enter the email address associated with your Airbyte account and select "Full" as the permission level.

6. Click "Add" to save the user.

7. Go to the Airbyte dashboard and click on "Sources" in the left-hand menu.

8. Click on the "New Source" button in the top right corner.

9. Select "Google Search Console" from the list of available sources.

10. Enter a name for the source and click "Next".

11. Enter the email address associated with your Google Search Console account and click "Next".

12. Enter the password for your Google Search Console account and click "Next".

13. Select the website or app you want to connect to Airbyte and click "Next".

14. Review the settings and click "Create" to save the source.

15. Wait for Airbyte to sync your data from Google Search Console.

The most prominent ETL tools to transfer data to include: Airbyte, Fivetran, StitchData, Matillion, Talend Data Integration. These tools help in extracting data from various sources (APIs, databases, and more), transforming it efficiently, and loading it into and other databases, data warehouses and data lakes, enhancing data management capabilities.

ELT, standing for Extract, Load, Transform, is a modern take on the traditional ETL data integration process. In ELT, data is first extracted from various sources, loaded directly into a data warehouse, and then transformed. This approach enhances data processing speed, analytical flexibility and autonomy.

ETL and ELT are critical data integration strategies with key differences. ETL (Extract, Transform, Load) transforms data before loading, ideal for structured data. In contrast, ELT (Extract, Load, Transform) loads data before transformation, perfect for processing large, diverse data sets in modern data warehouses. ELT is becoming the new standard as it offers a lot more flexibility and autonomy to data analysts.

Start moving Google Search Console data today

Free for 14 days on Airbyte Cloud. One connection powers your scheduled syncs and your live Google Search Console actions.

Try it freeTalk to sales