How to bulk-use AI in spreadsheets for fun and profit
About this event
Stanislas Marion is CEO of TalarianHQ, a company dedicated to creating simple, powerful tools for spreadsheet users. Join us for an insightful session where Stanislas will demo:
- How to leverage AI for bulk operations in spreadsheets
- Techniques for enriching your product catalog using AI
- Methods to clean up and optimize your database with AI assistance
- Strategies for conducting efficient market research using spreadsheets and AI
You'll learn practical ways to supercharge your spreadsheet workflows, whether you're managing product information, maintaining databases, or conducting market analysis. These techniques can save you time and improve the quality of your data-driven decisions.
Sign up below to catch this event. Recordings will be emailed to all those registered.
When
Recording
Resources
Overview of Talarian’s Products
- Products Presented:
- YAMM (Yet Another Mail Merge)
- Form Publisher
- Awesome Table
- GPT for Work: 4 extensions for Excel, Word, Sheets, and Docs
- Primary Focus:
- GPT for Work for repetitive tasks
- Excel and Sheets are most polished; Word and Docs are simpler
Key Features and Use Cases
- Bulk Processing:
- Translate in bulk (e.g., product catalogs for e-commerce)
- Up to 1,000 prompts per minute on Excel
- Up to 200,000 rows in Sheets
- Popular Use Cases:
- Translating product catalogs
- Creating SEO content or ad copy
- Categorizing product information
- Analyzing survey responses
- Advantages Over Competitors:
- No need for copy-pasting between tools
- Supports multiple AI models
- Extensive documentation and support
Demonstrations
- Translation:
- Example: Translate product descriptions from English to French
- Special features: Specific translation instructions, multiple variants
- Data Extraction:
- Extract structured data (e.g., weight, price) from unstructured text
- Custom prompts for specific output formats
- Custom Prompts:
- Generate product descriptions using metadata
- Multiple input columns can be referenced in prompts
- Web Search Tool:
- Fetch data (e.g., company URLs, descriptions) using Perplexity API
- Future improvements planned for better web scraping and data fetching
Security and Privacy
- Data Handling:
- Uses APIs from OpenAI, Anthropic, Gemini
- Data processed through Talarian’s backend on GCP
- ISO 27001 certified for data security
- User Concerns:
- Proprietary information remains secure
- No training of models on user data
Questions and Feedback
- User Queries:
- Concern about data privacy and proprietary information
- API calls and data refresh mechanisms
- Use of custom prompts for unique wording in descriptions
- Potential for advanced CRM analyses and finance use cases
- Future Enhancements:
- More web scraping capabilities
- Improved handling of input from multiple columns
- Reasoning columns for better transparency in AI decisions
Timestamps
00:00 Introduction to GPT for Work
00:31 Overview of GPT for Work Extensions
01:07 Demo: Using GPT for Excel
01:37 Popular Use Cases for GPT in Spreadsheets
02:11 Why Choose GPT for Work?
03:24 Live Q&A Session
04:15 Installing and Using GPT for Excel
06:05 Translating Product Descriptions
10:06 Extracting Data from Descriptions
13:44 Ensuring Data Privacy and Security
16:50 Custom Prompts for E-commerce Descriptions
23:10 Addressing Prompt Issues and Variants
24:00 Training Custom AI Assistants
24:41 Handling Large Scale Data
25:39 Introducing Perplexity API Tool
26:43 Fetching and Formatting Data
28:45 Limitations and Workarounds
31:49 Scoring and Grading Leads
39:28 Advanced CRM and Predictive Modeling
41:04 Using GPT for Work in Spreadsheets
42:45 Q&A Session
48:03 Conclusion and Farewell

