GOOGLE SHEETS INTEGRATION – SERVER ADMINS
Table of Contents
- Create a new project on Console.cloud.google.com
- Upload Google Application Token to your Promptchat Server
- Add your Google Account
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](https://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
- Publish
