Intermittant Smartsheet Login Issues Using Power Automate

jsmoses3

We have setup a Power Automate RPA on a dedicated PC to run a series of repetitive steps which are triggered by a new row of data entering one of our smartsheets. The RPA has its own login credentials and access to all related smartsheet workspaces and folders that it needs to process the new entry. Over the last few days, we have been getting intermittant login failures which results in the RPA being locked out. It is entering the correct username and password. Has anyone experienced this or know what the root cause and resolution is? In advance, my thanks.

jmyzk_cloudsmart_jp

Hi @jsmoses3

Are you using an API connection to access Smartsheet, or is the RPA logging in with a username and password?

If the RPA enters login credentials manually, it might cause intermittent failures, especially if Smartsheet detects repeated logins and triggers security mechanisms. Power Automate’s Smartsheet connector typically uses OAuth authentication and webhooks to detect new rows, so logging in manually shouldn’t be necessary. (Smartsheet Connector Documentation)

I tested adding a comment to a row whenever a new row is added using the Smartsheet connector. I added twelve rows at once, which could have triggered a security issue due to multiple rapid actions if I were accessing Smartsheet by logging in with an ID and password. However, since I used the API, everything processed smoothly without any login problems.

If you’re using an API connection, you might want to check if the access token is expiring or if any rate limits are being hit. Could you clarify how the RPA authenticates and interacts with Smartsheet?

jsmoses3

Thank you so much for reaching out and providing assistance. It appears the issue was being caused by the RPA repetitively signing in and out of Smartsheet, resulting in the lockout. I think we are in a much more stable position at this point. Thanks again. Your response and suggestions were helpful and appreciated.

jmyzk_cloudsmart_jp

Hi @jsmoses3

Are you using an API connection to access Smartsheet, or is the RPA logging in with a username and password?

If the RPA enters login credentials manually, it might cause intermittent failures, especially if Smartsheet detects repeated logins and triggers security mechanisms. Power Automate’s Smartsheet connector typically uses OAuth authentication and webhooks to detect new rows, so logging in manually shouldn’t be necessary. (Smartsheet Connector Documentation)

I tested adding a comment to a row whenever a new row is added using the Smartsheet connector. I added twelve rows at once, which could have triggered a security issue due to multiple rapid actions if I were accessing Smartsheet by logging in with an ID and password. However, since I used the API, everything processed smoothly without any login problems.

If you’re using an API connection, you might want to check if the access token is expiring or if any rate limits are being hit. Could you clarify how the RPA authenticates and interacts with Smartsheet?

jsmoses3

Thank you so much for reaching out and providing assistance. It appears the issue was being caused by the RPA repetitively signing in and out of Smartsheet, resulting in the lockout. I think we are in a much more stable position at this point. Thanks again. Your response and suggestions were helpful and appreciated.