I have created form using Zoho, the responses of which are linked to Google Sheet. The link of google sheet is as below. Once a user submit the form, the data uploaded in google sheet automatically.
Added the
afterFormSubmit
function to atime-driven trigger
(in my testing-it, will run every minute):
PDF was sent via email to my test email account added on the last row
Then the PDF URL and and PDF file name was posted on
Sheet 2
columns 63 & 64 on the last row data.
Time-Driven trigger logs from the Apps Script Editor: