Breaking News: Grepper is joining You.com. Read the official announcement!

Convert Full Google Sheet to a PDF File

Scary Sloth answered on July 16, 2022 Popularity 9/10 Helpfulness 2/10

answer Convert Full Google Sheet to a PDF File

Convert Full Google Sheet to a PDF File

Comment

function emailGoogleSpreadsheetAsPDF() {
  // Send the PDF of the spreadsheet to this email address
  var email = 'amit@labnol.org';

  // Get the currently active spreadsheet URL (link)
  var ss = SpreadsheetApp.getActiveSpreadsheet();

  // Subject of email message
  var subject = 'PDF generated from spreadsheet ' + ss.getName();

  // Email Body can  be HTML too
  var body =
    "Sent via <a href='https://workspace.google.com/marketplace/app/email_spreadsheets/431723916752'>Email Spreadsheets</a>";

  var blob = DriveApp.getFileById(ss.getId()).getAs('application/pdf');

  blob.setName(ss.getName() + '.pdf');

  // If allowed to send emails, send the email with the PDF attachment
  if (MailApp.getRemainingDailyQuota() > 0)
    GmailApp.sendEmail(email, subject, body, {
      htmlBody: body,
      attachments: [blob],
    });
}

Popularity 9/10 Helpfulness 2/10 Language javascript

Source: www.labnol.org

Tags: file javascript pdf

Link to this answer
Share Copy Link

Contributed on Jul 16 2022

Scary Sloth

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Convert Full Google Sheet to a PDF File

Contents

More Related Answers

Convert Full Google Sheet to a PDF File

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.