Workflows · From Tasks · from_google_search_console

Purpose

Imports data from Google Search Console.

Method of use

Before you can download data from Google Search Console you have to give acces. There are two ways to do this:

Acces with Service Account

Take the steps below to download data with a service account.

  1. Create a service account or re-use a service account of a Google Cloud environment.
  2. Have the service account added to the Workflows connections by a Onesecondbefore staff member
  3. If you use Google Cloud, you're done. If you use another cloud, add the connection string to conn_id
  4. Give the client_email from the Service Account `Read` access to the Google Search Console
  5. You should now be able to download the contents of the first sheet of the Google Search Console

Access with Delegated Account

Take the steps below to download data with a delegated account. Please take note of the security precautions needed to secure this connection method.

  1. Take the steps 1 till 3 in the Service Account flow.
  2. Enable domain-wide delegation for the service account.
  3. Give the delegated account `Read` access to Google Search Console
  4. You should now be able to download the contents from the Google Search Console

Configuration

Example usage

extract:
    site: https://www.onesecondbefore.com
    dimensions:
        - date
        - country
        - device
        - page
        - query
    aggregationType: byPage

Properties

propertytyperequireddescription
conn_idstringnoConnection string as handed to you by the Onesecondbefore team. Default is `google_cloud_default`
dimensionsarray with enumerator (date, country, device, page, query, searchAppearance)yesContains the dimensions of the report
sitestringyesContains the site, like https://www.onesecondbefore.com
aggregationTypeenumerator (byProperty, byPage)noDefault is byProperty. Contains aggregation type.

Details

itemdescription
APIGoogle Search Console API
Pre-formatted schemaYes. Comes with a pre-formatted and described schema.