Google Sheets2019-06-11T10:49:06-07:00

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.

Contact Sales

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