Trigger an automation from Google Forms and Sheets

[dpavlov]

Hello,

i have a google form that collects data to google sheet. I have build an app and i want when a new form is submitted, to trigger an email notification to specific email address.

I have installed the Google Sheets AppSheet Addon - AppSheet Events and turned events on for the sheet in use. I can see that this sheet is used in my app in the addon itself.

I have configured the bot with an event to watch for adds_only and task to trigger a new email.

However, this is not working and the bot is not triggered at all - don’t see anything in the monitoring for this particular bot.

Could someone please advise what am i doing wrong?

[Marc_Dillon]

External eventing only triggers from manual data changes, when a user manually opens the GSheet and changes a cell. You might consider some other options:

1. Use something like Zapier to watch for new changes to send out the email alerts.
2. Build a new record processing system into your app that only shows newly-added records (via a slice), and allows the user to “process” them in some way (send email, copy to another table, etc…)
3. Setup a schedule-driven Bot to watch for new records (like once a day).
4. ???

[Apppie]

I'm facing the same drawback, and many others with me.

Is this something that can be solved?