Open navigation

Vkontakte Public Data: Connection guide

This guide gives instructions on how to connect Vkontakte Public Data with Google Sheets, Data Studio, and Microsoft Excel, as well as data warehouse destinations like Google Cloud Storage, BigQuery, and the Supermetrics API.

Before you begin

The Supermetrics Vkontakte Public Data data source doesn't need you to log in to a specific account. Therefore, no access requirements are needed for this data source.

Data protection agreement 

If you have any questions about how Supermetrics handles and secures your data, read our policy on data privacy and security.

Query types

  • Vkontakte posts - returns metadata on the public post that matches the search keyword given, as well as counts of basic things like the number of comments, likes, etc.
  • Vkontakte user data - returns public username and metadata about users like number of friends, number of videos, number of photos from their account.


Google Sheets Data Studio  Excel Data Integrations
Before you can authenticate the data source in Google Sheets, you need to install the Supermetrics add-on.
  1. Open a new Google Sheets file. 
  2. Click Add-ons → Supermetrics → Launch to open the sidebar.
  3. Under Data source, select the data source.
  4. Navigate to Report configuration.
  5. Under Query type, select the query type
  6. Insert Keywords or User IDs. 
  7. Depending on the query type you choose, there will be additional options (Number of posts, Translate to).

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.