I wrote a blog post about creating a custom formula function in Google Sheets that lets me ask an "AI", about data in the spreadsheet. [1] eg:
`=spits("get the website and primary phone number for each of the following organization names: ", A1:A300)`
Where cells A1:A300 contains a list of organizations I want the website and primary phone number for.
There are other uses cases for B2B Lead Gen, Data Quality, etc and personal use cases like getting ideas for stock portfolio and personal budgeting.
#GoogleSheets #GoogleGemini #AI #LLM #Spreadsheets
[1] https://www.isaacwyatt.com/posts/2025-03-07/