Google Sheets

The first time you add a Google Sheets card to a FLO, you will need to create a configuration. This will allow you to connect to your account, save your account information, and reuse that configuration next time you build a FLO with the connector. That way, you don’t have to sign in every time you want to build a FLO with this Connector. Instead, use the configuration you have already set up. You can create and save multiple configurations and share them with your teammates.

Here’s how to set up a new configuration in Google Sheets:

  1. First, enter in an Account Nickname. This should be unique so if you are connecting multiple Google Sheets accounts you will be able to tell them apart.
  2. Then click “Create” to finish this configuration.

Events:

  • 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.

Actions:

  • 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
  • Copy Worksheet
  • 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 Spreadsheet - Deletes a spreadsheet by ID
  • Delete Worksheet - Deletes a worksheet
  • 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