Integrate your chatbot with Google sheets to record all user inputs (variables) in a Google sheet.
This part of the guide is for Promptchat server administrators (not end users)
Create a new project on Console.cloud.google.com
- Log in to your Google account on https://console.cloud.google.com
- Click on APIs & Services
- Create a New Project
- Enable APSs and Services (Google Sheets API and Google Drive API)
- Click on Credentials and select OAuth client ID
- Configure External OAuth screen
- Enter App info for Consent screen
- Enter (pre-register) the authorized domain
- Add scopes (Google Drive API and Google Sheets API)
- Add User(s)
- Back to Credentials and select OAuth Client iD
- Download OAuth client JSON
Now that you have your Web App Go to your Promptchat server's settings
Upload the Google Application Token to your Promptchat Server
Congrats! Your chat server is now ready to record user input (variables) into Google Sheets
Add your Google Account
Log out of the Server Admin area and log in to your Promptchat account as an end user.
