from sheet import Sheet import bitly_api from dotenv import load_dotenv import os import settings load_dotenv() access_token = os.getenv("access_token") c = bitly_api.Connection(access_token = access_token) table = Sheet("arac-tel","Sheet1") raw_video_url = table.worksheet.acell(settings.long_url_cell).value starting_row = table.first_empty_row("shortened-video-url") end_row = starting_row + 30 for i in range(end_row-starting_row): phone_col_number = table.columns.index("phone")+1 phone = table.worksheet.cell(starting_row+i, phone_col_number).value shortened_dict = c.shorten(raw_video_url+"&r="+phone, preferred_domain = "j.mp") print(shortened_dict["url"]) table.update_one_cell(starting_row+i, "shortened-video-url", shortened_dict["url"])