Trigger an automation from Google Forms and Sheets

AppSheet AppSheet Q&A
1

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.

3X_1_3_1359133835f2fb769146a7ccda0543742be574e7.png
3X_1_3_1359133835f2fb769146a7ccda0543742be574e7.png772Ă—325 40.8 KB

3X_a_5_a5a473260ae63dd3e72b53ae312f2d27b42ba2fe.png
3X_a_5_a5a473260ae63dd3e72b53ae312f2d27b42ba2fe.png343Ă—781 19.5 KB

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?

2

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. ???
1 Like
3

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

Is this something that can be solved?