从appScript和谷歌表单中获取姓氏和电话号码

Question

我有这两个函数，它们从谷歌表单中获取数据，然后发送whatsapp消息。我不能修改第一个函数(getSheetData_(以只获取最后一行的数据。我只有两栏(姓名和电话(。我有一个触发器，可以在每次更改时启动脚本。

来源：https://www.labnol.org/whatsapp-api-google-sheets-220520

const getSheetData_ = () => {
const [header, ...rows] = SpreadsheetApp.getActiveSheet().getDataRange().getDisplayValues();
const data = [];
rows.forEach((row) => {
const recipient = { };
header.forEach((title, column) => {
recipient[title] = row[column];
});
data.push(recipient);
});
return data;
};
const main = () => {
const data = getSheetData_();
data.forEach((recipient) => {
const status = sendMessage_({
recipient_number: recipient["Phone Number"].replace(/[^d]/g, ""),
customer_name: recipient["Customer Name"]
});
});
};

Answer 1

解决方案：

const getSheetData_ = () => {
var sheet = SpreadsheetApp.getActiveSheet();
var lastRow = sheet.getRange(sheet.getLastRow(),1,1,2);
const header = ['Customer Name', 'Phone Number'];
const rows = lastRow.getDisplayValues();
const data = [];
rows.forEach((row) => {
const recipient = { };
header.forEach((title, column) => {
recipient[title] = row[column];
});
data.push(recipient);
});
return data;
};