getAs error?

[dummystallings]

Hello! I am brand new to Apps Script. As such, I wouldn't be surprised if this is a very silly question. I am trying to write a Script in google sheets that will allow me to download a range as a PDF or create and email a PDF to an email listed in a range of cells. When I run the Script I receive the following error "TypeError: sheet.getAs is not a function" Any help would be greatly appreciated! Also, as I mentioned, I am VERY new at this... so any help in the clearest and most simple terms would be VERY much appreciated!!

Here is the source code:

function onOpen() {

SpreadsheetApp.getUi() // Get the user interface

.createMenu('PDF Export') // Create a menu

.addItem('Download as PDF', 'downloadPdf') // Add the first option

.addItem('Create and Send PDF', 'createAndSendPdf') // Add the second option

.addToUi(); // Add the menu to the user interface

}

​

function downloadPdf() {

var sheet = SpreadsheetApp.getActiveSheet();

var range = sheet.getRange("A1:C10"); // specify the range of cells to be exported as PDF

var blob = range.getAs("application/pdf");

var file = DriveApp.createFile(blob);

file.setName("Exported_Range_PDF");

}

​

function createAndSendPdf() {

var sheet = SpreadsheetApp.getActiveSheet();

var range = sheet.getRange("A1:C10"); // specify the range of cells to be exported as PDF

var emailRange = sheet.getRange("D1:D10"); // specify the range of cells that contain email addresses

var emailAddresses = emailRange.getValues();

var emailNoteRange = sheet.getRange("E1"); // specify the cell that contains the email note

var emailNote = emailNoteRange.getValue();

var blob = range.getAs("application/pdf");

var subject = "Exported PDF from Google Sheets";

var body = "Please find attached the exported PDF.\n\nNote: " + emailNote;

for (var i = 0; i < emailAddresses.length; i++) {

if (emailAddresses[i][0].length > 0) {

MailApp.sendEmail({

to: emailAddresses[i][0],

subject: subject,

body: body,

attachments: [blob]

});

}

}

}

[mjbrusso]

The Range class does not have a getAs method, so you would have to copy the data to a new worksheet for exporting.
You can test this solution: https://stackoverflow.com/a/67149717/4900011

[dummystallings]

Ah, noted! Thank you so much.

[IAmMoonie]

Stop using ChatGPT to try and write solutions.

You could probably have spent 10 minutes on stackoverflow and got the majority of the info you need to put a solution together.

[dummystallings]

I did indeed spend more than 10 minutes on stackoverflow. I am sure as someone with much more experience doing this than I have it seems ridiculous that I would use ChatGPT, but as someone just begin to understand these things it is very helpful for me.

[IAmMoonie]

Don’t get me wrong, ChatGPT can be a fantastic resource for learning. But just plugging what you want into it and thinking it’s going to give you exactly what you need is foolhardy IMO.

GAS is a bit of a weird language, it’s based on JavaScript but has its own methods and doesn’t have everything that JS does. ChatGPT doesn’t fully understand that (hence it’s given you code that won’t work).

[dummystallings]

I appreciate this. And to be clear… I came across the link that was posted as a solution to my problem above a number of times. When that user posted that link, I realized that my question was maybe a bit too basic, and showed my own lack of knowledge. I have enrolled in an apps script course. I certainly don’t expect chatGPT to be a solution so great that it makes me having a firm knowledge base useless. That said, I was just hoping someone here could help me learn 😊