Jump to a Section

Overview

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

      Monitors a spreadsheet for a new row. Will include blank rows if they are added between rows with content.

      Options

      • Spreadsheet (dropdown): A list of all the spreadsheets you have access to within your Google Sheets account.
      • Worksheets (dropdown): A list of the worksheets or tabs that exist on the spreadsheet you selected above.

      Output Fields

      Besides the standard output fields listed below, New Row will return all your custom column headers (as listed in row 1 of your Google Sheet) as outputs.

      • Row
        • The output returned by this card will be the column values associated with the row.
    • 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

      Use this card if you want to clear a row in a Google Spreadsheet.

      Options

      • Spreadsheet (dropdown) : A list of all the spreadsheets you have access to within your Google Sheets account
      • Worksheet (dropdown) : A list of all the worksheet tabs within your selected spreadsheet.

      Input Fields

      • Row Number (integer) : Decide which row to clear. There are two ways of declaring which to clear.

        • Manually type in the row number of choice within the card OR
        • In a form, prompt user to type in the row number they want to clear. Next, carry that integer to the clear row card.
      • Output

        • Cleared Range (text) : The row range that has been cleared.
    • Copy Spreadsheet

      Copy a complete spreadsheet, including all worksheets and data, to a new spreadsheet with a new name.

      Options

      • Sheet to Copy (dropdown) : A list of all the source spreadsheets you have access to within your Google Sheets account.

      Input Fields

      • New Spreadsheet
        • Name (text) : The name you want to give the newly copied spreadsheet.

      Output Fields

      • New Spreadsheet
        • ID (text) : The unique indentification number of the newly created copy of the spreadsheet.
        • URL (text) : The URL of the new copy.
    • Copy Worksheet

      Copy Worksheet

      Copy a worksheet from one spreadsheet to another.

      Options

      • Spreadsheet (dropdown): A list of all the spreadsheets you have access to within your Google Sheets account
      • Worksheet (dropdown): A list of all the worksheet tabs within your selected spreadsheet.

      Input Fields

      • Destination Spreadsheet
        • ID (text) : The ID of the spreadsheet into which you want to copy the selected worksheet. A spreadsheet ID can be extracted from its URL. For example, the spreadsheet ID in the URL https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0 is “abc1234567”.

      Output Fields

      • New Worksheet
        • Name (text) : The name of the new copy of the worksheet (typically “Copy of ”).
        • ID (text) : The unique identification number of the new worksheet.
    • Create Row

      Creates a new row on a spreadsheet at the bottom of any existing rows.

      Options

      • Spreadsheet (dropdown): A list of all the spreadsheets you have access to within your Google Sheets account
      • Worksheet (dropdown): A list of all the worksheet tabs within your selected spreadsheet.

      Input Fields

      • Columns
        • Dynamically generated based on the values you’ve entered as headers in Row 1 of your sheet.  Note that the header row needs to be created manually on the sheet before these inputs can be generated.

      Output Fields

      • Updated Range (text): A string containing the range address of the new row that was added (e.g. “Sheet1!A20:M20”).
      • Row Number (number): The number of the newly added row. These row is found on the left side of the worksheet.
    • Create Spreadsheet

      Create a single spreadsheet that will contain multiple worksheet.

      Input Fields

      • Spreadsheet
        • Spreadsheet Title (text) : The title of the new spreadsheet.
        • Worksheet Title (list of text) : The list of worksheet title that will be created as tabs or sheet for the newly created spreadsheet.

      Output Fields

      • Spreadsheet
        • Speadsheet ID (text) : The newly created spreadsheet unique identification number.
        • Spreadsheet URL (text) : The newly created spreadsheet URL or web address.
    • Create Worksheet

      Create Worksheet

      Create a new worksheet in a spreadsheet of your choice.

      Options

      • Spreadsheet (dropdown): A list of all the spreadsheets you have access to within your Google Sheets account - this will be the location of the new worksheet.

      Input Fields

      • Worksheet
        • Title (text): The name of the new worksheet.
        • Row Count (integer): The initial number of rows for the new worksheet.  Note that leaving this value at ‘0’ will initialize the sheet with 1000 rows by default.
        • Column Count (integer): The initial number of columns for the new worksheet.  Note that leaving this value at ‘0’ will initialize the sheet with 26 columns by default.  (One for each letter of the English alphabet)

      Output Fields

      • Spreadsheet ID (text): The ID of the spreadsheet in which the new worksheet was made.
      • New Worksheet ID (text): The ID of the newly created worksheet.
      • New Worksheet Name (text): The name of the newly created worksheet.
      • Worksheet URL (text): The URL where the newly created worksheet is located.
    • Delete Row

      This card will delete a row in a Google Sheets document.

      Options

      • Spreadsheet (dropdown): A list of all the spreadsheets you have access to within your Google Sheets account
      • Worksheet (dropdown): A list of all the worksheet tabs within your selected spreadsheet.

      Input Fields

      • row
        • number (number) : Returns the updated number of rows in the worksheet. This number is found on the left side of the worksheet.

      Output Fields

      • Output :
        • New Row Count (number) : The number of the remaining row counts in the worksheet.
    • Delete Spreadsheet

      This card will delete an existing spreadsheet.

      Input

      • Spreadsheet (text): Select the name of the spreadsheet you wish to delete.

      Output

      • Success (True or False): Returns whether or not the card has successfully delete the spreadsheet.
    • Delete Worksheet

      Remove a single worksheet and all its data by its unique identification number.

      Input Fields

      • Worksheet to Delete
        • Spreadsheet ID (text) : The spreadsheet unique identification number, This spreadsheet contain the to be deleted worksheet. A spreadsheet ID can be extracted from its URL. For example, the spreadsheet ID in the URL https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0 is “abc1234567”.
        • Worksheet ID (text) : The worksheet unique indetification number.The spreadsheet is identified by gid in the URL of the spreadsheet.

      Output Fields

      There no output fields for this card.
    • Download sheet

      Download a full spreadsheet in .xlsx, .ods, .pdf, or.csv format.

      Options

      • Spreadsheet (dropdown) : The specified spread sheet you want to download.
      • File Format (dropdown) : The file format, the supported file format are .xlsx, .ods, .pdf, or.csv format.

      Input Fields

      The are no input field for this card.

      Output Fields

      • File
        • Size The file is in kilobytes.
        • Name The file name.
        • File Content The file itself, The type will be determined before on the options.
    • HTTP Request

      Make an authenticated HTTP request to the Googlesheets API

    • Read All Rows

      Read all rows (starting at 2, 1 begin the header row) from a worksheet and return them as a collection.

      Options

      • Spreadsheet (dropdown): A list of all the spreadsheets you have access to within your Google Sheets account
      • Worksheet (dropdown): A list of all the worksheet tabs within your selected spreadsheet.

      Input Fields

      There no input fields for this card.

      Output Fields

      • Outputs
        • Rows (a list of object) : The output returned by this card will be the column values associated with the row.
          • Row Number (number) : The rows number. This number is located on the left side of the sheet.
          • Columns (object) : The list of cell located in the row, each representing a column.
    • Read All Spreadsheets

      This card takes in no input and automatically obtains the information about every spreadsheet on a Google Sheets account.

      Output

      • Spreadsheets (Object)
        • Name (text): Returns the name of the spreadsheet.
        • ID (text): Returns the unique ID of that document. This can be copied to other cards to use as identification for that sheet.
    • Read Cell

      Read the values from a specific cell.

      Options

      • Spreadsheet (dropdown): A list of all the spreadsheets you have access to within your Google Sheets account.
      • Worksheets (dropdown): list of the worksheets or tabs that exist on the spreadsheet you selected above.

      Input Fields

      • Cell
        • Coordinates (text): The cell coordinates in A1 notation where “A” is the column and “1” is the row of the cell to be updated.

      Output Fields

      • Output
        • Cell Value (text): The cell value you requested in the cell coordinates.
    • Read Column

      This card returns the values within a column on Google Sheets.

      Options

      • Spreadsheet (dropdown) : Choose which spreadsheet to look at.
      • Worksheet (dropdown) : Choose which worksheet to look at.
      • Column (dropdown) : Choose which column to return values for.

      Output Fields

      • Values in Column (list of text): The output will list out the values that are in the chosen column. It will display values starting from second row as the first row will be treated as custom “Column Headers” defined for the Google Sheet.
    • Read Row

      Read the values from a specific row.

      Options

      • Spreadsheet (dropdown) : A list of all the spreadsheets you have access to within your Google Sheets account.
      • Worksheets (dropdown) : A list of the worksheets or tabs that exist on the spreadsheet you selected above.

      Input Fields

      • Row
        • number (number) : The row number you wish to read.

      Output Fields

      Besides the standard output fields listed below, Read Row will return all your custom column headers (as listed in row 1 of your Google Sheet) as outputs.

      • Output
        • The output returned by this card will be the column values associated with the row.
    • Read Spreadsheet Info

      This card returns the information about a spreadsheet. It will read the first spreadsheet found by name. If you have spreadsheets with duplicate names, only the first result is returned.

      Input Fields

      • Spreadsheet
        • Name (text): The spreadsheet desired to analyze.

      Output Fields

      • Spreadsheet
        • ID (text) : The ID of this particular spreadsheet. This can be used in other Google Spreadsheet cards as identification.
        • URL (text) : This card will return the URL link of the page.
      • Worksheets
        • Worksheets (Object) : A collection of the worksheets inside this spreadsheet.
          • Name (text) : The names of the different Worksheet tabs within the spreadsheet.
          • ID (Number) : The unique IDs of the Worksheet tabs.
    • Read Worksheet Info

      The Google Sheets - readWorksheetInfo action provides a set of information (see Output Fields section below for a full list) about a specified worksheet.

      Options

      • Spreadsheet (dropdown) : A list of the Google Sheets to which the selected account has access.

      Input Fields

      Any additional information that should be known about the input fields, i.e., there is something very different about these input fields relative to other input fields.

      • worksheet

        • name (text): the name of the worksheet/tab to get information. For example, in the below screenshot, “Weekly”, “Monthly”, and “Quarterly” are worksheet/tab names.

          screen-shot-2016-09-30-at-4-55-35-pm

      Output Fields

      Any additional information that should be known about the output fields, such as if they are dynamically generated as in the case of Salesforce. This section should be reserved for “hey, these output fields are weird because…”. This section can be omitted if there is nothing to note about the Output Fields.

      • fields
        • updated_date (text): Date the sheet was last updated in an ISO 8601 string format.
        • worksheet_list_feed (text) : The list feed URL for the selected sheet.
        • worksheet_cell_feed (text) : The cell feed URL for the selected sheet.
        • worksheet_id (text) : The sheets API URL for the selected sheet.
        • worksheet_edit_feed (text) : The edits feed URL for the selected sheet.
        • row_count (text) : The number of rows in the sheet.
        • column_count (text) : The number of columns in the sheet.
    • Search Column

      Search a Google Sheet by one column for a specific term. NOTE: If there is a blank cell in between two values in the column you are searching within, this action will only search for values above that blank cell. We recommend making sure the column you are searching in FLOs has a value in every row, even if it is 0, so that this action will search the entire column.

      Options

      • Spreadsheet (dropdown) : The spreadsheet on which you are searching.
      • Worksheet (dropdown) : The tab or worksheet of the spreadsheet on which you are searching.
      • Column to Search (dropdown) : A list containing the specific column you want to search.

      Input Fields

      You can search by any value in any column of your spreadsheet.

      • Search Query
        • Search Term (text): The value you want to search for, inside the column.

      Output Fields

      • Output

        • Row Number (Number) : The row number at which the value you searched by was found. This action will return the first row at which the value is found, not a list if there are duplicates of that value in the sheet. If the value is not found within the column, the output will return null.

        Note : The Search process starts from second row as the first row will be treated as custom “Column Headers” defined for the Google Sheet.

    • Update Cell

      Update Cell

      Changes the value in a cell defined in A1 notation.

      Options

      • Spreadsheet (dropdown): A list of all the spreadsheets you have access to within your Google Sheets account
      • Worksheet (dropdown): A list of all the worksheet tabs within your selected spreadsheet.

      Input Fields

      • Cell
        • Coordinates (text) : The cell coordinates in A1 notation where “A” is the column and “1” is the row of the cell to be updated.
        • Updated Value (text) : The value with which to update the cell.

      Output Fields

      • Output
        • Updated Range (text) : The range associated with the values you’ve updated.
    • Update Row

      Update the values in a specific row.

      Options

      • Spreadsheet (dropdown): A list of all the spreadsheets you have access to within your Google Sheets account.
      • Worksheet (dropdown): A list of all the worksheet tabs within your selected spreadsheet.

      Input Fields

      • Row
        • Number (Number): The number of the row to be updated.
      • Columns
        • The columns generated under this header are derived from the columns you’ve specified inside the Google Sheet.

      Output Fields

      • Output
        • Updated Range (text): The range associated with the values you’ve updated.
    • Update Worksheet Info

      Updates a worksheet’s metadata information.

      Input Fields

      • Sheet to Update
        • Spreadsheet ID (text - required): ID of the spreadsheet to be updated.
        • Worksheet ID (text - required): ID of the worksheet to be updated.
      • New Info
        • title (text): The title of the spreadsheet.
      • Grid Properties
        • rowCount (text): Number of rows in the grid.
        • columnCount (text): Number of columns in the grid.

      Output Fields

      • Output
        • Worksheet URL (text): URL of the updated worksheet.