Append rows to Google Sheets from Python without creating duplicates (gspread)

Why append_row creates duplicate rows after a retry or a second run, and a tested gspread helper that appends new rows, updates changed ones and skips the rest, in at most three API requests.