New automation to send an email when a new record is added to a Baserow table

Baserow Help
1

Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?

SaaS

What do you need help with?

Using the new automation feature to send an email when a new record is added to a Baserow table (see attached screenshot of this automation). I have followed all of the documentation that I can find, which seems straight-forward. The trigger for when a new record is added to a Baserow database table seems to work fine when tested, however, the following one action to send an email fails with the message “The username or password is incorrect”. In the configuration of this action, I am using what I believe is the correct Gmail SMTP server, the correct SMTP port (587) with the checkbox for “Transport Layer Security” (TLS) checked, and the correct Gmail username (Gmail email address) and correct Google account password. In doing multiple Google and Baserow Community Forum searches, I have not been able to resolve this issue. Some Google search results indicated that two-factor authentication needed to be turned on for this to work, so I tried that, and no difference. Thank you!

Please attach screenshots or videos if they help illustrate your question.

ScreenshotOfBaserowAutomation_SendEmailOnNewRecord.jpg
ScreenshotOfBaserowAutomation_SendEmailOnNewRecord.jpg445×372 14.6 KB

2

hi @SpaceTimeConverter - In additional to enabling 2-factor authentication, you also need to create an App Password. Using your normal sign-in password will not work.

Here are the steps you should follow (you can skip step 1 if you’re sure 2-factor is set up correctly):

  1. Enable 2-factor: Google Account Security
  2. Create an App Password: https://myaccount.google.com/apppasswords

Then, instead of your normal password, use the new App Password in the SMTP settings (all other settings remain the same).

Note that if you’re using a Google Workspace account, your admin will need to allow “Less secure apps”. Otherwise, the steps above should definitely work for you.

3

Thank you for this information. I had previously tried the 2-factor authentication, but had not created the app password. When I did both, everything worked. Thanks!!!

4

No worries @SpaceTimeConverter , I’m glad it’s working for you now!