Beautiful Soup&GSpread将数据附加到Google表中，而不是替换

Question

我的第一个价格检查程序可以监控50种产品并提取数据，每天凌晨3点运行。目前，检查的产品是附加到现有的数据，这显然是产生重复，所以在几天内，我将结束50，100，150行。。。在

如何让Python脚本替换或清除现有数据，这样电子表格中只包含50个产品？在

以下是代码的顶部：

from selenium import webdriver 
import time
from bs4 import BeautifulSoup


import json
import gspread
#from oauth2client.client import SignedJwtAssertionCredentials
from oauth2client.client import SignedJwtAssertionCredentials
from json import load
import urllib2

browser = webdriver.PhantomJS()

product_details = []



def connect_to_spreadsheet():
    json_key = json.load(open('0b6bb6f4e5.json'))
    scope = ['https://spreadsheets.google.com/feeds']
    credentials = SignedJwtAssertionCredentials(json_key['client_email'], json_key['private_key'].encode(), scope)
    #credentials = AssertionCredentials(json_key['client_email'], json_key['private_key'].encode(), scope)
    gc = gspread.authorize(credentials)
    wks = gc.open("TestSheet")

    worksheet = wks.worksheet('automated')
    last_row = worksheet.row_count 
    last_col = worksheet.col_count - 1 

    for each_row_data in product_details:
        try:
            worksheet.append_row(each_row_data)
        except:
            print "Could not add row data", each_row_data

Answer 1

clear（）清除工作表，但生成的内容在清除后开始

worksheet = wks.worksheet('automated')
worksheet.clear()

但是很明显函数（）是必需的，只需要数据就可以从A2开始