Google Sheets Connector

Google Sheets Connector

The high-performance Google Sheets Connector provides read/write capabilities within your application, allowing you to perform numerous Google Sheets operations with minimal coding or even no-coding at all. Integrate Google Sheets data into applications such as SSIS, SQL Server, any ODBC-compatible application, or even directly within a programming language using this connector.

Download for SSIS Download for SQL Server and ODBC Documentation

Integrate Google Sheets with these applications

All
Data Integration
Database
BI & Reporting
Productivity
Programming Languages
Automation & Scripting
ODBC applications

Actions supported by Google Sheets Connector

Google Sheets Connector supports following actions for REST API integration:

Clear Sheet Values

Description

Clears values from a spreadsheet. The caller must specify the spreadsheet ID and range. Only values are cleared -- all other properties of the cell (such as formatting, data validation, etc..) are kept.

Parameters

You can provide the following parameters to this action:

  • Range
  • TabName
  • valueRenderOption
  • valueInputOption
  • majorDimension
  • dateTimeRenderOption
  • SpreadSheetId

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • spreadsheetId
  • clearedRange

Visit documentation for more information.

Create SpreadSheet Tab

Description

Creates new tab for specified spreadsheet.

Parameters

You can provide the following parameters to this action:

  • NewTabName
  • InitialRowCount
  • InitialColumnCount
  • TabColorRedValue
  • TabColorGreenValue
  • TabColorBlueValue
  • SpreadSheetId

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • spreadsheetId

Visit documentation for more information.

Delete Sheet Rows / Columns

Description

Deletes rows / columns based on startIndex / endIndex range (Index is zero based). For example to delete First 5 rows specify startIndex=0 and endIndex=4.

Parameters

You can provide the following parameters to this action:

  • Range Type
  • Range Start Index (starts from 0)
  • Range End Index (starts from 0)
  • TabId
  • SpreadSheetId

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • spreadsheetId

Visit documentation for more information.

Delete SpreadSheet Tab

Description

Deletes specified tab from spreadsheet.

Parameters

You can provide the following parameters to this action:

  • TabId
  • SpreadSheetId

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • spreadsheetId

Visit documentation for more information.

Execute Command(s)

Description

Perform various operations available in online editor such as copy, paste, format, merge. Add multiple JSON command by adding comma after first command (e.g. requests : [ {..cmd1..} , {..cmd2..}, {..cmd3..} ] ) Refer to example requests on help link.

Parameters

You can provide the following parameters to this action:

  • Request Body
  • TabId
  • SpreadSheetId

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • spreadsheetId

Visit documentation for more information.

Get Sheet Properties / Tab information

Description

Read read sheet properties (e.g. list of tabs on sheet and its properties).

Parameters

You can provide the following parameters to this action:

  • SpreadSheetId

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

Insert Sheet Data (Append at the end)

Description

Append data to spreadsheet on desired tab. Data is appended after last non-empty row/cell location. You can supply cell offset to start scan to find non-empty cell.

Parameters

You can provide the following parameters to this action:

  • Start Range
  • TabName
  • valueRenderOption
  • valueInputOption
  • majorDimension
  • dateTimeRenderOption
  • SpreadSheetId

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • spreadsheetId
  • tableRange
  • updatedRange
  • updatedRows
  • updatedColumns
  • updatedCells

Visit documentation for more information.

Read Sheet Data

Description

Read google spreadsheet data from desired tab / cell location (i.e. start/end range).

Parameters

You can provide the following parameters to this action:

  • Range
  • TabName
  • valueRenderOption
  • valueInputOption
  • majorDimension
  • dateTimeRenderOption
  • SpreadSheetId

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

Update Sheet Data (Overwrite Cells)

Description

Update data to spreadsheet on desired tab / cell location (i.e. start/end range). Limit is 10MB per request.

Parameters

You can provide the following parameters to this action:

  • Range for Table Boundary (Including Header)
  • Range for Data Cells
  • TabName
  • valueRenderOption
  • valueInputOption
  • majorDimension
  • dateTimeRenderOption
  • SpreadSheetId

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • spreadsheetId
  • updatedRange
  • updatedRows
  • updatedColumns
  • updatedCells

Visit documentation for more information.

Make Generic API Request

Description

This is generic endpoint. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL.

Parameters

You can provide the following parameters to this action:

  • Url
  • Body
  • IsMultiPart
  • Filter
  • Headers
  • SpreadSheetId

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

Make Generic API Request (Bulk Write)

Description

This is a generic endpoint for bulk write purpose. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL.

Parameters

You can provide the following parameters to this action:

  • Url
  • IsMultiPart
  • Filter
  • Headers
  • SpreadSheetId

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.