1 Reply Latest reply on Apr 14, 2018 7:50 PM by patrick.byrne.0

    Tablaeu Google sheets connection

    Chathura perera

      Dear All

       

      For research purposes  i used a google sheets which extracted  data from my countries central bank website into google sheets

      using the below formula

      =IMPORTHTML("https://www.cbsl.lk/eResearch/Modules/RD/SearchPages/CMB_LendingAndDeposit.aspx","table",0)

       

       

       

      then i  connected this into a workbook which updated incrementally all went well for a while

      now after a recent changes from the central bank end the formule i used to automatically paste the data into google sheets is no longer working

      pls advice on what is the best method to get this data into tableau