While google sheets is super easy for prototyping, the 1000 rows limitation would clearly come up quickly for a bot with loads of users.
I see that there are a couple of other integrated platforms to store and retrieve data. I have found MySQL &
Knack. Maybe I missed one?
Has anyone done a data migration, or launched a bot using either of these services? I’d like to have a community discussion about pros and cons, issues, and best practices for building a scalable bot.
We are planning a few things in this area. We are going to be refactoring this integration and removing the 1000 row limit as a primary goal in the near future (but not this year).
We’re also thinking about making it easier to access a ‘database’ of subscribers along with the attributes set against them. That way, for a lot of use cases, you’ll be able to use attributes directly without any external service.
Bear in mind that the 1000 row limit doesn’t apply to simply adding rows to a sheet, just updating/searching.
There’s also a product https://sheetsu.com/ that I’ve heard of (but not used) which may allow you to use Google Sheets directly with our webhook method.
Thanks for the information John!
Sheetsu might be useful to push bot user information into my wordpress website!
Thanks,
Kurt