Allow AI Access to Data

You can now choose to allow AI to access your data values. This enables:

• Better query suggestions based on your actual data
• More accurate data analysis recommendations
• Reduced chances of AI hallucinations

AI Query Assistant

The new AI query assistant helps you create queries without knowing the exact syntax:

1. Simply describe what you want to see in your dashboard
2. AI will suggest appropriate queries based on your description
3. Click on a suggested query to use it

Example: Type "Show me all users over 18 years old sorted by name" and the AI will generate the appropriate query for you.

To specify the cell range to import, use the following syntax:

Example: Users!A1:K

• This range will import all data from column A to column K of the "Users" sheet
• Make sure to include all necessary columns for your dashboard

You can now create queries in two ways:

1. Using AI Assistant (Recommended)

Simply describe what you want to see in plain English, and the AI will suggest appropriate queries. For example:

• "Show active users sorted by registration date"
• "Display sales above $1000 grouped by region"
• "List all products with low inventory"

2. Manual Query Writing

If you prefer, you can still write queries manually using the Google Sheets QUERY syntax:

For more information about query syntax, check the official documentation.