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