Google Sheets

Overview

Events

• New Row

  Trigger a flow when a new row is added to a spreadsheet. This event monitors spreadsheets based on their row count. A flow will not be triggered when rows are added and then immediately removed, or removed and then immediately added back. Blank rows will only trigger a flow if they are added between rows with content.

  Options

  • Spreadsheet (drop-down): list of spreadsheets in your Google Sheets account
  • Worksheets (drop-down): list of worksheets in the spreadsheet

  Output

  In addition to the Row Number field, custom column headers from Row 1 of your selected spreadsheet make up the output fields.

  • Row Number (text): location of the new row
  • Row (text): row content for each column
    

Actions

• Clear Row

  Clear a row in a Google Spreadsheet. You can indicate the row that you want to clear by manually typing the row number into the field or by mapping a user’s selected row number to the field.

  Options

  • Spreadsheet (drop-down): list of spreadsheets in your Google Sheets account
  • Worksheet (drop-down): list of worksheet tabs in your selected spreadsheet

  Input

  • Row Number (integer): number of the row to clear

  #### Output

  • Cleared Range (text): range of rows that has been cleared

• Copy Spreadsheet

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

  Unless otherwise indicated, field types are text.

  Options

  • Sheet to Copy (drop-down): list of spreadsheets in your Google Sheets account

  Input

  • New Spreadsheet
    • Name: name for the new spreadsheet

  Output

  • New Spreadsheet
    • ID: new spreadsheet’s unique ID
    • URL: new spreadsheet’s URL

• Copy Worksheet

  Copy a worksheet from one spreadsheet to another.

  Unless otherwise indicated, field types are text.

  Options

  • Spreadsheet (drop-down): list of spreadsheets in your Google Sheets account
  • Worksheet (drop-down): list of worksheet tabs in your selected spreadsheet

  Input

  • Destination Spreadsheet
    • ID: ID of the spreadsheet where you want to copy the selected worksheet (the spreadsheet ID in the URL https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0 is “abc1234567”)

  Output

  • New Worksheet
    • Name: name of the new worksheet (typically Copy of <original name>)
    • ID: new worksheet’s unique ID

• Create Row

  Add a new row to the bottom of a spreadsheet.

  Options

  • Spreadsheet (drop-down): list of spreadsheets in your Google Sheets account
  • Worksheet (drop-down): list of worksheet tabs in your selected spreadsheet

  Input

  • Columns: dynamically generated list of columns from Row 1 of your sheet (the header row must be created manually to generate this input)

  Output

  • Updated Range (text): range address of the new row (e.g. “Sheet1!A20:M20”)
  • Row Number (number): number of the new row

• Create Spreadsheet

  Create a single spreadsheet that contains multiple worksheets.

  Unless otherwise indicated, field types are text.

  Input

  • Spreadsheet
    • Spreadsheet Title: title of the spreadsheet
    • Worksheet Title (list of text): list of worksheet titles (created as tabs in the new spreadsheet)

  Output

  • Spreadsheet
    • Speadsheet ID: spreadsheet’s unique ID
    • Spreadsheet URL: spreadsheet’s URL

• Create Worksheet

  Create a new worksheet in a spreadsheet of your choice.

  Unless otherwise indicated, field types are text.

  Options

  • Spreadsheet (drop-down): list of spreadsheets in your Google Sheets account

  Input

  • Worksheet
    • Title: name of the new worksheet
    • Row Count (integer): initial number of rows for the new worksheet (leaving this value at 0 will generate 1000 rows)
    • Column Count (integer): initial number of columns for the new worksheet (leaving this value at 0 will generate 26 columns–one for each letter of the English alphabet)

  Output

  • Spreadsheet ID: ID of the spreadsheet in which the new worksheet was created
  • New Worksheet ID: ID of the new worksheet
  • New Worksheet Name: name of the new worksheet
  • Worksheet URL: URL of the new worksheet

• Delete Row

  Delete a row in a Google Sheet.

  Options

  • Spreadsheet (drop-down): list of spreadsheets in your Google Sheets account
  • Worksheet (drop-down): list of worksheet tabs in your selected spreadsheet

  Input

  • Row
    • Number (number): ID number of the row that you want to delete

  Output

  • New Row Count (number): total number of rows after the deletion

• Delete Spreadsheet

  Delete an existing spreadsheet.

  Input

  • Spreadsheet (text): name of the spreadsheet to delete

  Output

  • Success (True or False): indicator if deletion was successful

• Delete Worksheet

  Remove a single worksheet and all of its data.

  Field types are text.

  Input

  • Worksheet to Delete
    • Spreadsheet ID (text): spreadsheet’s unique ID (the spreadsheet ID in the URL https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0 is “abc1234567”)
    • Worksheet ID (text): worksheet’s unique ID (identified by gid in the URL of the spreadsheet)

• Download sheet

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

  Unless otherwise indicated, field types are text.

  Options

  • Spreadsheet (drop-down): list of spreadsheets in your Google Sheets account
  • File Format (drop-down): file format for your download (.xlsx, .ods, .pdf, or.csv format)

  Output

  • File
    • Size: file size in kilobytes
    • Name: file name
    • File Content: actual downloaded file (type determined by the format option selected)

• HTTP Request

  Make an authenticated HTTP request to the Googlesheets API

• Read All Rows

  Read all non-header rows from a worksheet and return them as a collection.

  Options

  • Spreadsheet (drop-down): list of spreadsheets in your Google Sheets account
  • Worksheet (drop-down): list of worksheet tabs in the spreadsheet
    

  Output

  • Rows (list of objects): column values associated with the row
    • Row Number (number): location number of the row
    • Columns (object): cell content in the row (each cell represents a column)

• Read All Spreadsheets

  Retrieve ID information about every spreadsheet in a Google Sheets account.

  Output

  • Spreadsheets (object)
    • Name (text): name of the spreadsheet
    • ID (text): spreadsheet ID

• Read Cell

  Read the values from a specific cell in a spreadsheet.

  Options

  • Spreadsheet (drop-down): list of spreadsheets in your Google Sheets account
  • Worksheets (drop-down): list of worksheets in the spreadsheet

  Input

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

  Output

  • Output
    • Cell Value (text): value of the cell requested in the Cell Coordinates field

• Read Column

  Retrieve values from a column in a Google Sheet.

  Options

  • Spreadsheet (drop-down): list of spreadsheets in your Google Sheets account
  • Worksheets (drop-down): list of worksheets in the spreadsheet
  • Column to Search (drop-down): list of columns in the worksheet

  Output

  • Values in Column (list of text): list of values in the selected column

• Read Row

  Read the values from a specific row.

  Options

  • Spreadsheet (drop-down): list of spreadsheets in your Google Sheets account
  • Worksheets (drop-down): list of worksheets in the spreadsheet

  Input

  • Row
    • Number (number): location number of the row
      

  Output

  Value of each cell from the row number entered above. The output display names reflect the values of the column headers.

• Read Spreadsheet Info

  Read information about a spreadsheet in your Google Sheets account. If you have spreadsheets with duplicate names, only the first result is returned.

  Unless otherwise indicated, field types are text.

  Input

  • Spreadsheet
    • Name: spreadsheet name

  Output

  • Spreadsheet
    • ID: spreadsheet’s unique ID
    • URL: URL of the spreadsheet
  • Worksheets (object): collection of worksheets in the spreadsheet
    • Name: names of the worksheet tabs in the spreadsheet
    • ID (number): unique IDs of the worksheet tabs in the spreadsheet

• Read Worksheet Info

  Retrieve information about a worksheet in your Google Sheets account.

  Unless otherwise indicated, field types are text.

  Options

  • Spreadsheet (drop-down) : list of spreadsheets in your Google Sheets account

  Input

  • Worksheet

    • Name: name of the worksheet (for example, “Weekly”, “Monthly”, and “Quarterly” are worksheet names in the screenshot)

      

  Output

  • Spreadsheet ID: spreadsheet’s unique identifier
  • Worksheet ID: worksheet’s unique identifier
  • Worksheet URL: URL of the worksheet
  • Sheet Type: type of worksheet
  • Row Count: number of columns in the worksheet
  • Column Count: number of columns in the worksheet

• Search Column

  Search one column in a Google Sheet for a specific term. Be sure that the column you are searching has a value in every cell (even if it is 0); the search stops if it encounters a blank cell.

  Options

  • Spreadsheet (drop-down): list of spreadsheets in your Google Sheets account
  • Worksheets (drop-down): list of worksheets in the spreadsheet
  • Column to Search (drop-down): list of columns in the worksheet

  Input

  • Search Query
    • Search Term (text): value that you want to search for in the column

  Output

  • Row Number (number): location number of the first row where the value was found (if the value is not found in the column, this field will return null)

• Update Cell

  Change the value in a cell.

  Unless otherwise indicated, field types are text.

  Options

  • Spreadsheet (drop-down): list of spreadsheets in your Google Sheets account
  • Worksheets (drop-down): list of worksheets in the spreadsheet

  Input

  • Cell
    • Coordinates: coordinates of the cell to update (in A1 notation: A is the column and 1 is the row)
    • Updated Value: new value for the cell

  Output

  • Updated Range: range associated with the values you updated

• Update Row

  Update the values in a spreadsheet row.

  Options

  • Spreadsheet (drop-down): list of spreadsheets in your Google Sheets account
  • Worksheets (drop-down): list of worksheets in the spreadsheet

  Input

  • Row
    • Number (number): location number of the row
    • Columns (object): cell content in the row (each cell represents a column)

  Output

  • Output
    • Updated Range (text): range associated with the updated values

• Update Worksheet Info

  Update a worksheet’s metadata information.

  All field types are text.

  Input

  • Sheet to Update
    • Spreadsheet ID: ID of the spreadsheet to be updated
    • Worksheet ID: ID of the worksheet to be updated
  • New Info
    • title: new title of the spreadsheet
  • Grid Properties
    • rowCount: number of rows in the grid
    • columnCount: number of columns in the grid

  Output

  • Worksheet URL: URL of the updated worksheet