Ok, there is a workaround using a free plugin for google sheets called trigger and send. This plugin will send an HTTP Request to an endpoint every time a form (associated with a spreadsheet) is submitted. You can catch that HTTP Request using the webhook node and then send the email using one of the nodes to do so.
The plugin can be found here.
1 November, 2020 - Loom Recording — Watch Video
