Stephen Robles logo

Stephen Robles

Stephen Robles Website
Stephen Robles Website

Documentation

What's New: Apple Intelligence in Shortcuts
Perplexity Comet Changed How I Use My Mac
Running My Entire Studio on Apple Shortcuts
The best ChatGPT prompts I use in my creator workflow
AirPods Pro Tips & New Features for iOS26
Visual Intelligence & Screenshot Shortcuts come together in iOS26
18 Advanced Shortcuts with Apple Intelligence
Shortcuts for AI Social Search, Personal Knowledge Base, Smart File Renaming)
What's New: 15 Hidden Apple Continuity Features
What's New: 7 Advanced HomeKit Automations
What's New in iOS 26 (Ringtones, Maps, Reminders)
Home/Perplexity Comet Changed How I Use My Mac
Stephen Robles logo

Stephen Robles

llms.txt
Stephen Robles logo

Stephen Robles

llms.txt
© 2026 Stephen Robles. All rights reserved.
Made withHinto AI

Deep dive into working with spreadsheets

Transform your browser into a powerful spreadsheet assistant. You can analyze data and generate formulas in applications like Google Sheets using simple, natural language commands. This feature eliminates the need to manually write complex formulas or perform calculations, allowing you to get insights from your data faster than ever.

What's new

The AI assistant is context-aware within spreadsheet applications. When you have a sheet open, you can ask the assistant questions directly about the data visible on your screen. The assistant can perform calculations on the fly, answer questions about the data, and even provide you with the exact formula you need to use in your spreadsheet. Simply copy data into your sheet, open the assistant, and start asking.

Documentation image

How to use this feature

  1. Open a spreadsheet with your data in the browser, such as Google Sheets.
  2. Open the Assistant sidebar.
  3. Ask a question in natural language, such as 'What is the average watch time based on this data?'.
  4. To get a formula, ask the assistant for it. For example: 'Give me a formula that calculates the sum total of watch hours from column B'.
  5. Copy the provided formula and paste it into the desired cell in your spreadsheet.
Documentation image

Key capabilities

  • Natural Language Queries: Analyze your data by asking questions in plain English instead of writing formulas.
  • Formula Generation: Instantly generate the correct formulas for common calculations like sums, averages, and more.
  • Quick Data Summarization: Get immediate answers and summaries from your data without leaving your spreadsheet tab.
  • Seamless Data Transfer: Extract data from other websites into a markdown table and paste it directly into your sheet for analysis.

Tips for getting the most out of this feature

For best results when asking for formulas, be specific by referencing column letters (e.g., 'sum of column C') or cell ranges. This helps the assistant provide the most accurate formula for your needs. You can also use the assistant to first extract data from a complex webpage into a structured table, then copy that table into your sheet to begin your analysis.

Summary

Working with spreadsheets is now faster and more intuitive. By leveraging the AI assistant to interpret data and generate formulas, you can reduce manual effort and focus on the insights your data provides. This feature is perfect for both spreadsheet experts who want to speed up their workflow and for those who need a little help performing calculations.

On this page