Does anyone know of a straightforward method to utilize Google Sheets for storing leads gathered from the bot? I've viewed several videos, but many suggest using either Make or Zapier. However, I prefer not to introduce a middle layer dependency into this beta project. Additionally, scaling up the bot for reuse multiple clients could potentially become cumbersome with numerous hooks involved.

Hey, I have used Make a couple of times, and I really like it as it's so easy. Devmik has a lot of tutorials about using Make https://discord.com/channels/1108396290624213082/1194161232052244521 Google Sheet does have an API, which you could look into using https://developers.google.com/sheets/api/guides/concepts

if you're looking for something reliable and without dependencies might I suggest using our built-in Tables feature 👀

Thanks for inputs but as I mentioned I don't want a 3rd party in the middle and most if the other bot building platforms I have tested this is easily accomplished within minutes no third-party and no code. The sheets is great I think for KB and others things but for this use case this lead collection would go to an external Google sheets in real time to a group of individuals could pick up leads and use them. I don't want another account or subscription to manage. I already have enough of those including ChatGPT

You can use make.com for free