You can update your table with append mode using many of the google sheets extensions from the marketplace.

Like THIS one for example from OWOX Analytics (also with the overwrite option) or another one from Max Makhrov, a Google Sheets / Apps Script Expert.

Both of them come 100% free for Upload data from Sheets to BigQuery so far.