Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the component beyond simple SELECT/INSERT/UPDATE/DELETE operations with Google Sheets.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Google Sheets, along with an indication of whether the procedure succeeded or failed.
CData SSIS Components for Google Sheets Stored Procedures
| Name | Description |
| AddDataSource | Add a BigQuery dataSource to the specified spreadsheet. A Custom OAuth app with the scope bigquery.readonly is required to run this stored procedure. |
| AddDataSourceTable | Add a DataSource Table to a sheet. A Custom OAuth app with the scope bigquery.readonly is required to run this stored procedure. |
| AddSheet | Add a worksheet to an existing Google spreadsheet. |
| CopySheet | Copies a sheet from a spreadsheet to another spreadsheet. |
| CreateSchema | Creates a schema file for the specified table or view. |
| CreateSpreadsheet | Creates a spreadsheet in the user's Google Drive. |
| DeleteSheet | Deletes a worksheet in an existing Google spreadsheet. |
| DeleteSpreadsheet | Deletes a spreadsheet. |
| DownloadDocument | Downloads a file from the user's Google Sheets resouces specified by the Id of the spreadsheet and exported in the format specified in the FileFormat property. |
| FormatRange | Format cells in a specific range |
| GetOAuthAccessToken | Obtains the OAuth access token to be used for authentication with various Google services. |
| GetOAuthAuthorizationURL | Obtains the OAuth authorization URL for authentication with various Google services. |
| RefreshOAuthAccessToken | Obtains the OAuth access token to be used for authentication with various Google services. |
| UpdateSheet | Updates properties of the sheet for the specified SpreadsheetId and SheetId. |
| UploadDocument | Uploads a file to the user's Google Drive. |