Hello I am looking for a little help getting my bot to write form slots to a google sheet. First let me caveat that I am not a developer and I have minimal experience with python. Anyway I have created a bot with rasa 2.0 and I copied some code from the rasa demo bot ‘Sara’ on git hub. I am trying to recreate having users sign up for a newsletter by giving their name and email address.
I have a simple form that gets activated using rule policy and the slots are being filled, but I am stuck getting that info passed on to the sheet. I assume somewhere there needs to be credentials and an api key called but I have no idea where to add these. Perhaps in the gdrive_service.py? I know in the rasa for beginners udemy course there was and .env file with the credentials for Air Table but there does not seem to be an equivalent .env for the Sara bot, and that was using rasa 1.1 verses Sara that is 2.0.
The bot does respond as expected but nothing of course at the moment gets sent to google drive. I have created an api key for google sheets* in the google developers console but I am not sure where to implement or go from here. (*Or does this need to be a google drive api ??)
The only error I get is in the terminal running rasa actions:
UserWarning: Cannot validate
If anyone can point me in the right direction I would be grateful. Thanks.