Sheet1

Remove a Worksheet from a Google Sheet Document

Update call values of rows in a Worksheet

The Google Sheets component authenticates requests through Google's OAuth service.
To create a Google Sheets developer account and authenticate using Google OAuth, follow directions [here](https://developers.google.com/sheets/api/quickstart/quickstarts-overview?hl=en)
Now, you will have to configure OAuth 2.0 settings in Prismatic.
Create a new Google Sheets connection.

-   For **Client ID** and **Client Secret** enter the values that you got from the Google Cloud Platform auth settings.
-   For **Scopes** choose from the list found on the [Google docs](https://developers.google.com/identity/protocols/oauth2/scopes)


Create, read, and modify Google Spreadsheets

[Google Sheets](https://www.google.com/sheets/about/) is Google's spreadsheet service.
This component allows you to create, read, and modify spreadsheets stored in a Google Drive Account.


Action Name	Action Description
Add Worksheet	Add a new Worksheet to a Google Sheet Document
Append Rows	Append new rows to a Worksheet
Clear Worksheet	Clear all data in the a Worksheet
Create Spreadsheet	Create a new Google Sheet Document
List Rows	List the cell values of rows in a Worksheet
List Columns	Get the headers of a Worksheet
List Worksheets	List information about all Worksheets in a Google Sheet Document
Remove Worksheet	Remove a Worksheet from a Google Sheet Document
Set Header Row	Set the column headings in a Worksheet
Update Rows	Update call values of rows in a Worksheet
Raw Request	Send raw HTTP request to Google Sheets

Google Sheets Connector

Integrate with customers’ other SaaS apps, fast

About the Google Sheets Connector

Actions

Triggers

Ready to get started?