Jump to a Section

Events

  • MonitorForNewRow

    Monitor For New Row

    Monitor a Google Sheet for whenever a new row is created. When a new row is created, the Flow will be activated. 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 Flows has a value in every row, even if it is 0, so that this action will search the entire column. It will also not trigger if you paste over existing data. So for example, if you cleared data out of cells but didn’t completely delete the row, the designer will see anything you paste into the row as an update, not a new row.

    Options

    • Spreadsheet (dropdown list): the spreadsheet to monitor
    • Worksheet (dropdown list): the sheet inside the spreadsheet to be monitored

    Output Fields

    Row

    • number (text): the number of the row that was created
    • value _(text)__:_ the values contained within the newly created row

Actions

  • CreateRow

    Create Row

    Creates a new row on a spreadsheet at the bottom of any existing rows.  Multiple rows can be saved.

    Options

    • Spreadsheet: A dropdown list of your available spreadsheets.
    • Worksheets: A dropdown list of the available worksheets/tabs within your spreadsheet.

    Input Fields

    • Columns
      • Dynamically generated based on the values you’ve entered as headers in Row 1 of your sheet. NOTE: These column headers will only appear if you enter data into Row 2. If you don’t see any input fields under fields, make sure to put text (it can be anything) into Row 2, Column 1 of your sheet. Then, delete the Create Row card and re-add. The column headers should now appear as inputs.

    Output Fields

    • Output
      • Updated Range (text):a string containing the updated range in the sheet
  • DeleteWorksheet

    Delete Worksheet

    This card will completely remove a Worksheet in a Google Sheets document.

    Input Fields

    • SpreadSheet ID (text): First choose which entire Google Sheets file to update
    • Worksheet ID (text): Within that file, state which tab or Worksheet to delete.The way to get both of these IDs is to use the “Read Worksheet Card.” Simply enter in the name of the sheet you wish to delete and it will return both IDs which you can then drag into the Delete WorkSheet card.

    Output Fields

    The output is the deletion of the row desired.

  • Download Sheet

    Download Sheet

    Downloads selected Google Sheet in csv, odf, pdf or xlsx file format.

    Options

    • Spreadsheet (dropdown list): a list of the Google Sheets to which the selected account has access
    • File Format (dropdown list): choice between csv, odf, pdf, or xlsx file formats. If the sheet has more than one tab/worksheet, all of the tabs are saved in the file (e.g. as different pages if you save to pdf).

    Input Fields

    None

    Output Fields

    • Size: The file size (in bytes)
    • Name: The name of the file, including the file extension (e.g. “.pdf”)
    • File Content: The actual file downloaded, but it just exists while the Flow is running. To do something with the download, you need to map the output to an input for an action that accepts files, such as Google Drive - Upload File or Salesforce - Upload Attachment.
  • ReadRow

    Read Row

    Read information in a row.

    Options

    • Spreadsheet (dropdown): a dropdown of all the spreadsheets you have access to within your Google Sheets account.
    • Worksheets (dropdown): a dropdown 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.

    • updated_date (date): the date on which the row was last updated.
    • row_title (text): the unique row ID of the row you are reading.
  • Read Worksheet

    Read Worksheet

    This card returns information about a worksheet within a spreadsheet on Google Sheets.

    Options

    • Spreadsheet (Name): Drag down the options and select a spreadsheet.

    Input Fields

    • Worksheet Name (text): Type in the name of the worksheet of choice.

    Output Fields

    This card returns 6 values. These can be dragged to other cards to perform other functions.

    • Spreadsheet ID (text):
      • Returns the ID to locate the Spreadsheet which the worksheet is located. This can be dragged to other cards to perform functions on the Spreadsheet.
    • Worksheet ID  (text):
      • Returns the ID to locate this worksheet. This can be used in other cards to perform functions on this worksheet.
    • Worksheet URL  (text):
      • Returns the specific URL to access this worksheet.
    • Sheet Type (Ex: Grid):
      • Returns the format of the worksheet.
    • Row Count (integer):
      • Returns the number of rows on the worksheet.
    • Column Count (integer):
      • Returns the number of columns on the worksheet.
  • ReadAllRows

    ReadAllRows

    Gets the values in all of the rows of a Google Sheet, starting with row 2 (assuming column headers are in row 1).

    Options

    • Spreadsheet (dropdown list): a list of the Google Sheets to which the selected account has access
    • Worksheets (dropdown list): a list of the different worksheets or tabs contained in the chosen spreadsheet.

    Input Fields

    None

    Output Fields

    • Rows: (a list of objects) Returns a list of row values, starting in row 2, where each row object includes “Row Number” (a number starting with 2) followed by “Columns” which subkeys for each column name in the format of a number (starting with 0 for column A) then a hyphen then the column header taken from the value in row 1. You can pass this list to any of the List functions to process it (e.g. Sort By or For Each).

    Example

    Here’s an example of the list that might be returned from a sheet with a couple of rows of data:

    [
        {
            "Row Number": 2,
            "Columns": {
                "0-id": "123",
                "1-name": "Emily"
            }
        },
        {
            "Row Number": 3,
            "Columns": {
                "0-id": "172",
                "1-name": "Rahul"
            }
        }
    ]
  • SearchColumn

    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 Flows 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 worksheet/tab of the spreadsheet on which you are searching

    Input Fields

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

    • fields
      • search_value (text): the value by which you are searching the column
      • column (number): the number of the column by which you are searching. For example, if you are searching column A, the input for this field will be 1

    Output Fields

    • fields
      • 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 be blank
  • CreateWorksheet

    createWorksheet

    Creates an entirely new worksheet inside of a googlesheet file. The worksheet will surface as an additional tab a the bottom of the googlesheet when you open a file.

    Options

    • Spreadsheet: A dropdown list of your available spreadsheets. The sheet you select will be the file where the worksheet is added to.

    Input Fields

    • fields
      • title (text): Provide a text string to become the name of the worksheet when it is added to the existing googlesheet.
      • row_count (text): The number inserted into this field will determine the number of rows that are visible and part of the worksheet when it is created.
      • column_count (text): The number will determine number of columns to be used as part of the worksheet when it is created.
  • UpdateRow

    updateRow

    An overview on what the card does. Should also be used to describe general ‘odd’ card behavior that is atypical of other cards.

    Options

    • Spreadsheet (dropdown list): a list of the Google Sheets to which the selected account has access
    • Worksheets (dropdown list): a list of the worksheets/tabs that exist in the selected Google Sheet.

    Input Fields

    • row
      • number (text): the row number of the row to be updated; this is the number displayed to the left of each row in the Google Sheets UI
    • fields
      • column header (text): one field is displayed for each column in your Google Sheet that has a value in row 1; the name of each field displayed will correspond to the value in your Google Sheet

    Output Fields

    This action has no outputs.