Gmail Smtp relay connection issues

  • Goal: Use google workspace gmail smtp relay service

  • Steps: added relay as smtp resource using smtp-relay.gmail.com and whitelisted 35.90.103.132/30 and 44.208.168.68/30 in workspace. Set override outbound region to us-west-2

  • Details: random failures on activations, when used in a workflow I had to enable retries, and the same query will eventually succeed. Rate is low, and I am using a sequential loop for the one bulk query, so no rate limit is being hit. I am using this same smtp-relay setup in other non-retool applications with no issues.

  • Screenshots: Testing connection in resource setup screen:

Hello @Peter_Kunz!

Super weird issue than the failures seem to be random. Also that you are using the same smtp-relay setup in non-Retool applications without getting this issue.

I was going to guess that we might need to check the logs from the google server to see if they are more information about the request that they are receiving from the Retool app :thinking:

That you for sending the screen shot as that is super helpful. It looks like that specific error in the image is from the resource running a test connection, correct?

Is there another error message in the workflow debugger for when the query to the smtp resource fails to run? Let me know if you notice any patterns that might be related to this bug.

Have you tried visiting the URL listed in the error log to see if there are details there? Also are you self-hosting Retool or running it on the Retool cloud?