...
| Google Sheets |
|---|---|
Author: Irene Cho This plugin creates, reads from, writes to, and manages Google Sheets. Primary Features You can create Google Sheet and read from/write to it. Management functions includes rename a spreadsheet or sheet, adding, deleting, and duplicating sheets. There is also a feature to find and replace certain values in the spreadsheet. Prerequisite A file token.pickle which stores the credential information of Google API |
...
(Refer Google Token Plugin).
Google Spreadsheet ID and Sheet Id. The spreadsheet id and sheet id both can be found from URL. |
...
|
1. Return Value (CSV) headers
Below 4 operations return CSV as Return Value.
...
Note : the headers are used as “variable name” when you extract data from CSV and they are case sensitive.
Operations Column A Column B Column C
Add a Sheet: sheetId spreadsheetId
Delete a Sheet sheetId spreadsheetId
Rename a Sheet sheetId spreadsheetId
Duplicate a Sheet new sheetId old sheetId spreadsheetId
2. Plugin operations and required parameters
Operations | Parameters | Output |
|---|---|---|
Read a Spreadsheet | Spreadsheet Id | Values from the cell range of the sheet in form of CSV. |
Sheet Range (e.g. Sheet1!A1:B3, sheetname!A1) | ||
Create a Spreadsheet | Spreadsheet Name | Spreadsheet Id |
Write a Spreadsheet | Spreadsheet Id | Spreadsheet Id |
Sheet Range | ||
Excel/CSV File *Only accept .xslx or .csv format | ||
Inputfile Sheet *Sheetname of input excel file | ||
Rename a Spreadsheet | Spreadsheet Id | Spreadsheet Id |
Spreadsheet Name | ||
Add a Sheet | Spreadsheet Id | Sheet Id, Spreadsheet Id |
Sheet Name | ||
Sheet Id (optional): Integer e.g. 123 | ||
Delete a Sheet | Spreadsheet Id | Sheet Id, Spreadsheet Id |
Sheet Id: The sheet id to delete | ||
Rename a Sheet | Spreadsheet Id | Sheet Id, Spreadsheet Id |
Sheet Id: The sheet id to rename | ||
Sheet Name | ||
Duplicate a Sheet | Spreadsheet Id | Newssheet Id, oldsheet Id, Spreadsheet Id |
Sheet Id: The sheet id to be duplicated | ||
Sheet Name | ||
Find and Replace | Spreadsheet Id | Sheet Id, Spreadsheet Id |
3. Example of the plugin in STU
...
