Unable to store user details in google sheet

Hi.

I want store the user details in google sheets from chatbot. For that i have created the custom action and google credential and i have mentioned in actions file, but i am getting error actions.py (3.9 KB) gdrive_service.py (2.2 KB)

error while runing actions.py file (tensorflow) C:\Users\karthik\Desktop\chat>rasa run actions 2020-02-10 22:16:21 INFO rasa_sdk.endpoint - Starting action endpoint server… 2020-02-10 22:16:21 INFO rasa_sdk.executor - Registered function for ‘action_store_entity_extractor’. 2020-02-10 22:16:21 INFO rasa_sdk.executor - Registered function for ‘store_form’. Exception occurred while handling uri: ‘http://localhost:5055/webhook’ Traceback (most recent call last): File “C:\Users\karthik\Desktop\chat\actions.py”, line 123, in submit gdrive = GDriveService() File “C:\Users\karthik\Desktop\chat\gdrive_service.py”, line 36, in init f.name, scopes=scopes File “c:\users\karthik\appdata\local\continuum\anaconda3\envs\tensorflow\lib\site-packages\oauth2client\service_account.py”, line 219, in from_json_keyfile_name with open(filename, ‘r’) as file_obj: PermissionError: [Errno 13] Permission denied: ‘C:\Users\karthik\AppData\Local\Temp\tmpdhvjor38credential.json’

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File “c:\users\karthik\appdata\local\continuum\anaconda3\envs\tensorflow\lib\site-packages\sanic\app.py”, line 942, in handle_request response = await response File “c:\users\karthik\appdata\local\continuum\anaconda3\envs\tensorflow\lib\site-packages\rasa_sdk\endpoint.py”, line 86, in webhook result = await executor.run(action_call) File “c:\users\karthik\appdata\local\continuum\anaconda3\envs\tensorflow\lib\site-packages\rasa_sdk\executor.py”, line 278, in run events = await action(dispatcher, tracker, domain) File “c:\users\karthik\appdata\local\continuum\anaconda3\envs\tensorflow\lib\site-packages\rasa_sdk\forms.py”, line 548, in run events.extend(self.submit(dispatcher, temp_tracker, domain)) File “C:\Users\karthik\Desktop\chat\actions.py”, line 129, in submit “Failed to write data to gdocs. Error: {}” “”.format(e.message), AttributeError: ‘PermissionError’ object has no attribute ‘message’ Exception occurred while handling uri: ‘http://localhost:5055/webhook’ Traceback (most recent call last): File “C:\Users\karthik\Desktop\chat\actions.py”, line 123, in submit gdrive = GDriveService() File “C:\Users\karthik\Desktop\chat\gdrive_service.py”, line 36, in init f.name, scopes=scopes File “c:\users\karthik\appdata\local\continuum\anaconda3\envs\tensorflow\lib\site-packages\oauth2client\service_account.py”, line 219, in from_json_keyfile_name with open(filename, ‘r’) as file_obj: PermissionError: [Errno 13] Permission denied: ‘C:\Users\karthik\AppData\Local\Temp\tmpebffpywwcredential.json’

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File “c:\users\karthik\appdata\local\continuum\anaconda3\envs\tensorflow\lib\site-packages\sanic\app.py”, line 942, in handle_request response = await response File “c:\users\karthik\appdata\local\continuum\anaconda3\envs\tensorflow\lib\site-packages\rasa_sdk\endpoint.py”, line 86, in webhook result = await executor.run(action_call) File “c:\users\karthik\appdata\local\continuum\anaconda3\envs\tensorflow\lib\site-packages\rasa_sdk\executor.py”, line 278, in run events = await action(dispatcher, tracker, domain) File “c:\users\karthik\appdata\local\continuum\anaconda3\envs\tensorflow\lib\site-packages\rasa_sdk\forms.py”, line 548, in run events.extend(self.submit(dispatcher, temp_tracker, domain)) File “C:\Users\karthik\Desktop\chat\actions.py”, line 129, in submit “Failed to write data to gdocs. Error: {}” “”.format(e.message), AttributeError: ‘PermissionError’ object has no attribute 'message’out1.txt (21.0 KB)

Can you please format your stacktrace? :pray: