Importing Google Finance Data into Smartsheet?

07/03/18 Edited 12/09/19

Hi all,

I'm attempting to pull Google Finance Data for monitoring stock price movements and creating charts for projected outcomes, etc. 

I'm not sure if Google Finance data is natively supported or not. I did attempt to import an existing Google Sheets spreadsheet with some formulas in it but receive an "#UNPARSEABLE" error for any formulas imported into Smartsheet.

Any tips or advice for achieving this would be greatly appreciated!


  • Hi we got round this challenge using the Smartsheet API connected to a 3rd party Finance data provider eg Google or other.


  • Richard Rymill SBPRichard Rymill SBP ✭✭✭✭✭


    This is something I have wanted to set up to monitor some minor shares I have in our Investment club but too busy looking after clients needs to spend time on it, so please persist with this, i'd be interested to know how you get on? 


  • Andrée StaråAndrée Starå ✭✭✭✭✭


    Smartsheet just released a new add-on called Data Uploader that could be an option for you.

    Please see the attached link/screenshot for more information.

    I hope this helps you!


    Andrée Starå

    Workflow Consultant @ Get Done Consulting


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.