Getting data from Google Search Console?

[Anonymous]

Greetings,

is there a way to get data from Google Search Console without using any programming language. Let's say I have 0 programming experience, hence using an API is not an option, what would you recommned in my case? 

Is there any google service which converts metrics and dimensions needed into a code?

[Mike3Sullivan]

New option available for this: from Analytics Edge, there is a free Exporter GSC product that can automate the download from the GSC API to CSV files, which you can import into Power BI. No coding required; no account or row limits, and best of all: free as is beer.

[Djordje_M]

Hi,

For pulling the data from Google Search Console and visualize them into Power BI I use Windsor.ai connector and temples. It is easy to use, but also, for more experienced users, you can edit the fields and add metrics available in Google Search Console.  

It is easy to use and fairly fast.

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

There is no built-in connector for Google Search console in Power BI Desktop, you could post your idea here to improve Power BI.
In addition, you can contact Google Support about how to use Google Search Console API to retrieve data, then use "Get Data->Web" entry in Power BI Desktop or directly add connection information in Advanced Editor to connect to your API. There are some samples for your reference.

API Strategies with Power BI
Get Data from Twitter API with Power Query

[amitchandak]

@Anonymous , The information you have provided is not making the problem clear to me. Can you please explain with an example.
You can explore Q&A  https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-tutorial-q-and-a
Appreciate your Kudos.

[Anonymous]

Hey @amitchandak, 

I found online there is no direct integration for Google Search console nor can the data be extracted from GA. Furthermore, I found there is an API for Google Search Console. Unfortunately, I am unable to use the API due to my lack of knowledge.

Basically I want to extract these measures and dimensions in the simplest way possible (i.e. preferably without using Python, Java or any other programming language)