Smartsheet is an enterprise work management platform that lets users manage projects, programs and processes at scale using sheets, channels, and workspaces. You can connect your Smartsheet instance to Amazon Q Business—using either the AWS Management Console, CLI, or the CreateDataSource API—and create an Amazon Q Business web experience.
Integrating Smartsheet as a data source in Amazon Q Business enables users to quickly get insights from project sheets. For example, users can ask questions like:
-
"Which project manager is responsible for Project Harpo?", where the answer comes from a Smartsheet row
-
"What are the requirements for the Create APIs task?", where the answer is fetched from a PDF attached to the row for Create APIs
-
"Who is the owner of the Individual Task Management workspace?", where the answer comes from workspace metadata
With the Amazon Q Business Smartsheet connector, you can solve the following kinds of use cases.
-
Project status updates – Get quick insights into project health without having to open Smartsheet with questions like:
-
"What's the status of the website redesign project?"
-
"Is the mobile app launch on track for the planned date?"
-
"Which projects are currently behind schedule in the Q3 Roadmap sheet?"
-
-
Task management – Find information about tasks and action items with questions like:
-
"What tasks are assigned to Mary Major?"
-
"Has the marketing plan document been completed?"
-
"What's the due date for the customer research presentation?"
-
The Amazon Q Business Smartsheet connector understands user access permissions and strictly enforces them at the time of the query. This ensures that users aren't able to see content they don't have access to.
Note
We recommend enabling Cross-region inference for Amazon Q Business for your Amazon Q Business application connector to get the best customer experience with improved query response accuracy.
Topics
Learn more
-
For an overview of the Amazon Q web experience creation process using IAM Identity Center, see Configuring an application using IAM Identity Center.
-
For an overview of the Amazon Q web experience creation process using AWS Identity and Access Management, see Configuring an application using IAM.
-
For an overview of connector features, see Data source connector concepts.
-
For information about connector configuration best practices, see Connector configuration best practices.
Known limitations for the
Smartsheet connector
The Smartsheet connector has the following known limitations:
-
If you remove users’ access to a Smartsheet data source but not to Amazon Q Business, they will be able to receive responses from the data source when they query Amazon Q Business.
-
The Smartsheet connector will provide responses from the most applicable single sheet. That is, it will search across all sheets and find the sheet with the most relevant answer and provide that instead of aggregating data across multiple sheets. For example, it can't answer questions like: "Show me tasks that are past due across all my sheets."
-
For hierarchical sheets, Amazon Q Business accuracy can drop when queries are directly related to the hierarchical structure.
For example, if a sheet has hierarchical structure about high-level tasks and its subtasks, and a user asks "What's the amount of time needed to finish all tasks?" then Amazon Q Business might add up all times assigned to both high-level tasks and the sub-tasks. This calculation is wrong as the amount of time to finish the high-level task is just a sum up of the sub-tasks.
However, if the user asks a query such as "How many tasks are assigned to Mary Major?", they would get an accurate response.
-
For sheets with similar names—(for example, “Blockchain Integration - Project Plan” and “Blockchain Integration - Impact Tracker”)—if a query mentions just “Blockchain Integration” then you might not get an accurate response. To get accurate responses, we recommend:
-
providing clearer titles/descriptions of the sheets, or
-
providing more detailed questions to reduce ambiguity.
-
