We have a form that people in our org use. What we would like to do is use Flow to send an email to everyone else that is submitting into the form. Few questions:
1) How do we even find the underlying spreadsheet of the form? Where is it stored?
2) How do we make it go through the spreadsheet and send one email to all the participants instead of a separate email each time it sees an email?
3) How do we get it to send an email as soon as someone enters data? We want the notices to be real-time.