Google Sheets

πŸ“˜

This tool uses personal credentials.

This tool interact with Google Sheets using the user accounts: it adapts to each user.

Admin: Setup in Dust

Go to Spaces > Administration > Tools in your Dust workspace, click Add Tools, and select Google Sheets.

You will then be redirected to an oAuth flow to connect an admin Google Sheets Account. This account only be used during the set up and users won't be able to query Google Sheets from this account.

By default this tool is added to the Company data Space, so accessible in all the workspace.

Usage

Once the tool has been configured by the admin as described before, it can be configured for any agent. In the Agent Builder, simply click on Add Tool and select Google Sheets.

When users use an agent with the Google Sheets tool for the first time, they will get this notification:

They will have to click on the Connect button to connect their own Google Calendar credentials. After it will look like this:

And they can click on the Retry button to replay the agent answer if not done automatically.