![]() Use built-in IMPORTXML function to get data from Alexa API and parse it. This API responds with an XML which can be parsed to fetch the rank. To fetch rank of, following URL is used : ![]() Use this API to fetch rank by passing appropriate parameters. Steps in development:Īlexa has an API at /data. ![]() Have a look at this post if you need a quick walk through of Google apps script. It is the scripting language of Google sheets. Although It can created using only apps script code, I used both to make my work easier.Īpps script is nothing but JavaScript. I used a combination of Google sheets built-in functions and Google apps script code. Read on if you want to know how is it developed. If you have a website, then you can take a copy of this spreadsheet here – Alexa Rank checker and use it for your website by changing the link in website column. This Alexa rank checker will check blog’s alexa rank daily automatically, compare it with previous day’s rank and mail me if there is an increase in rank along with details like old rank, new rank, change in rank etc. So I just wrote some code and developed an alexa rank checker in Google sheets. I don’t want to open alexa site always and check if rank has been increased. I started this blog last month, I wanted to track this blog’s alexa rank. It works perfectly fine! My Alexa rank has also gone up to 1,63,429 □Īlexa rank of any website can be found here – I still use this same Alexa rank check to date. Update June 2020 : It’s been 4 years since I started this blog and wrote this article. ![]() Right now is the site with rank 1 followed by Youtube and Facebook in second and third places. Alexa rank is considered as one of the key factors in deciding a website’s standard. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |