• Home
  • Jobs
  • Courses
  • Questions
  • Teachers
  • For business
  • ES/EN

0

20
Views
getting TypeError: Cannot read property 'getAs' of undefined , in google app script

i am trying to write a script to send mail and a pdf as attachment using app script but i keep getting this error

function sendEmails() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var startRow = 2; // First row of data to process
  var numRows = SpreadsheetApp.getActiveSheet().getRange('I1').getValue(); // getting number of rows by fetching value from a count function in sheet
  var dataRange = sheet.getRange(startRow, 1, numRows, 2);
  // Fetch values for each row in the Range.
  var data = dataRange.getValues();
  for (var i in data) {
    var row = data[i];
    var emailAddress = row[0]; // First column
    var link = row[1];// Fetching ID by using mid fuction in sheet
    var file = DriveApp.getFileById(link);
    var subject = 'Sending emails from a Spreadsheet';
    var htmlBody = DriveApp.getFileById("14KhceDa2lg7ojnwzFwpfiJCCx-xldPPj")
    MailApp.sendEmail(emailAddress, subject, {htmlBody: htmlBody}, {attachments: [file[0].getAs(MimeType.PDF)]})
  }
}

about 1 month ago ·

Juan Pablo Isaza

2 answers
Answer question

0

You get only file object using DriveApp.getFileById so use file.getAs() directly as shown in below code

function sendEmails() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var startRow = 2; // First row of data to process
  var numRows = SpreadsheetApp.getActiveSheet().getRange('I1').getValue(); // getting number of rows by fetching value from a count function in sheet
  var dataRange = sheet.getRange(startRow, 1, numRows, 2);
  // Fetch values for each row in the Range.
  var data = dataRange.getValues();
  for (var i in data) {
    var row = data[i];
    var emailAddress = row[0]; // First column
    var link = row[1];// Fetching ID by using mid fuction in sheet
    var file = DriveApp.getFileById(link);
    var subject = 'Sending emails from a Spreadsheet';
    var htmlBody = DriveApp.getFileById("14KhceDa2lg7ojnwzFwpfiJCCx-xldPPj")
    MailApp.sendEmail(emailAddress, subject, {htmlBody: htmlBody}, {attachments: [file.getAs(MimeType.PDF)]})
  }
}

about 1 month ago · Juan Pablo Isaza Report

0

Try this:

 MailApp.sendEmail(emailAddress,subject,'',{htmlBody: htmlBody,attachments: [file.getAs(MimeType.PDF)]})
about 1 month ago · Juan Pablo Isaza Report
Answer question
Find remote jobs
Loading

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post job Plans Our process Sales
Legal
Terms and conditions Privacy policy
© 2022 PeakU Inc. All Rights Reserved.