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) site. Details regarding their API limitations can be found here.

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 The next page asks you for your 'Service Permissions'. Set as appropriate for your project scopes and click Create authentication. google-sheets-popup On the new dialog box, click Allow if you wish to permit Tray.io to access your Google Account. google-sheets-auth-3 1

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.