Hot answers tagged google-forms
Here is how it could work. The script does the following: Get the sheet with form responses Get the last (nonempty) row there Pick the entry from column B. To make matching more robust, it trims the entry (removing any whitespace left or right of text), and converts to lower case. If the result is 'yes', an email is sent. The body is the content of the ...
Only top voted, non community-wiki answers of a minimum length are eligible