Image Analysis Tab Settings in SheetXAI
Overview
The Image Analysis tab in SheetXAI settings configures the AI model specifically used for processing and analyzing images within SAI formulas. This specialized setting enables your spreadsheet to understand and generate content based on image data.
Key Information
Purpose
The Image Analysis tab determines which vision-capable AI model will process your image-related requests in SAI formulas. This allows SheetXAI to "see" and analyze images directly from your spreadsheet.
Recommended Model
We highly recommend using OpenAI's GPT-4o-mini for image analysis. This model provides:
- Excellent image understanding capabilities
- Faster processing time than larger models
- Lower cost per request
- Reliable performance across various image types
How to Use Image Analysis in Formulas
To activate the Image Analysis model in any SAI formula, you must:
- Start your formula instruction with the keyword IMAGE
- Include a direct image URL in your request
Example Formula:
=SAI("IMAGE Describe what you see in this image: https://example.com/image.jpg")
Important: The Image Analysis model is only triggered when both conditions are met - your instruction starts with "IMAGE" and contains a valid image URL (which can be from a cell reference).
Direct vs. Non-Direct Image URLs
For the Image Analysis feature to work properly, you must use direct image URLs that point specifically to the image file itself.
Examples of Direct Image URLs (Will Work):
- https://example.com/image.jpg
- https://storage.googleapis.com/my-bucket/product-photo.png
- https://cdn.website.com/images/chart.webp
Examples of Non-Direct URLs (Won't Work):
- https://example.com/gallery (webpage containing images, not the image itself)
- https://drive.google.com/file/d/1234567890/view (sharing link, not direct file)
- https://photos.app.goo.gl/abcdefg (album or sharing link)
Tip: To get a direct image URL, right-click an image online and select "Copy image address" or "Copy image link" (the exact wording depends on your browser).
Use Cases for Image Analysis
- Describing product images in inventory spreadsheets
- Analyzing charts or graphs from external sources
- Extracting text from screenshots or diagrams
- Identifying objects, scenes, or people in images
- Creating content based on visual information
How to Configure
- Navigate to the Settings section in the SheetXAI sidebar
- Select the Image Analysis tab
- Choose your preferred AI provider with vision capabilities
- Select GPT-4o-mini (recommended) or another vision-capable model
- Ensure your API key is properly configured for the selected provider
- Click Save to apply your changes
Tips for Effective Image Analysis
- Use direct image URLs that don't require authentication
- Ensure images are clearly visible and properly lit
- Be specific in your instructions about what you want analyzed
- For best results, use JPG, PNG, or WebP image formats
- Larger or more complex images may take longer to process
With the Image Analysis feature properly configured, you can seamlessly integrate visual data analysis directly into your spreadsheet workflows.