I have an existing Google Form that students use to submit their contact information, and to let us know what kinds of classes they are interested in. I want an email to be automatically sent to students after they fill out the form.
When the form is submitted, automatically populates a Google Sheets file, which is the data source for my App Sheet table. I set up a workflow that should send an email when a new row is added to the table. However, the emails aren’t being sent.
I checked the audit log, and it does not show any “Add Row” operations. I found this article, and it seems like workflows are only triggered when records are added through App Sheet.
Is there a way to make it so the workflow is triggered when a Google Form is filled out? Or to create a form that the students can use without having access to stored data or other parts of the app?