Используя Python и API Google Play необходимо скачать информацию о топ-10 приложений из категории Apps -> Phone -> Social networking и выгрузить в сsv

В задании предложено использовать API Google Play, вот только Google, если я правильно понял, не предоставляет возможности выгружать информацию (в задании просят рейтинг, кол-во скачиваний) о сторонних предложениях. Я пытался использовать SerpAPI, например, но каких-то адекватных результатов не дало. Может кто-то подсказать еще варианты, как выполнить задание?

from serpapi import GoogleSearch
import os
import json
from dotenv import load_dotenv

load_dotenv()

params = {
    "api_key": os.getenv("API_KEY"),
    "engine": "google_play",  # Changed from "google_play_product"
    "store": "apps",
    "gl": "ua",
    "hl": "en",
    "category": "SOCIAL",  # Changed from "apps_category"
    "charts": "top_free",
    "num": 10
}

search = GoogleSearch(params)
result = search.get_dict()

# Pretty print the results
print(json.dumps(result, indent=2))

# If you want to extract just the app list:
if 'organic_results' in result:
    print("\nTop Free Social Apps:")
    for i, app in enumerate(result['organic_results'], 1):
        print(f"{i}. {app.get('title', 'N/A')} - {app.get('rating', 'N/A')} stars")
        print(f"   Developer: {app.get('developer', 'N/A')}")
        print(f"   Link: {app.get('link', 'N/A')}")
        print()

Result:

{ "search_metadata": { "id": "686a5711f357f6800a2e0e43", "status": "Success", "json_endpoint": "https://serpapi.com/searches/764e66789e0345f3/686a5711f357f6800a2e0e43.json", "created_at": "2025-07-06 10:59:29 UTC", "processed_at": "2025-07-06 10:59:29 UTC", "google_play_url": "https://play.google.com/store/apps?hl=en&gl=ua", "raw_html_file": "https://serpapi.com/searches/764e66789e0345f3/686a5711f357f6800a2e0e43.html", "total_time_taken": 0.37 }, "search_parameters": { "engine": "google_play", "hl": "en", "gl": "ua", "store": "apps" }, "chart_options": [ { "text": "Top free", "value": "topselling_free" }, { "text": "Top grossing", "value": "topgrossing" }, { "text": "Top paid", "value": "topselling_paid" } ], "items_highlight": [ [ { "title": "TikTok", "subtitle": "Follow Dimitri Vegas on TikTok", "link": "https://play.google.com/store/apps/details?id=com.zhiliaoapp.musically", "product_id": "com.zhiliaoapp.musically", "serpapi_link": "https://serpapi.com/search.json?engine=google_play_product&gl=ua&hl=en&platform=phone&product_id=com.zhiliaoapp.musically&sort_by=1&store=apps", "thumbnail": "https://play-lh.googleusercontent.com/LdBITldj-tJxqLm-CsWSbnt4BMo2gk53cgM7mWIL-zn44m1ywLyQgxRsHKqp8r0qceXs=s64-rw" }, { "title": "Music Player - Audio Player", "subtitle": "Music style challenge: share your favorite music", "link": "https://play.google.com/store/apps/details?id=media.player.video.musicplayer", "product_id": "media.player.video.musicplayer", "serpapi_link": "https://serpapi.com/search.json?engine=google_play_product&gl=ua&hl=en&platform=phone&product_id=media.player.video.musicplayer&sort_by=1&store=apps", "thumbnail": "https://play-lh.googleusercontent.com/8cUyFAjYsNkjjlv4icdgHceu8TmwcUDHgpLTTIluj2pLUkJzOFVAK1ME2rUkU9G_JUc=s64-rw" }, { "title": "AI Chat\u30fbAsk Chatbot Assistant", "subtitle": "Make Every Photo Shine \u2013 Instantly Enhance with Ai Magic!", "link": "https://play.google.com/store/apps/details?id=com.mlink.ai.chat.assistant.robot", "product_id": "com.mlink.ai.chat.assistant.robot", "serpapi_link": "https://serpapi.com/search.json?engine=google_play_product&gl=ua&hl=en&platform=phone&product_id=com.mlink.ai.chat.assistant.robot&sort_by=1&store=apps", "thumbnail": "https://play-lh.googleusercontent.com/E4yyxrKGJUF8-YLVQ7MQRuvUtW3hVHd69fobjfmDql24JGu9PG-YEf1cPYFY5js4UnM=s64-rw" }, { "title": "Music Player", "subtitle": "Real Time Lyrics, Seamless Sing Along", "link": "https://play.google.com/store/apps/details?id=media.audioplayer.musicplayer", "product_id": "media.audioplayer.musicplayer", "serpapi_link": "https://serpapi.com/search.json?engine=google_play_product&gl=ua&hl=en&platform=phone&product_id=media.audioplayer.musicplayer&sort_by=1&store=apps", "thumbnail": "https://play-lh.googleusercontent.com/1TO53OEq3vDyIDnZgkrvsseC52YrZWo2XXfnqVFxD8yUh0d1HjAA8kUf8FS-iNljsIvM=s64-rw" }, { "title": "AI Video Enhancer - Utool", "subtitle": "New Kawaii Cartoon Style Effect You\u2019ll Love", "link": "https://play.google.com/store/apps/details?id=videoeditor.videomaker.aieffect", "product_id": "videoeditor.videomaker.aieffect", "serpapi_link": "https://serpapi.com/search.json?engine=google_play_product&gl=ua&hl=en&platform=phone&product_id=videoeditor.videomaker.aieffect&sort_by=1&store=apps", "thumbnail": "https://play-lh.googleusercontent.com/8q413dGm4d4iFvip7pcYRv0hxnajTqnZ6ivR-mX1xXTeHebhFsJoaHnDUPONeN8Cty0=s64-rw" }, { "title": "PREQUEL AI Filter Photo Editor", "subtitle": "Unique Vintage Vibe with "Denim"", "link": "https://play.google.com/store/apps/details?id=com.prequel.app", "product_id": "com.prequel.app", "serpapi_link": "https://serpapi.com/search.json?engine=google_play_product&gl=ua&hl=en&platform=phone&product_id=com.prequel.app&sort_by=1&store=apps", "thumbnail": "https://play-lh.googleusercontent.com/8LJJF7EdSlpSC3JuL6z1T7pRKDesekDVcsd-2Yk6Ecza1bCaTkeMCA_3BJKmhdpbjg4=s64-rw" }, { "title": "Gallery - Photo Gallery, Vault", "subtitle": "Photo Gallery Vault: Smart and powerful gallery to help you easily manage.", "link": "https://play.google.com/store/apps/details?id=com.ai.gallery.android", "product_id": "com.ai.gallery.android", "serpapi_link": "https://serpapi.com/search.json?engine=google_play_product&gl=ua&hl=en&platform=phone&product_id=com.ai.gallery.android&sort_by=1&store=apps", "thumbnail": "https://play-lh.googleusercontent.com/D5LFF78rJkylGqVtdeY5Kena8Nak-oNFjEsMApGB1NiV96NsCHSgrB7_r8Hp49cn3A=s64-rw" }, { "title": "Yousician: Learn Guitar & Bass", "subtitle": "Discover Artist Songbooks", "link": "https://play.google.com/store/apps/details?id=com.yousician.yousician", "product_id": "com.yousician.yousician", "serpapi_link": "https://serpapi.com/search.json?engine=google_play_product&gl=ua&hl=en&platform=phone&product_id=com.yousician.yousician&sort_by=1&store=apps", "thumbnail": "https://play-lh.googleusercontent.com/rvGKVcfHwU4_61dfTi75XC3-NoaPERlJ0v_5bGLPdya5HTMTA8pYqep_1PpbZfLj0w=s64-rw" }, { "title": "AI Chatbot - Nova", "subtitle": "Nova\u2019s Smarter Web Search Tool for Summer Vacation Inspiration", "link": "https://play.google.com/store/apps/details?id=com.scaleup.chatai", "product_id": "com.scaleup.chatai", "serpapi_link": "https://serpapi.com/search.json?engine=google_play_product&gl=ua&hl=en&platform=phone&product_id=com.scaleup.chatai&sort_by=1&store=apps", "thumbnail": "https://play-lh.googleusercontent.com/xDCktRsbzrc7A9CPmw90NYohjIrRJ_V8KRj7xNxhSoufl107I9_xDOC41Mx_rbKmRi8=s64-rw" }, { "title": "AI Photo Editor - AI Morph", "subtitle": "Flip the Anime Switch", "link": "https://play.google.com/store/apps/details?id=photoeditor.aiart.animefilter.snapai", "product_id": "photoeditor.aiart.animefilter.snapai", "serpapi_link": "https://serpapi.com/search.json?engine=google_play_product&gl=ua&hl=en&platform=phone&product_id=photoeditor.aiart.animefilter.snapai&sort_by=1&store=apps", "thumbnail": "https://play-lh.googleusercontent.com/mo447O7qKheeLBLZ7uUwOAoLtISv_Vxp1auf4Ls5Ie0EBDLAlwAgOiiU0Hyax2wam-w=s64-rw" } ] ], "organic_results": [ { "title": "Popular apps", "serpapi_section_pagination": { "next": "https://serpapi.com/search.json?engine=google_play&gl=ua&hl=en&section_page_token=YmASFwoCCAEQOxoLQVBQTElDQVRJT04qAggBSkAKPggYEKGFuP8GEJ6u3LIJEMaOupMDEPfxqZsNEIKViccJEPL9_-APELq-8ZQKEJLI_J0CEMDPybsJENC3pJcPUBT4AQA&store=apps", "section_page_token": "YmASFwoCCAEQOxoLQVBQTElDQVRJT04qAggBSkAKPggYEKGFuP8GEJ6u3LIJEMaOupMDEPfxqZsNEIKViccJEPL9_-APELq-8ZQKEJLI_J0CEMDPybsJENC3pJcPUBT4AQA" }, "items": [ { "title": "Temu: Shop Like a Billionaire", "link": "https://play.google.com/store/apps/details?id=com.einnovation.temu", "product_id": "com.einnovation.temu", "serpapi_link": "https://serpapi.com/search.json?engine=google_play_product&gl=ua&hl=en&platform=phone&product_id=com.einnovation.temu&sort_by=1&store=apps", "rating": 4.3, "author": "Temu", "category": "Shopping", "downloads": "500,000,000+", "thumbnail": "https://play-lh.googleusercontent.com/Nz5sdWyh7jn4eTy_GSaRBDgaKhLC1pvYywC6fklDOlPGbopmeFN9NkqgKGjsvJMbKVEI=s256-rw", "description": "Shop on Temu for exclusive offers.\n\nNo matter what you're looking for, Temu has you covered, including fashion, home decor, handmade crafts, beauty & cosmetics, clothing, shoes, and more.\n\nDownload Temu today and enjoy incredible deals daily.\n\nWIDE SELECTION\nDiscover thousands of new products and shops.\n\nCONVENIENCE\nFast and secure checkout.\nFree shipping & returns within 90 days.\n*Other conditions may apply\n\nVisit temu.com or follow us on:\nInstagram: https://www.instagram.com/temu/\nTikTok: https://www.tiktok.com/@temu\nFacebook: https://www.facebook.com/shoptemu\nYoutube: https://www.youtube.com/@temu" }, { "title": "Discord - Talk, Play, Hang Out", "link": "https://play.google.com/store/apps/details?id=com.discord", "product_id": "com.discord", "serpapi_link": "https://serpapi.com/search.json?engine=google_play_product&gl=ua&hl=en&platform=phone&product_id=com.discord&sort_by=1&store=apps", "rating": 4.1, "author": "Discord Inc.", "category": "Communication", "downloads": "500,000,000+", "video": "https://play.google.com/video/lava/web/player/yt:movie:UHPZHtLElfY?autoplay=1&embed=play", "thumbnail": "https://play-lh.googleusercontent.com/0oO5sAneb9lJP6l8c6DH4aj6f85qNpplQVHmPmbbBxAukDnlO7DarDW0b-kEIHa8SQ=s256-rw", "description": "Discord is designed for gaming and great for just chilling with friends or building a community. Customize your own space and gather your friends to talk while playing your favorite games, or just hang out.\n\nGROUP CHAT THAT\u2019S ALL FUN & GAMES\n\u2219 Discord is great for playing games and chilling with friends, or even building a worldwide community. Customize your own space to talk, play, and hang out in.\n\nMAKE YOUR GROUP CHATS MORE FUN\n\u2219 Create custom emoji, stickers, soundboard effects, and more to add your personality to voice, video, or text chat. Set your avatar, a custom status, and write your own profile to show up in chat your way.\n\nSTREAM LIKE YOU\u2019RE IN THE SAME ROOM\n\u2219 High-quality and low-latency streaming makes it feel like you're hanging out on the couch with friends while playing a game, watching shows, looking at photos, or idk doing homework or something.\n\nHOP IN WHEN YOU\u2019RE FREE, NO NEED TO CALL\n\u2219 Easily hop in and out of voice or text chats without having to call or invite anyone, so you can chat with your friends before, during, and after your game session.\n\nSEE WHO\u2019S AROUND TO CHILL\n\u2219 See who\u2019s around, playing games, or just hanging out. For supported games, you can see what modes or characters your friends are playing and directly join up.\n\nALWAYS HAVE SOMETHING TO DO TOGETHER\n\u2219 Watch videos, play built-in games, listen to music, or just scroll together and spam memes. Seamlessly text, call, video chat, and play games, all in one group chat.\n\nWHEREVER YOU GAME, HANG OUT HERE\n\u2219 On your PC, phone, or console, you can still hang out on Discord. Easily switch between devices and use tools to manage multiple group chats with friends." },