Hello:
I’m new to AppSheet, so please bear with me.
I have built an Appsheet app based on data in Google Sheets. It works fine.
I have built my first bot that sends a Slack message triggered by an add to one of the sheets in Google Sheets.
The event shows up when I add a row, and when I click the Test button, the Slack message is sent successfully.
But, I want the bot to trigger automatically and send the Slack message.
How do I make that happen?
Is it possibly related to TriggerCondition=TEST?
Here is the event data:
{
“$type”: “V2API.AppProcessExecution.RaisedEvent, V2API”,
“AppTemplateId”: “50abfcc9-300a-43be-a93f-b99a1a0d72cc”,
“AppTemplateVersion”: “1.000053”,
“EventName”: “System Event”,
“EventId”: “-1”,
“EventInstanceId”: “fb9c31be-ee00-49c8-8b60-72b6f417d9db”,
“TableName”: “Q Once Off Revenue”,
“AfterImage”: {
“_RowNumber”: “12”,
“Name”: “ABC”,
“Quantity”: “1”,
“Compliance”: “”,
“Impl, Training, Business Plans”: “”,
“Talks and External Training”: “”,
“Total”: “”
},
“TriggerCondition”: “TEST”,
“BotIdToRun”: “e587ec71-5738-4f97-9d8c-60520722d226”,
“ProcessId”: “c30251dc-123f-469a-a715-c804892c7045”,
“ProcessInstanceId”: “00000000-0000-0000-0000-000000000000”,
“UpdateMode”: 0
}
Thank you for any help you can provide,
Tom
Is your app deployed?
[Workflow Emails not working](https://community.appsheet.com/t/workflow-emails-not-working/55221/3) Questions
Is your app deployed? [image] If your app is not deployed (as pictured above), emails sent by workflows/bots will go only to the app owner, not to the intended recipient.
2 Likes
Marc_Dillon:
Is your app deployed?
As @Marc_Dillon and @Steve, have noted in their respective posts, apps that are undeployed (prototype mode) do not have all capabilities enabled. Whether this is the problem depends on how you have your Event implemented. For example, Scheduled Bots (those that run Daily, Monthly, etc) WILL NOT automatically trigger for undeployed (FREE) apps.
In your case, it would appear that you are attempting to use a webhook to connect to Slack’s API? I have not extensively used webhooks but I BELIEVE you should be able to test them, even in an automatic fashion, in undeployed apps…as long as the Bot is not a Scheduled Bot.
Tom_Steppe:
Is it possibly related to TriggerCondition=TEST?
Yes. A trigger condition of the simple word “TEST” may cause it to result in FALSE. I don’t know this for sure as I have never tried it. I would remove it and try your test again.
If the idea was to place a comment identifying this bot Event as a “test” event, there is a documentation section at the bottom of the Event where you can insert a Descriptive Comment
1 Like
Thank you so much for the quick responses. I’m still stuck, though.
- The app is deployed.
- Is there even a way I can affect TriggerCondtion=TEST?
- I never intentionally specified this.
- Is there away I can affect the values of TEST?
Tom_Steppe:
Is there even a way I can affect TriggerCondtion=TEST?> > - I never intentionally specified this.
I think I completely misunderstood what you meant by this originally. I thought you were referring to something you had intentionally placed in the Condition property of the Event within the Bot. I now realize (which I didn’t know before) that when you tap the Test button on the Bot, the TriggerCondition log entry reflects “TEST”.
So let’s back up for a moment. Can you provide us with an image of the Bot’s Event settings so we can see how you have set it up to run?
2 Likes
Thank you for your persistence! Sure, here are the Bot’s Event settings:
Thank you!
First, fyi, you don’t need the “(1=1)”, you can leave it blank and it will be treated as “true”.
There was a similar post just a couple days ago. After several back and forths it was realized that the user was adding rows through Google Forms - not from an AppSheet form. Are you adding your rows from a Google Form?
1 Like
Hi John:
Regarding the “1=1”, I was just experimenting with anything to try to make this work.
I am neither adding my rows through a Google Form, nor through an AppSheet Form. I am adding them directly onto a Google Sheet.
I have read in some places that this won’t work, and in other places that it would. So, you might be onto something here. I finally deduced (hoped?) that wasn’t the problem, though, because the events are, in fact, showing up in AppSheet (which makes me think it’s working) and everything seems to be in order EXCEPT they aren’t being automatically processed.
Any further thoughts?
Tom
You might check out this post. There is a linked video which may help to get things setup and a better understanding of what is expected.
[External Eventing with Google Sheets - Cannot Choose External Event](https://community.appsheet.com/t/external-eventing-with-google-sheets-cannot-choose-external-event/47990) AppSheet Automation
I installed the Google Sheets Add-on “AppSheet Events” as shown in the video tutorial below. (1) AppSheet Automation: External eventing with Google Sheets - YouTube (1) Successfully Installed Add-on (2) Successfully inserted API Key into Sheets Add-on (using incognito window method) (3) Created a new Automation Bot in AppSheet [image] Issue: There is no apparent way to select the google sheet event as an event type like in the video. The video tutorial is silent on how to do this and ther…
1 Like
Hello everyone,
Can anyone confirm that it works? For me nothing is triggered when I add a new line.
I have installed AppSheet event in Google Sheet but .
App is deployed. Mail is being sent when I click test in AppSheet.
Thank you
