import requests videos = ["CvJG4sQhzsw", "8ituvCpaI3g", "WeLQpUC2IW4"] list1 = [] for el in videos: url = "https://www.googleapis.com/youtube/v3/videos?part=statistics&id=" vid_id = "8ituvCpaI3g" key = "&key=AIzaSyDiYzhofYCy6IdQkXcd8CNdiezAqfeprtE" url=url+el+key r = requests.get(url) someStorage = r.json() list1.append(someStorage["items"][0]["statistics"]["commentCount"]) print(list1) print(videos) import pandas df1 = pandas.DataFrame() df1["video_id"] = videos df1["comments"] = list1 df1.to_excel("something.xlsx") import time time.sleep(1)