Code Generation for APIs
Program the world. Generate code in less than 10 minutes.
This feature isn't available on your account.
Want to account?
Back to Kosmos

Choreos

Public
Private

You have no favorites... yet!

Your Private APIs Here

Enable digital transformation at your organization.

Learn More

Library . Google . Sheets

The Google Sheets API (version 4.0) allows you to read and modify any aspect of a spreadsheet from your application.

  • Setup Instructions

    • To use these Choreos:

      • You'll need a Google account. If you don't already have one, you can sign up here.
      • Login to Google's Developer Console, and create a new Project if you haven't done so already.
      • Using the API Manager, make sure you've enabled API Access for the Google Sheets API in the Library tab.
      • Under the Credentials tab, create a new OAuth Client ID and specify Web application for the Application Type.
      • Specify this callback URL as the Authorized Redirect URI:
      https://{Your Temboo Account Name}.temboolive.com/callback/google
      • When configuring the Consent Screen, make sure you fill out the Email Address and Product Name fields.
      • Run the Google > OAuth > InitializeOAuth Choreo, specifying the Client ID from the app you registered at Google and the following Scope values:
      https://www.googleapis.com/auth/spreadsheets
https://www.googleapis.com/auth/drive
https://www.googleapis.com/auth/spreadsheets.readonly
https://www.googleapis.com/auth/drive.readonly
      • Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click "Accept" to grant the app access to your Google account.
      • Run the Google > OAuth > FinalizeOAuth Choreo, specifying the callback ID returned earlier by the InitializeOAuth Choreo. This process will return a Refresh Token which can be used along with the Client ID and Client Secret to authenticate with Google.

      This short video demonstrates how to use our OAuth Choreos, and it's a good idea to take a break and watch it now before you dive into this step.

  • Related Links
  • Choreos

    • Google.Sheets.AppendValues

      Appends values to a spreadsheet.

    • Google.Sheets.BatchGetValues

      Returns one or more ranges of values from a spreadsheet.

    • Google.Sheets.BatchUpdateValues

      Updates values in one or more ranges of a spreadsheet.

    • Google.Sheets.ClearValues

      Clears values from a spreadsheet.

    • Google.Sheets.CopyToSheet

      Copies a single sheet from a spreadsheet to another spreadsheet.

    • Google.Sheets.CreateSpreadsheet

      Creates a spreadsheet.

    • Google.Sheets.GetLastRow

      Returns the last row in a sheet.

    • Google.Sheets.GetSpreadsheet

      Returns the spreadsheet at the given ID.

    • Google.Sheets.GetValues

      Returns a range of values from a spreadsheet.

    • Google.Sheets.UpdateValues

      Updates values in the specified range of a spreadsheet.

    • Welcome to Temboo
    Program the world. Generate code in less than 10 minutes.
    What type of code would you like to generate?
    Arduino
    Texas Instruments
    Samsung
    C#
    Java
    JavaScript
    Node.js
    PHP
    Processing
    Python
    REST API
    Ruby
    iOS
    Android