Google Data Studio – connecting with Price2Spy API
24210
page-template,page-template-full_width,page-template-full_width-php,page,page-id-24210,strata-core-1.0.4,strata-child-theme-ver-1.0.0,strata-theme-ver-3.0.6,ajax_fade,page_not_loaded,wpb-js-composer js-comp-ver-5.7,vc_responsive

Google Data Studio – connecting with Price2Spy API

Google Data Studio is a popular reporting solution that enables users to make custom reports with data from Google’s marketing services and external sources.

 

One of such external source can be competitor pricing data – originating from your Price2Spy account.

 

Since more and more Price2Spy clients want to connect their Google Data Studio via Price2Spy API, we decided to share this in-depth guide with you.

 

This guide is divided into 3 segments:

 

1. Connecting Data Studio to Price2Spy API

2. Performing GET operations from Price2Spy API

3. Performing POST operations from Price2Spy API

 

How do you know if the operation should be executed by a POST or GET method?

 

Please see the full list of Price2Spy API operations here: https://api.price2spy.com/rest/swagger-ui.html#/rest-api

 

For each operation, you will see:

  • Blue box named GET – if it’s a GET operation
  • Green box named POST – if it’s a POST operation

1. Connecting Data Studio to Price2Spy API

 

To connect your Power BI with Price2Spy API using any methods, first, you need to follow these steps (click on the image to get it enlarged):

 

1. Open the link to Price2Spy connector and then, click Authorise (see screenshot 1)

 

 

Screenshot 1

2.  Please login to your Google account (see screenshot 2)

 

Screenshot 2

3. Until Price2Spy connecter get verified by Google, you will see the following ‘ This app isn’t verified’ (see screenshot 3)

 

Screenshot 3

4. Then, please click on Advanced => Go to Price2Spy REST API (unsafe) (see screenshot 4)

 

Screenshot 4

5. Click on Allow (see screenshot 5)

 

Screenshot 5

6. Insert your API key and then, click Submit (see screenshot 6)

 

If you do not know your API KEY, please contact us at support@price2spy.com

 

Screenshot 6

2. Connecting Data Studio to Price2Spy API – GET methods

In this example we will cover a simple getBrands() operation, which will, as you may guess, retrieve a list of Brands from your Price2Spy account:

 

1. Please select GET requests from the dropdown menu (see screenshot 7)

 

2. Click Next

 

Screenshot 7

3. Then, please select the request you want (in our example that would be Get brands (see screenshot 8)

 

4. Click Connect

 

 

 

Screenshot 8

5. Once it’s done, you will see a list of all fields that your request returns. After checking if everything is OK, click on Create report (see screenshot 9)

 

 

 

Screenshot 9

6. Then, a popup will appear asking you if you want to add data to the report. Here you can click Add to report and choose if you want to see this popup again or not (see screenshot 10)

Screenshot 10

7. Finally, you will be able to see your data in the report (see screenshot 11)

Screenshot 11

3. Connecting Data Studio to Price2Spy API – POST methods

In this example, we will cover a bit more complex getCurrentPricingData() operation. This operation has many optional input parameters, and in this example, we will cover date_change_from and brand_name:

 

1. Please select POST requests from the dropdown menu (see screenshot 12)

 

2. Click Next

Screenshot 12

3. Please select the request you want (in our example that would be Get current pricing data (see screenshot 13)

 

4. Click Next

Screenshot 13

5. On this screen, you should fill in your request parameters. None of the input parameters is mandatory – however, sending such a blank request will result in a potentially very big response, which is not advisable. Therefore, please think carefully how to segment the data from your Price2Spy account (for example, by Category, by Brand, etc.)

Here we will fill in 2 parameters:

  • Date Change From – so only the products with prices which have changed after date X will be returned
  • Brand name – we focus on a particular Brand

 

6. Click Connect (or Reconnect)

Screenshot 14

7. If you previously used another request, you will be asked to apply the changes in configuration (see screenshot 15)

Screenshot 15

8. Once you’re done, you will see a list of all fields that your request returns. After checking if everything is OK, click on Create report (see screenshot 15)

Screenshot 16

9. Then, a popup will appear asking you if you want to add data to the report. Here you can click Add to report and choose if you want to see this popup again or not (see screenshot 16)

Screenshot 17

10. Finally, you will be able to see your data in the report (see screenshot 18)

Screenshot 18

For any questions you might have, please feel free to contact us at support@price2spy.com – we would be happy to help you.

 

In case you are new to Price2Spy, you are welcome to start your free 30-day trial to establish a Data Studio connection via Price2Spy API, (using any kind of API method you need).