Google Sheets Add-on Performance

Options
janako
janako Member, ALL USERS, Partner, Certified Model Builder Posts: 2 New Contributor
in Extensibility

Hello,

 

We would like to use the Google Sheets Add-On, but face the problem that every step, including the refreshing and sending of data to and from Anaplan is very slow and time consuming.

 

Using the Add-on in a new empty sheet works faster, but the client works in several Google sheets with multiple sheets/tables/calculations and needs to wait a few minutes which makes it difficult to work with.

 

Are there ideas or best practices, what we could do to improve the performance of the Add-On?

 

Thanks in advance,

Jana

Tagged:

Comments

  • janako
    janako Member, ALL USERS, Partner, Certified Model Builder Posts: 2 New Contributor

    Hi,


    Our Anaplan module is quite small - 98,400 cells.

    Directly inputting into Anaplan is possible without any time delay. Only syncing with Google sheets takes several minutes. Therefore, we are now manually copy-pasting the values from Google sheets into Anaplan, which is not most elegant, but faster than syncronization.

    I have noticed, when the Google sheet has less pages than has less latency.

     

    Thanks you.

  • fxlepoutre
    fxlepoutre Member, ALL USERS, GroupMember, Community Member Posts: 5 Contributor

    Hello, 

    Exactly the same issue here. 

    From a blank GSheet, performance is acceptable (but really not good). From an existing GSheet with several existing tabs, performance is desastrous, up to the point where update is not possible because it times out.

    This happens whatever the model, module, view, cell count, etc...

    I have tried for more than one year now, and have made videos to explain the issue to Anaplan support, without any resolution yet.

    I hope this extension will improve so that we can put it in the hands of end users. Not yet possible with these performance issues.

    Thanks for raising the topic yet!

    Good day! 

  • hrazak
    hrazak Member, ALL USERS, Certified Model Builder Posts: 1 New Contributor
    Hello,

    We are experiencing a similar issue as well. The synchronization takes a really long time, especially in sheets with multiple tabs.

    Really hoping Anaplan can look into this issue so users can finally leverage this capability as it is not usable at this current stage

    Thanks!

Categories