我想让脚本发送电子邮件只到最后添加在谷歌电子表格

import smtplib

# 设置SMTP服务器和端口
smtp_server = 'smtp.gmail.com'
smtp_port = 587

# 建立与SMTP服务器的连接
smtp_connection = smtplib.SMTP(smtp_server, smtp_port)

# 开启TLS加密
smtp_connection.starttls()

# 登录到电子邮件账户
email_address = 'your_email@gmail.com'
password = 'your_password'
smtp_connection.login(email_address, password)

from email.mime.text import MIMEText

# 创建电子邮件消息
recipient = 'recipient@example.com'
subject = 'Hello from script'
body = 'This is the content of the email.'

message = MIMEText(body)
message['From'] = email_address
message['To'] = recipient
message['Subject'] = subject

# 发送电子邮件
smtp_connection.sendmail(email_address, recipient, message.as_string())

import gspread
from oauth2client.service_account import ServiceAccountCredentials

# 使用API密钥进行身份验证
scope = ['https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive']
credentials = ServiceAccountCredentials.from_json_keyfile_name('credentials.json', scope)
client = gspread.authorize(credentials)

# 打开电子表格
spreadsheet = client.open('Your Spreadsheet')

# 选择工作表
worksheet = spreadsheet.get_worksheet(0)

# 添加数据到电子表格
data = [email_address, recipient, subject, body]
worksheet.append_row(data)