# Google Sheets

Send and retrieve data from Google Sheets.

## Overview

The Google Sheets connector allows you to send & retrieve data from any of the Google Sheets available within your account.

### API Information

The Google Sheets connector has the following Base URL: **<https://sheets.googleapis.com/v4>**. More information can be found on their main [API documentation (v4)](https://developers.google.com/sheets/api/reference/rest) site. Details regarding their API limitations can be found [here](https://developers.google.com/sheets/api/limits).

### Google Sheets Templates

### Authentication

When using the Google sheets connector for the first time, you need to create a new authentication.
Name your authentication and specify the type ('Personal' or 'Organizational').
![google-sheets](https://tray.ai/documentation/images/connectors/service/google-sheets/95beddf2-221c6d82_google-sheets-auth-1%201.png)
The next page asks you for your 'Service Permissions'. Set as appropriate for your project scopes and click **Create** **authentication**.
![google-sheets-popup](https://tray.ai/documentation/images/connectors/service/google-sheets/95beddf2-7a71e3b1_google-sheets-auth-2.png)
On the new dialog box, click **Allow** if you wish to permit Tray.io to access your Google Account.
![google-sheets-auth-3 1](https://tray.ai/documentation/images/connectors/service/google-sheets/5a4R42PxuNFAGscoc7ZYwg_google-sheets-auth-3%201.png)

Go back to your settings authentication field (within the workflow builder properties panel), and select the recently added authentication from the available dropdown options .
Your connector authentication setup is now complete.