Can I populate Smartsheet rows from a SQL Database read?

05/22/20
Answered - Pending Review

I have data on Snowflake data warehouse and also on a SQL server table. Does Smartsheet support connection to Snowflake or SQL database to read data and populate rows on a Smartsheet?

Answers

  • edited 05/22/20

    Hello @Senthil Anandarangan

    Although there is no dedicated integration with SQL, you can use the ODBC connector to communicate with Smartsheet.

    See more on this here: http://smartsheet-platform.github.io/odbc-docs/#overview

    You can raise an Enhancement Request on the right hand side for other integrations you'd like to see within Smartsheet 😀

    Kindest Regards

    Sean

  • Hi Sean

    Thanks for your response. I am looking for WRITE into the Smartsheet. From the link it looks like ODBC connector supports only READ from the Smartsheet. Is WRITE from SQL to SmartSheet possible by using Smartsheet DataUploader?

  • Hello @Senthil Anandarangan

    Apologies for the delay in response.

    Data Uploader is it's on application for adding data into sheets, from a source E.G Excel sheets.

    Contrary to this, you may be able to achieve this with the 3rd party application Zapier

    Kindest Regards

    Sean

  • edited 09/02/21

    @Sean Morgan , @Senthil Anandarangan

    Hope you guys are doing well !!!

    I am new to smart sheet and want to establish Smartsheet and SQL connection.

    Can you let me know how can I do that.

    In addition to that.. I have setup ODBC connection as well.. but not sure how to process further.


    Thanks & Regards,

    Ibrahim Shaikh

  • Hi,


    We've build several tools and solutions to sync data from/to SqlServer and MySql with smartsheet.

    As an example we can read a table or view, and automaticly insert/update smartsheet rows based on a custom mapping.

    If you would like to know more, please contact @Richard Rymill SBP or me for more details.


    Etienne

  • Richard Rymill SBPRichard Rymill SBP ✭✭✭✭✭

    @Senthil Anandarangan

    As Smartsheet Integration partners of some 12 years experience, we can certainly resolve your needs for you. We offer a free initial consultation. Please let me know a good time to meet?

    Richard Rymill

    CEO SmarterBusinessprocesses.com

    ps Etienne is our Development manager.

Sign In or Register to comment.