Project Description
Integration Usage
Link creation of new Google Sheets worksheets, rows or cells to creation and updating of new projects, scoops and fields. Feed relevant data collected using Scoop back into corresponding Google Sheets cells. Create a “FLO” as a series of steps to automate or integrate data and workflow with Scoop. In this way when an Event “triggers” the FLO it will perform each Action and Function, one by one, from left to right. See the specific set of available Events and Actions for integrating with Scoop.
Specifications
| Powered by: | Scoop Robotix GLOO™ |
| Support: | Fully Hosted & Managed Service |
Available Events & Actions
- New Row
Start FLO when a new row is added to a sheet - New Row (Revision History)
Start FLO when a new row is added to a sheet. Revision history must be enabled on the sheet in order to use this monitor
- Clear Row
Clears a row of all cell data, leaving the row empty - Copy Spreadsheet
Copies a spreadsheet with all formatting and data into a new spreadsheet - Create Row
Appends a row to the end of a worksheet - Create Spreadsheet
Creates a new spreadsheets - Create Worksheet
Creates a new worksheet - Delete Row
Deletes a list row - Delete Worksheet
Deletes a worksheet - Delete Spreadsheet
Deletes a spreadsheet by ID - Download Sheet
Download a sheet in .xlsx, .ods, .pdf, or .csv format - HTTP Request
Make an authenticated HTTP request to the Googlesheets API - Read All Rows
Read all rows (starting at 2, 1 being the header row) from a worksheet and return them as a collection - Read All Spreadsheets
Returns a collection of all spreadsheets to which this account has access - Read Cell
Reads the content of a cell, referenced in ‘A1’ notation - Read Column
Gets the values of a column and returns them as a collection - Read Row
Reads the content of a row as a list (Cells without column header ignored) - Read Spreadsheet Info
Returns info on the first spreadsheet found by name (if you have spreadsheets with duplicate names, only the first result is returned) - Read Worksheet Info
Gets worksheet information by worksheet name - Search Column
Searches a column for a value (case sensitive) and returns its row number (or ‘null’ if not found) - Update Cell
Changes the value in a cell defined in A1 notation - Update Row
Updates the content of a row (input a space to clear a cell, empty inputs will be skipped) - Update Worksheet Info
Updates a worksheet’s metadata information