Dust Community Icon
Join the Community
Help

Troubleshooting Gdrive Gsheet Integration with Knowledge Base

Avatar of Pauline Guillonnet-LopezPauline Guillonnet-Lopez
·
·

Hello Remi, it's me again 👀 I connected my Gdrive on my knowledge base, and i can see the Gsheet well synchronized in my knowledge base. Yet I can't see/add my gsheet via a Query Tables as a tool for my agent Checked previous help message here/dustt documentation, but i c'ant manage to understand why it's not working! Would love a little help, thanks! 🙏

9 comments

  • Avatar of Pauline Guillonnet-Lopez
    Pauline Guillonnet-Lopez
    ·
    ·
  • Avatar of Abboud Hammour
    Abboud Hammour
    ·
    ·

    Hi Pauline Guillonnet-Lopez! For Tables to be accessible by table query they have to have a pretty standard format of:

    • Header row

    • Columns & Rows

    Without empty spaces, other titles, so just a clear table. Just to test something, do you mind adding a tab to your sheet with a very basic table (like in the screenshot I shared), to see if it pops up

  • Avatar of Pauline Guillonnet-Lopez
    Pauline Guillonnet-Lopez
    ·
    ·

    Hello Abboud Hammour thanks for your answer, i created a new sheet yet still not appreaing when i triy to connect it

  • Avatar of Abboud Hammour
    Abboud Hammour
    ·
    ·

    Hmm ok might be an issue then. Let me check with the team then, will try and get an answer as soon as I can!

  • Avatar of Pauline Guillonnet-Lopez
    Pauline Guillonnet-Lopez
    ·
    ·

    thankkkk u verymuch

  • Avatar of Abboud Hammour
    Abboud Hammour
    ·
    ·

    Hi Pauline Guillonnet-Lopez! Just a head's up that the team is a little backed up right now so may take a little bit to dig into this, but it's on my radar and I'll get back when we know more!

  • Avatar of Pauline Guillonnet-Lopez
    Pauline Guillonnet-Lopez
    ·
    ·

    Thanks let me know ! I put this agent on hold :)

  • Avatar of Stanislas Polu
    Stanislas Polu
    ·
    ·

    Hi Pauline Guillonnet-Lopez the reason why you're not seeing it is because you haven't added any "Google Drive" data to Company Data yet. The data is properly syncrhonized in connection admin but now you want to select what you want tot make available to your workspace by adding it to Company Data (just go there in Knownedge and click "Add Data" and then select "Connected Data" 👍

  • Avatar of Pauline Guillonnet-Lopez
    Pauline Guillonnet-Lopez
    ·
    ·

    thanks! it worked, yet, just to let you/someone who would be reaidng, first the agent told me it couldn't have access/permissions Then asking me the direction of the file, he managed to find the file and have access to it