Helpful components right under your fingers

Use huge amount of integrated technologies to create best integrations

Google Sheets

Google Sheets is the new Google Spreadsheets software. Google Sheets is available on all your devices and has all the features you come to expect from spreadsheet software. Sheets also allows you to collaborate with others in real time.

Featured applications for  Google Sheets  connector
Google Sheets   connector features
Actions
Read data
  • Returns a range of values from a spreadsheet. The caller must specify the spreadsheet ID and a range to read.

    Parameters:

    • Google account, String
    • Spreadsheet id, String
    • Data sheet name, String
    • Cells range, String

    Returns:

    • range, String
    • values, Array [Array]
    • rows, Array [Object]
  • Write data
  • Appends values to a spreadsheet. The data will be inserted right after last row with values

    Parameters:

      • Data sheet name, String
      • Data rows to append, Array [Array]
      • Google account, String
      • Spreadsheet ID, String

    Returns:

    • updatedRowsCount, Integer
    • updatedRange, String
  • Appends new row to a spreadsheet. The data will be inserted right after last row with values

    Parameters:

      • Data sheet name, String
      • Row data, Array [String]
      • Google account, String
      • Spreadsheet ID, String

    Returns:

    • rowRange, String
  • Updates values in the spreadsheet in multiple ranges

    Parameters:

      • Data sheet name, String
      • Data ranges to update, Array [Object]
      • Google account, String
      • Spreadsheet ID, String

    Returns:

    • updatedRowsCount, Integer
  • Updates values in the spreadsheet

    Parameters:

      • Data sheet name, String
      • Data values, Array [Array]
      • Cells range, String
      • Google account, String
      • Spreadsheet ID, String

    Returns:

    • updatedRowsCount, Integer
    • updatedRange, String
  • Updates values in single row

    Parameters:

      • Data sheet name, String
      • Row index, Integer
      • Row data, Array [Object]
      • Google account, String
      • Spreadsheet ID, String

    Returns:

    • updatedRange, String
Triggers
Triggers
  • Trigger will activate after row(s) have been added to google sheet

    Parameters:

      • Google sheets login, String
      • Spreadsheet Id, String
      • Page name, String

    Returns:

    • spreadsheetId, String
    • documentChanges, Array [Object]