Google Data Studio – connecting with Price2Spy API

[vc_row row_type=”row” type=”grid” anchor=”products” text_align=”left” border_color=”#eaeaea” padding_top=”51″ padding_bottom=”0″ css_animation=””][vc_column][vc_row_inner row_type=”row” type=”grid” text_align=”left” css_animation=””][vc_column_inner]

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

[vc_empty_space][/vc_column_inner][/vc_row_inner][vc_row_inner row_type=”row” type=”grid” text_align=”left” css_animation=””][vc_column_inner width=”4/6″]

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) or check out the video tutorial:

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

[/vc_column_inner][vc_column_inner width=”2/6″][vc_column_text]Screenshot 1[/vc_column_text][vc_single_image image=”25301″ img_size=”full” add_caption=”yes” alignment=”center” onclick=”img_link_large” qode_css_animation=””][/vc_column_inner][/vc_row_inner][vc_empty_space][vc_row_inner row_type=”row” type=”grid” text_align=”left” css_animation=””][vc_column_inner width=”4/6″]

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

[/vc_column_inner][vc_column_inner width=”2/6″][vc_column_text]Screenshot 2[/vc_column_text][vc_single_image image=”24220″ img_size=”full” alignment=”center” onclick=”img_link_large” qode_css_animation=””][/vc_column_inner][/vc_row_inner][vc_row_inner row_type=”row” type=”grid” text_align=”left” css_animation=””][vc_column_inner width=”4/6″]

3. Click on Allow (see screenshot 3)

[/vc_column_inner][vc_column_inner width=”2/6″][vc_column_text]Screenshot 3[/vc_column_text][vc_single_image image=”24247″ img_size=”full” alignment=”center” onclick=”img_link_large” qode_css_animation=””][/vc_column_inner][/vc_row_inner][vc_row_inner row_type=”row” type=”grid” text_align=”left” css_animation=””][vc_column_inner width=”4/6″]

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

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

[/vc_column_inner][vc_column_inner width=”2/6″][vc_column_text]Screenshot 4[/vc_column_text][vc_single_image image=”24259″ img_size=”full” alignment=”center” onclick=”img_link_large” qode_css_animation=””][/vc_column_inner][/vc_row_inner][vc_empty_space][vc_row_inner row_type=”row” type=”grid” text_align=”left” css_animation=””][vc_column_inner width=”4/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 5)

2. Click Next

[vc_empty_space height=”64px”][/vc_column_inner][vc_column_inner width=”2/6″][vc_column_text]Screenshot 5[/vc_column_text][vc_single_image image=”24542″ img_size=”full” alignment=”center” onclick=”img_link_large” qode_css_animation=””][/vc_column_inner][/vc_row_inner][vc_row_inner row_type=”row” type=”grid” text_align=”left” css_animation=””][vc_column_inner width=”4/6″]

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

4. Click Connect

[vc_empty_space height=”64px”][/vc_column_inner][vc_column_inner width=”2/6″][vc_column_text]Screenshot 6[/vc_column_text][vc_single_image image=”24285″ img_size=”full” alignment=”center” onclick=”img_link_large” qode_css_animation=””][/vc_column_inner][/vc_row_inner][vc_row_inner row_type=”row” type=”grid” text_align=”left” css_animation=””][vc_column_inner width=”4/6″]

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 7)

[/vc_column_inner][vc_column_inner width=”2/6″][vc_column_text]Screenshot 7[/vc_column_text][vc_single_image image=”24294″ img_size=”full” alignment=”center” onclick=”img_link_large” qode_css_animation=””][vc_empty_space][/vc_column_inner][/vc_row_inner][vc_empty_space height=”64px”][vc_row_inner row_type=”row” type=”grid” text_align=”left” css_animation=””][vc_column_inner width=”4/6″]

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 8)

[vc_empty_space height=”64px”][/vc_column_inner][vc_column_inner width=”2/6″][vc_column_text]Screenshot 8[/vc_column_text][vc_single_image image=”24303″ img_size=”full” alignment=”center” onclick=”img_link_large” qode_css_animation=””][vc_empty_space][/vc_column_inner][/vc_row_inner][vc_row_inner row_type=”row” type=”grid” text_align=”left” css_animation=””][vc_column_inner width=”4/6″]

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

[vc_empty_space height=”64px”][/vc_column_inner][vc_column_inner width=”2/6″][vc_column_text]Screenshot 9[/vc_column_text][vc_single_image image=”24312″ img_size=”full” alignment=”center” onclick=”img_link_large” qode_css_animation=””][vc_empty_space][/vc_column_inner][/vc_row_inner][vc_row_inner row_type=”row” type=”grid” text_align=”left” css_animation=””][vc_column_inner width=”4/6″]

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 10)

2. Click Next

[vc_empty_space height=”64px”][/vc_column_inner][vc_column_inner width=”2/6″][vc_column_text]Screenshot 10[/vc_column_text][vc_single_image image=”24552″ img_size=”full” alignment=”center” onclick=”img_link_large” qode_css_animation=””][vc_empty_space][/vc_column_inner][/vc_row_inner][vc_row_inner row_type=”row” type=”grid” text_align=”left” css_animation=””][vc_column_inner width=”4/6″]

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

4. Click Next

[vc_empty_space height=”64px”][/vc_column_inner][vc_column_inner width=”2/6″][vc_column_text]Screenshot 11[/vc_column_text][vc_single_image image=”24561″ img_size=”full” alignment=”center” onclick=”img_link_large” qode_css_animation=””][vc_empty_space][/vc_column_inner][/vc_row_inner][vc_row_inner row_type=”row” type=”grid” text_align=”left” css_animation=””][vc_column_inner width=”4/6″]

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)

[vc_empty_space height=”64px”][/vc_column_inner][vc_column_inner width=”2/6″][vc_column_text]Screenshot 12[/vc_column_text][vc_single_image image=”24570″ img_size=”full” alignment=”center” onclick=”img_link_large” qode_css_animation=””][vc_empty_space][/vc_column_inner][/vc_row_inner][vc_row_inner row_type=”row” type=”grid” text_align=”left” css_animation=””][vc_column_inner width=”4/6″]

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

[vc_empty_space height=”64px”][/vc_column_inner][vc_column_inner width=”2/6″][vc_column_text]Screenshot 13[/vc_column_text][vc_single_image image=”24349″ img_size=”full” alignment=”center” onclick=”img_link_large” qode_css_animation=””][vc_empty_space][/vc_column_inner][/vc_row_inner][vc_row_inner row_type=”row” type=”grid” text_align=”left” css_animation=””][vc_column_inner width=”4/6″]

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 14)

[vc_empty_space height=”64px”][/vc_column_inner][vc_column_inner width=”2/6″][vc_column_text]Screenshot 14[/vc_column_text][vc_single_image image=”24358″ img_size=”full” alignment=”center” onclick=”img_link_large” qode_css_animation=””][vc_empty_space][/vc_column_inner][/vc_row_inner][vc_row_inner row_type=”row” type=”grid” text_align=”left” css_animation=””][vc_column_inner width=”4/6″]

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 15)

[vc_empty_space height=”64px”][/vc_column_inner][vc_column_inner width=”2/6″][vc_column_text]Screenshot 15[/vc_column_text][vc_single_image image=”24367″ img_size=”full” alignment=”center” onclick=”img_link_large” qode_css_animation=””][vc_empty_space][/vc_column_inner][/vc_row_inner][vc_row_inner row_type=”row” type=”grid” text_align=”left” css_animation=””][vc_column_inner width=”4/6″]

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

[vc_empty_space height=”96px”][/vc_column_inner][vc_column_inner width=”2/6″][vc_column_text]Screenshot 16[/vc_column_text][vc_single_image image=”24385″ img_size=”full” alignment=”center” onclick=”img_link_large” qode_css_animation=””][vc_empty_space][/vc_column_inner][/vc_row_inner][vc_row_inner row_type=”row” type=”grid” text_align=”left” css_animation=””][vc_column_inner]

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 trial to establish a Data Studio connection via Price2Spy API, (using any kind of API method you need).

[vc_empty_space][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row]