function sendWebhookOnEdit(e) {
const webhookUrl = ''; //替换为你 webhook 节点的 test url
const editedRow = e.range.getRow();
const sheet = e.source.getSheetByName("video2text");
const rowData = sheet.getRange(editedRow, 1, 1, sheet.getLastColumn()).getValues()[0];
contentType: 'application/json',
payload: JSON.stringify(payload),
muteHttpExceptions: true
const response = UrlFetchApp.fetch(webhookUrl, options);
// 获取 n8n 的返回文案内容(纯文本模式)
const responseText = response.getContentText();
// 将返回内容写入第 2 列(你可以改成其他列索引)
const writeColumn = 2; // 第 B 列
sheet.getRange(editedRow, writeColumn).setValue(responseText);
Logger.log("Webhook error: " + err.message);
function installTrigger() {
ScriptApp.newTrigger("sendWebhookOnEdit")
.forSpreadsheet(SpreadsheetApp.getActiveSpreadsheet())