0
votes

I have a Google form. I have a sheet using script that employs arrays storing a list of names, emails, and a subject line collected from my sheet

I want to run a script from my sheet that calls the form (via id, url, or whatever) and tells it to "send" the form to those email addresses.

I cannot find Form API that touches the Forms "Send" feature.

Is that possible? Or will I need to manually generate and send the emails using script the old fashioned way? So they will appear as an email with a link to click rather than the nicely formatted Google Forms email?

1

1 Answers

1
votes

There is no Form API but there is the Google Apps Script Forms Service but it hasn't a "send" method but it has a getPublishedUrl() that you can use to grab the respond view and send it by using MailApp or GmailApp.