How can I automate copying new rows of a sheet from smartsheet to sharepoint list or excel online?

JM Caballes

Since there are no options to change the "reply-to" email for alerts/reminders, I am looking into using MS Flow to do the automated reminders. However, it seems like I don't have an option to directly get the cell details from smartsheet to MS Flow so I first need to copy the new rows from smartsheet to excel online or lists and then setup the automated email reminders.

Bassam Khalil

Hi @JM Caballes

Hope you are fine, i think if you used Smartsheet Live Data Connector you can connect you sheet in smartsheet to Excel Queries and any update in smartsheet will reflected directly in your excel file as soon you refresh your Queries, please read the following article about how to setup and use Smartsheet Live Data Connector and i hope it will help you:

https://help.smartsheet.com/learning-track/integrations-and-add-ons/live-data-connector

Bassam Khalil

Hi @JM Caballes

Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

JM Caballes

Hi @Bassam.M Khalil. We are currently on a business plan and I don't think we have a Live Data Connector. I'd like to explore alternatives. Thanks for your reply.