sa = gspread.service_account(filename="/Users/jitendersingh/Documents/sheetsapi.json")
sh = sa.open('only74kotc')
sheet = sh.worksheet('tera')
# Get all values in column 2 (assuming column B)
column_2_values = sheet.col_values(2)
# Find the index of the first blank cell in column 2
first_blank_row_index = len(column_2_values) + 1
# Loop starting from the first blank row in column 2
for row_number in range(first_blank_row_index, sheet.row_count + 1):
link = sheet.cell(row_number, 1).value
0 comments:
Post a Comment