Table of Contents
Integrate your chatbot with Google sheets to record all user inputs (variables) in a Google sheet.
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 Crednetials and select OAuth Client iD
- Download OAuth client JSON






















Upload Google Application Token to your Promptchat Server


Add your Google Account
Log out of the Server Admin area and log in to your Promptchat account as an end user.
