The first two columns we want to build are the “ Username” column and the “ SocialBlade URL” column. If you would like to learn how to use this formula, I have a full article about how to extract the content of a website in Google Sheets here. This is an extremely convenient formula and the basis of this tutorial. If you are not aware, Google Sheets has a formula called =IMPORTXML that allows the parsing of websites’ contents in order to analyse or display it into a spreadsheet. For the purpose of this tutorial, all of the data is going to be extracted from the Social Media Analytics platform. The first thing we want to understand is our data source. Now, if you want to learn how to do the same spreadsheet yourself, I separated this article into multiple sections that explain how to extract each data point from our website source into the spreadsheet.
The only thing you need to do is add the username of the Twitch channel you are interested in in one empty cell in the A column and the other columns will populate themselves automatically. If you are not interested in learning how to create this spreadsheet on your own, you can also simply make a copy of this spreadsheet by going to this Twitch Tracker Spreadsheet, click on “File” and then “Make a Copy” so you can start using it straight away.
0 kommentar(er)
