Import Value from Googlesheet into Smartsheet Cell

Phil Parks

Hi

Does anyone know if its possible to read a value from a googlesheet and then import it in a smartsheet - like the importrange function in google?

Thanks

Darren Mullen

Phil,

Not with a formula in vanilla Smartsheet. If you have access to to the Smartsheet DataShuttle and DataMesh apps, then you can use those to do what you want, otherwise you could write your own script to do this over the Smartsheet API.

Darren Mullen

Phil,

Not with a formula in vanilla Smartsheet. If you have access to to the Smartsheet DataShuttle and DataMesh apps, then you can use those to do what you want, otherwise you could write your own script to do this over the Smartsheet API.