Breaking News: Grepper is joining You.com. Read the official announcement!

gspread get last row

Happy Hawk answered on May 4, 2020 Popularity 6/10 Helpfulness 5/10

answer gspread get last row

gspread get last row

Comment

def next_available_row(worksheet):
    str_list = list(filter(None, worksheet.col_values(1)))
    return str(len(str_list)+1)

scope = ['https://spreadsheets.google.com/feeds']
credentials = ServiceAccountCredentials.from_json_keyfile_name('auth.json', scope)
gc = gspread.authorize(credentials)
worksheet = gc.open("sheet name").sheet1
next_row = next_available_row(worksheet)

#insert on the next available row

worksheet.update_acell("A{}".format(next_row), somevar)
worksheet.update_acell("B{}".format(next_row), somevar2)

Popularity 6/10 Helpfulness 5/10 Language whatever

Source: stackoverflow.com

Tags: get gspread row whatever

Link to this answer
Share Copy Link