Cloud setup

If your Retool dashboard is located at https://username.retool.com, where username is your username, you're using cloud-hosted Retool.

1. Authorize access to your Google Sheets Account

See Cloud setup.

2. Querying Google Sheets for data

Follow our Google Sheets tutorial.

---

On-premise setup

1. Setup Google Login

You'll need to enable Google Login to connect Google Sheets. Docs.

2. Enable required services

Navigate to The Google Console and select your Retool project.

Search for the following three services, in the Library dashboard, and enable all of them:

• Google+ API
• Google Drive API
• Google Sheets API

3. Authorize access to your Google Sheets Account

Navigate to your settings page in Retool, and then press Add resource.

Select Google Sheets in the dropdown of integrations. Give it a name, and then press Authorize Google Sheets.

4. Querying Google Sheets for data

Follow our Google Sheets tutorial.