Automate Google Sheets to PDF and Email with Google Apps Script
Description
What I want:
I want a Google Sheets document, converted into a PDF, and emailed.
What I have:
I have a google sheet that is being updated via typeform (IN SHEET 1).
I then have that data populate (SHEET 2) using a lookup function (as sheet 2 is formatted properly).
What I need:
I want to CREATE A PDF out of SHEET 2.
I want to EMAIL that PDF to the email address (data is in both Sheet 1 & 2).
Additional Problem:
The excel formula in SHEET 2 is broken, it needs to be fixed to "Read the bottom row".
To complete the task:
I am open to any way to do this. Such as Zapier (I couldn't get it to work).
I am open to having a separate worksheet/spreadsheet being created for each instance.
I would also like the ability to format the email that is being sent, (nothing too complicated, just an email subject, body, and of course the PDF attachment.
Works with Apps
From Ashton
In this project, we utilize the capabilities of Google Apps Scripts to automate the process of converting Google Sheets to PDF format and subsequently sending the generated PDF via email through Gmail. This workflow is commonly employed within the Google Workspace ecosystem for the purpose of generating automatic reports.
From Client
Great work. Great communication. Great Speed. Will work with Ashton again.
Google Apps Script Projects Shared On YouTube
Links
Work with Me on Upwork YouTube Twitter / X Automate The Boring (Blog)
Comments
Post a Comment