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.

Using Google Sheets?

Easy connect Google Sheets with other services: CRM, webinars, email campaigns, calls, chat bots, Google Sheets, and other 150+ services

Connect Google Sheets with other services in few minutes

Easy integrate Google Sheets and connect realtime online data sync with other services: Pipedrive, WebinarJam, GetResponse, Google Sheets, SMS or voice calls, messengers and many more.

Templates for Google Sheets integration

It is much easier to configure Google Sheets's connection to other services using ready-made script templates. You can also create a new custom workflow using our visual constructor.

Useful information about Google Sheets

How to: Connect Google Spreadsheets with Onlizer

Google Sheets is an spreadsheets service from Google 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, share and gather valuable information, calculate metrics and solve other tasks. This "How-to" article describing how to connect Google Sheets account with Onlizer to write and read online tables (spreadsheets) and use other service features.

Google Sheets's triggers and actions

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]
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
 

Start your journey in world of limitless automation for free

You can test all features for free during 30-days trial period, no credit card required