AppFollow Add-On for Google Sheets v2.0AppFollow Add-On Functions:
1. getSuggest(term, country, device)
Find suggestions for App Store and Google Play.
=getSuggest("mario", "US", "android")
2. getSearch(term, country, device)
Search result positions for App Store and Google Play.
=getSearch("supermario", "GB", "ipad")
3. getTrending(country, device)
Trending searches for App Store.
=getTrending("RU")
4. getSearchAds(app_title, country, phrase)
Get keywords and quality score for the app from Search Ads.
=getSearchAds("telegram", "US")
5. getKeywords(ext_id, country, device, date)
Get keyword positions for the app.
=getKeywords(
"com.nintendo.zara", "US", "android")
6. getKeywordsCompare(ext_id, old_date, new_date, country, device)
Compare keyword positions for the app.
=getKeywordsCompare(
"com.nintendo.zara", "2017-04-21", "2017-04-30", "US", "android")
7. saveKeywords(country, device, keywords, apps_id)
Save keywords in the app collection @ AppFollow.
=saveKeywords("RU", "iphone", "keywords, separated by a, comma")
8. getReviews(ext_id, page, date)
Get reviews for the app.
=getReviews(
"com.nintendo.zara")
9. getReviewsSummary(ext_id, date)
Get summary reviews for the app.
=getReviewsSummary(
"com.nintendo.zara", "2015-07-24")
10. getRatings(ext_id, date)
Get ratings history for the app.
=getRatings("com.nintendo.zara")
11. getRatingsSummary(ext_id, date)
Get summary ratings for the app.
=getRatingsSummary(
"com.nintendo.zara", "2017-04-24")
12. getRankings(ext_id, page, date)
Get rankings history for the app.
=getRankings(
"com.nintendo.zara", "1", "2017-04-24")