Re: Unable to send email using bot

Paras_Sood · 01-10-2023 09:41 PM

hi Appsheet community,

I have an app for which I am trying to generate an email report via the bot but for some reason the bot does not shoot the email. I have tried deleting the bot and creating a new one from scratch without editing any details in the default bot.

This is how the email preview looks like

All the tests and runs I have done for the bot show as successful without any errors.

But I am not receiving any emails, even if I just put a "test" in the body of the email. The preview shows that it should be working. I have tried checking spam folder and junk mail but no luck. Any suggestions?

Suvrutt_Gurjar

You may want to check for any errors under the Manage --> Monitor --> Audit History --> Launch Log Analyser option for any errors. Typically error steps should be shown there. Please click on the red binocular option to see the error message.

Paras_Sood

Thanks for your feedback. There are no errors that I can see in the log analyzer.

Any other suggestions? This is extremely strange behaviour from appsheet that I have not seen before.

The only discrepency that may be a potential problem is that the data on google sheets used to create this app is itself sourced from an import range function. All of the data is meant to be read-only. I can see all of the data on google sheets and on the app as well. When I invoke the bot though I do not technically ask for any data from the spreadsheet so I do not believe that this should be the issue.

Paras_Sood

Im still in a bit of a fix to solve this. Do any appsheet gurus have suggestions please? @Steve @Marc_Dillon

Paras_Sood

UPDATE: I created a dummy account and tried to send emails to that, and it worked. I am not able to receive emails on my mailbox but it works when I use the dummy mailbox. What is going on?

Scott_Nesbitt

I, too, have a bot that silently fails to send email. I have done this fine in the past, but this time I see the event and the process happening, and the log looks fine, but no email gets sent.

Is it poossible there is a system problem?

devingu

Hey all, have you checked the spam folder and see if there are anything inside? Sometimes it will go to the spam folder. LMK!

At the same time, our support and product team are also looking into the issue. Will keep you posted on this!

Paras_Sood

Hi devingu,

Yes I have checked my spam folder as well.

When my app was not in the deployed state, I did not receive any e-mails. However, once I moved my app to the deployed state, I do not receive any emails on the email I have used to create the app. I created a dummy mailbox and I am able to receive emails from the bot in that mailbox.

devingu

Thanks for the update and a few more questions if you don't mind:

1. Have you checked if your email address that you've used to create the app is on the recipient list of the Email bot?

2. Have you entered your Email address correctly for the one you used to create the app?

Paras_Sood

1. Yes, I have done multiple tests on multiple apps. I stopped receiving emails from an app that was already deployed, on which I had not made any changes at all. Did a few more tests by changing email addresses and it works as long as I do not put the app creator email address in the recipient list.

2. Yes

devingu

Thanks a lot Paras_Sood, I believe you've already created a ticket from our support team. We will investigate and reach back out to you as soon as we make some progress!

Scott_Nesbitt

Actually, this was the solution for me. AppSheet email used to go to my inbox but at some point Gmail (!) flagged them as spam. Thanks for the reponse.

devingu

No problem, glad it helped!!

Markus_Malessa

Could an update be provided on this issue? I am starting to receive reports from users that emails that used to go to their inbox are now going to spam, with one person even reporting that an email went to their archives. Is this a problem with flagging from the AppSheet side or a change in Gmail itself as to what is perceived as spam? I'm thinking somehow that maybe Gmail interprets emails from AppSheet as coming from a 'subscriber list' and therefore automatically it going to spam.

Paras_Sood

Hi

I use outlook (Microsoft 365) and my emails do not go to the spam folder. I checked all mailboxes, it is in none of them. I have tried putting other users in our organisation in the email as well and they receive the email, it is just me (the creator of the app) who is not receiving emails. But when I check the email received by other users, it shows me that the email was sent out to my mailbox as well but somehow it never reached my mailbox.

devingu

Hey Markus_Malessa, we are investigating the issue from the AppSheet support and product team. If you haven't reached out to our support team, please feel free to do so here. Our support specialists will share more information with you.

As we are making progress from Google's side, to mitigate the issue, you can mark the Email from AppSheet as non-spam. This should prevent it from going to spam again.

Paras_Sood

An update to the situation:

I sent an email to the dummy mailbox as well as creator mailbox. Email went through in the dummy mailbox and it says that the email has been sent to the creator mailbox as well, but I have not received any email in the creator mailbox. This has never happened before nor have we changed any mailbox configurations. We're using Microsoft 365 Business Standard.

Paras_Sood

Across all of my apps I am not receiving any emails but the other members in the organisation under the same Azure AD are able to receive the emails, I do not believe this is a problem with the email server.

devingu

Hey Para_Sood, thanks for the update again.

If you haven't reached out to our support team, please feel free to do so here

Our support specialists can take a closer look into the issue and help you resolve the problem.

Paras_Sood

@devingu wrote:
Thanks a lot Paras_Sood, I believe you've already created a ticket from our support team. We will investigate and reach back out to you as soon as we make some progress!

@devingu just above in the thread you said that you already have my support ticket. Is there any misunderstanding here?

devingu

Hey Paras_Sood, I am not able to see your Email in the forum so I am not 100% sure if you are the one submitted the ticket. That's why I want to remind you again just to make sure you are aware that the support team is always available to you. If you've already had connected with one of our specialist, you are fine. But feel free to DM me directly if you have any concerns (so you can share the Email with me and I can take a closer look)! Thanks!

Emmanuelpina

hy community

I have the same problems with my app, since january 12 its leaves send email, I need Help, please!😥

devingu

Hey Emmanuelpina, thanks for reaching out to us. It's likely the Email has been delivered to your recipients' spam folder. Please kindly remind them to do a thorough check. Otherwise, please feel free to open a ticket at https://support.google.com/appsheet/gethelp

Paras_Sood

It's been almost an year and this issue is still unresolved.

mateo

Hi there,
I can confirm that I face this issue as well but only in particular cases when the app sends emails to all app users and customers (long list). No one ever gets the message. I cannot find any issue on my side as both the automation monitor and log analyzer say it was sent. Can anyone help, please?

devingu

Do you have an oversized attachment?

mateo

No attachment, 3 lines of text in the message body

mateo

@devingu do you have any other suggestions?

BlakeM

@mateo are you updating the spreadsheet programmatically? I was also not getting emails sent from AppSheet, but I think the reason is because events only fire from end user updates to Sheets. My use case need programmatic triggering, unfortunately.

mateo

@BlakeM I do not understand what you mean but this automation is triggered by "Adds and updates" event in 2 scenarios.

When an external user sends Google Form it triggers Apps Script project that performs some operations on Google Drive, adds a row to the table, and makes an AppSheet API call to update this row (in order to trigger automation which sends an email).
When the user adds a row via the AppSheet app.

In both cases automation is triggered, I can see that in the monitor and log analyzer but emails never come to the recipients...