General
been using tinytable for a few weeks and trying to figure out when to use it vs google sheets. some observations:
tinytable wins when:
- the table needs to connect to forms or workflows (native integration)
- you need structured data with proper column types
- multiple people need different filtered views of the same data
- you want API access without google sheets API headaches
google sheets still wins when:
- you need complex formulas and pivot tables
- you want to share with external people who already know sheets
- you need charts and visualizations built in
anyone else have thoughts on this? not trying to replace sheets entirely, just figuring out the right boundary
pretty much agree with this breakdown. id add that tinytable also wins when you need proper access control. with google sheets its hard to let someone see some rows but not others. here you can have different views with different permissions
i still use sheets for quick ad-hoc analysis and charts but any structured operational data goes in tinytable now
the API headaches with google sheets are real. the 100 requests per 100 seconds limit killed our automated workflows constantly. with tinytable the table operations are native so no API quota issues
i still use google sheets for anything i need to share with clients. everyone knows sheets. for internal stuff tinytable all the way
biggest win for me was not having to worry about someone accidentally sorting a column and messing up the data. proper column types and structured data ftw