Send data from Domo to google sheets

Options
phongtruong
phongtruong Member
in Archive

Hello guys,

 

This may seem counter-intuitive, but I'm looking for a way to send data from Domo to google sheets automatically. Have anyone had experience with it?

 

Thank you in advance!

Comments

  • Property_Ninja
    Property_Ninja Contributor
    Options

    Hello phongtruong,

     

    Domo is very good at ingesting information but currently does not support a way to send information out to google sheets. The only way to do this would be to use the domo package in R to ship data from Domo to R then use the google sheets package in R to send that data to google sheets.

     

    https://github.com/domoinc-r/DomoR

     

    https://cran.r-project.org/web/packages/googlesheets/vignettes/basic-usage.html

     

    Hope this helps,

     

    Brian


    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.
  • phongtruong
    phongtruong Member
    Options

    Hello Brian,

     

    Thank you very much for your response. This definitely pointed me to the right direction.

    On more details, I was able to import the dataset to R. However, the reupload using googlesheet package is slow, with reasons maybe due to the size of the data. I'm exploring other alternatives (Excel + Sharedrive) for this and will update the community with the results.

     

    Best regards,

    Phong

Categories