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 . Spreadsheets

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

  • Setup Instructions

    • Version 4.0 of the Google Sheets API is now available. We strongly recommend using the Google > Sheets Choreos which use the latest verson of the API.

      Version 3.0 (the version used by these Choreos), is documented for legacy purposes, and will eventually be deprecated.

      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 Drive API in the Library tab.
      • Under the Credentials tab, create a new Client ID and specify Web application for the Application Type.
      • When configuring the Consent Screen, make sure you fill out the Email Address and Product Name fields.
      • Save the Consent screen details. Specify this callback URL as the Authorized Redirect URI:
      https://{Your Temboo Account Name}.temboolive.com/callback/google
      https://spreadsheets.google.com/feeds/
      • 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.Spreadsheets.AddListRows

      Adds one or more rows to a worksheet in a Google spreadsheet using a simple XML file you provide.

    • Google.Spreadsheets.AddWorksheet

      Creates a new worksheet within an existing spreadsheet.

    • Google.Spreadsheets.AppendRow

      Appends a simple comma-separated row of data to a given Google Spreadsheet.

    • Google.Spreadsheets.DeleteListRow

      Deletes a specified worksheet row from a Google spreadsheet.

    • Google.Spreadsheets.DeleteRow

      Allows you to delete a specific row by its row number.

    • Google.Spreadsheets.DeleteWorksheet

      Deletes a specified worksheet from an existing spreadsheet.

    • Google.Spreadsheets.DownloadBase64EncodedSpreadsheet

      Downloads a document with the title you specify, and returns the content as Base64 encoded data.

    • Google.Spreadsheets.RetrieveCellFeed

      Retrieves a list of cell names and values in a specified Google worksheet.

    • Google.Spreadsheets.RetrieveCellList

      Retrieves a list of cell values using the specified cell locations.

    • Google.Spreadsheets.RetrieveCellValue

      Retrieves the value of given cell.

    • Google.Spreadsheets.RetrieveLastColumnValue

      Returns the value of the last cell in a specified column.

    • Google.Spreadsheets.RetrieveListFeed

      Retrieves a list-based feed containing data in your Google spreadsheet.

    • Google.Spreadsheets.RetrieveListRow

      Retrieves a specified worksheet row from a Google spreadsheet.

    • Google.Spreadsheets.RetrieveRow

      Retrieves a specific row as comma-separated values.

    • Google.Spreadsheets.RetrieveSpecificRowsOrColumns

      Retrieves specific rows or columns based on a specified range.

    • Google.Spreadsheets.RetrieveSpreadsheetDetailsByName

      Retrieves spreadsheet and worksheet IDs with a given spreadsheet name.

    • Google.Spreadsheets.RetrieveSpreadsheets

      Retrieves a list of spreadsheets that exist in your Google account.

    • Google.Spreadsheets.RetrieveWorksheet

      Retrieves a specified worksheet from a Google spreadsheet in CSV, XML, or JSON format.

    • Google.Spreadsheets.RetrieveWorksheets

      Retrieves a list of worksheets in a given Google spreadsheet.

    • Google.Spreadsheets.SearchColumn

      Searches a column for a specified value.

    • Google.Spreadsheets.StructuredQuery

      Retrieves a list-based feed containing data in your Google spreadsheet that meets a specified criteria.

    • Google.Spreadsheets.UpdateCells

      Updates a specified cell in a Google worksheet.

    • Google.Spreadsheets.UpdateListRows

      Updates a worksheet row in a Google spreadsheet using a simple XML file you provide.

    • Google.Spreadsheets.UpdateRow

      Allows you to update a row by providing the row number and comma-separated data.

    • Google.Spreadsheets.UpdateWorksheet

      Updates existing worksheet metadata such as: Title, Row Count, and Column Count.

    • Google.Spreadsheets.UploadSpreadsheet

      Creates a Google spreadsheet from a CSV file.

    • 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