Dec '24 • Tips & Hacks
Assistant for reading live Google sheets
Hey automation folks!
Just got back from Xmas with the inlaws. Perfect moment to chill down and work on a project 😁
I need some help with understanding how I could best achieve what I want. JarvisJr got me thinking about all the options..
**Current Setup:**
- Google Sheet with booking data for 3 rental properties
- Data includes bookings, guest info, dates, pricing
- Currently using Claude for analysis (works great with the Excel/CSV data when uploaded)
**Goal:**
I want to be able to ask simple questions like:
- "Who's staying at property X on date Y?"
- "What's the next available 6-day period?"
- "Output the top 3 bookings for the last quarter in property X, in a table format"
And have the AI analyze real-time data from my Google Sheet
**Requirements:**
- Must read live data from Google Sheets
- Ideally accessible via chat (e.g., Telegram, like JarvisJr)
- Should work with an LLM (Claude/GPT) for natural language processing
**Current Thoughts:**
- Make/Zapier for the Google Sheets connection
- Some kind of API middleware
- Maybe Airtable as an intermediate database?
I already simply tested downloading it as xlsx, feeding that document to Claude, and asking the example questions. This worked perfectly.
Would love to hear your experiences and suggestions! Has anyone built something similar? Any pitfalls to avoid?
2
2 comments
Assistant for reading live Google sheets
powered by
skool.com/ai-productivity-hub-free-9946
Community for everyday AI users leveling up their game and sharing powerful tips & hacks with one another.
Suggested communities
Powered by