我拼湊了幾個不同的腳本來讓它工作,但我似乎無法獲得代碼來正確輸入數據。電子郵件輸入:*Status:* *Date:* 03/31/2020*WorkOrder:* 123456-1*DMSShipDate:* 03/31/2020*PONumber:* 8675309*Company:* Test腳本var ui = SpreadsheetApp.getUi();function onOpen(e){ ui.createMenu("Import Email").addItem("Import Email", "getGmailEmails").addToUi();}function getGmailEmails(){ if (Session.getActiveUser().getEmail() != "[email protected]"){ Browser.msgBox("Please log in as [email protected]"); return; } var label = GmailApp.getUserLabelByName("ImportMe"); var threads = label.getThreads(); for(var i = threads.length - 1; i >=0; i--){ var messages = threads[i].getMessages(); for (var j = 0; j <messages.length; j++){ var message = messages[j]; extractDetails(message); GmailApp.markMessageRead(message); } threads[i].removeLabel(label); }}function extractDetails(message){ var bodyContents = message.getPlainBody(); var status = bodyContents.match(/\*Status:\*(.*) /); var dateEntered = bodyContents.match(/\*Date:\*(.*) /); var workOrder = bodyContents.match(/\*WorkOrder:\*(.*) /); var dmsShipDate = bodyContents.match(/\*DMSShipDate:\*(.*) /); var poNum = bodyContents.match(/\*PONumber:\*(.*) /); var company = bodyContents.match(/\*Company:\*(.*) /); var activeSheet = SpreadsheetApp.getActiveSheet(); activeSheet.appendRow([status, dateEntered, workOrder, dmsShipDate, poNum, company]);}結果:I get the following in each column:[Ljava.lang.Object;@488e1851, [Ljava.lang.Object;@5c588720, etc, etc我已經嘗試過 JSON.Stringify 和 toString() 但似乎沒有任何東西能夠正確地將數據放入列中。
Google Sheet Import Ljava.lang.Object 錯誤
喵喔喔
2022-06-09 11:20:44