Good Morning! In the company I work recently we have changed the office package to the G-Suite and with this we are facing some problems because many sectors use excel for complex functions, then there is the problem: Today in Excel we have a spreadsheet that sends billing automatically through Outlook, turns some spreadsheet lines into pdf and attaches in those emails, what the user has to do is just enter the information and excel does it all automatically at the push of a button .
YOU CAN MAKE A SCRIPT THAT IN GOOGLE SHEETS THAT MAKES THIS ACTIVITY.
** I have been able to automatically send email through corporate gmail, but what I can not execute is the second part of the pdf.