Google Sheets
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
- ABBYY Download
- ABBYY Status
- ABBYY Upload
- AD LDAP
- Adv Send Email
- API Requests
- ARGOS API
- Arithmetic Op
- ASCII Converter
- Attach Image
- AWS S3
- AWS Textra Rekog
- Base64
- Basic Numerical Operations
- Basic String Manipulation
- Bot Collabo
- Box
- Box II
- Chatwork GetMessage
- Chatwork Notification
- Citizen Log
- Clipboard
- Codat API
- Convert CharSet
- Convert Image
- Convert Image II
- Create Newfile
- CSV2XLSX
- Data Plot I
- DeepL Free
- Detect CharSet
- Dialog Calendar
- Dialog Error
- Dialog File Selection
- Dialog Forms
- Dialog Info
- Dialog Password
- Dialog Question
- Dialog Text Entry
- Dialog Text Info
- Dialog Warning
- DirectCloud API
- Doc2TXT
- DocDigitizer Get Doc
- DocDigitizer Tracking
- DocDigitizer Upload
- Docker Remote Service
- Drag and Drop
- Dropbox
- Dynamic Python
- Email IMAP ReadMon
- Email Read Mon
- Env Check
- Env Var
- Excel2Image
- Excel Advanced
- Excel Advance IV
- Excel AdvII
- Excel AdvIII
- Excel Copy Paste
- Excel Formula
- Excel Large Files
- Excel Macro
- Excel Newfile
- Excel Simple Read
- Excel Simple Write
- Excel Style
- Excel Update
- Fairy Devices mimi AI
- File Conv
- File Downloader
- File Folder Exists
- File Folder Op
- File Status
- Fixed Form Processing
- Floating Form Processing
- Folder Monitor
- Folder Status
- Folder Structure
- FTP Server
- Git HTML Extract
- Google Calendar
- Google Cloud Vision API
- Google Drive
- Google Search API
- Google Sheets
- Google Token
- Google Translate
- Google TTS
- GraphQL API
- Html Extract
- HTML Table
- IBM Speech to Text
- IBM Visual Recognition
- Java UI Automation
- JP Holiday
- JSON Select
- JSON to from CSV
- Lazarus Forms
- Lazarus Invoices
- Lazarus RikAI
- Lazarus Riky
- LINE ID Card OCR
- LINE Notify
- LINE Receipt OCR
- Microsoft Teams
- MongoDB
- MQTT Publisher
- MS Azure Text Analytics
- MS Word Extract
- NAVER OCR
- Newuser-SFDC
- OCI
- OCR PreProcess
- OpenAI API
- Oracle SQL
- Outlook
- Outlook Email
- PANDAS I
- pandas II
- pandas III
- PANDAS profiling
- Parsehub
- Password Generate
- Path Manipulation
- PDF2Doc
- PDF2Table
- PDF2TXT
- PDF Miner
- PDF SplitMerge
- PostgreSQL
- PowerShell
- PPTX Template
- Print 2 Image
- Python Selenium
- QR Generate
- QR Read
- RakurakuHanbai API
- Regression
- Rename File
- REST API
- Rossum
- Running GAS
- Scrapy Basic
- Screen Capture
- Screen Recording START
- Screen Recording STOP
- Screen Snipping
- Seaborn Plot
- SharePoint
- Simple Counter
- Simple SFDC
- Slack
- Sort CSV
- Speed Test
- SQL
- SQLite
- SSH Command
- SSH Copy
- String Manipulation
- String Similarity
- Svc Check
- Sys Info
- Telegram
- Tesseract
- Text2PDF
- Text2Word
- Text Read
- Text Write
- Time Diff
- Time Stamp
- Web Extract
- Windows Op
- Windows Screen Lock
- Win UI Control
- Win UI Text
- Word2PDF
- Word2TXT
- Word Editor
- Work Calendar
- XML Extract
- XML Manipulation
- Xtracta Get Doc
- Xtracta Tracking
- Xtracta Upload
- YouTube Operation
- ZipUnzip