Just read
Create once
Read + write
Claude & Perplexity — native Drive connectors
A
B
1
Item
Amount
2
Coffee
4.5
3
Lunch
12
4
Parking
8
5
Total
—
Same Drive-file connection — one shot only
A
B
1
Item
Amount
2
Coffee
4.5
3
Lunch
12
4
Parking
8
5
Total
24.5
Composio (any AI), and Gemini natively in Sheets
A
B
1
Item
Amount
2
Coffee
3
Lunch
4
Parking
5
Total
24.5
B5: =SUM(B2:B4) — edit any amount above, the total recomputes live
Real numbers from a live test — Composio wrote this exact formula into a real Google Sheet and read back 24.5.