Google Sheets

Google Sheets

Google Sheets lets you create and edit spreadsheets stored on your Google Drive. Turn on Applets to monitor specific cells in your spreadsheets as well create news docs, rows, and cell updates.

Connect

More

Google Sheets

Triggers

  • New spreadsheet added to folder

    This trigger fires when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.

    Trigger Fields
    • Drive folder path
  • New worksheet in spreadsheet

    This trigger fires when a new worksheet is added to a spreadsheet you specify.

    Trigger Fields
    • Enter the folder path...
    • and enter the filename
    • Or copy and paste the spreadsheet URL
  • New row added to spreadsheet

    This trigger fires when a new row is added to a spreadsheet you specify.

    Trigger Fields
    • Enter the folder path...
    • and enter the filename
    • Or copy and paste the spreadsheet URL
  • Cell updated in spreadsheet

    This trigger fires when a particular cell is updated within the spreadsheet you specify.

    Trigger Fields
    • Enter the folder path...
    • and enter the filename
    • Or copy and paste the spreadsheet URL
    • Which cell to monitor?
Google Sheets

Actions

  • Add row to spreadsheet

    This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.

    Action Fields
    • Spreadsheet name
    • Formatted row
    • Drive folder path
  • Update cell in spreadsheet

    This action will update a single cell in the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created if the file doesn't exist.

    Action Fields
    • Drive folder path
    • Spreadsheet name
    • Which cell?
    • Value