Connect Google Sheets and Tovuti LMS

Both apps 150Google Sheets 62Tovuti LMS 88

• Trigger
  Aggregate Metric Changed

  Fires when an aggregate metric (sum/avg/count/…) over a column changes.

• Trigger
  Cell Range Values Changed

  Fires when the values in a specific cell range change.

• Trigger
  Conditional Format Rule Changed

  Fires when a conditional-format rule changes.

• Trigger
  Data Validation Rule Changed

  Fires when a data-validation rule changes.

• Trigger
  Developer Metadata Changed

  Fires when developer metadata changes.

• Trigger
  Filtered Range Values Changed

  Fires when the values in a filtered range change.

• Trigger
  New Rows

  Fires when new rows are appended to a Google Sheet.

• Trigger
  New Sheet Added

  Fires when a new sheet (tab) is added to a spreadsheet.

• Trigger
  New Spreadsheet Created

  Fires when a new spreadsheet is created in the account.

• Trigger
  Spreadsheet Metadata Changed

  Fires when spreadsheet metadata changes.

• Trigger
  Spreadsheet Properties Changed

  Fires when spreadsheet properties change.

• Trigger
  Spreadsheet Row Changed

  Fires when a row matching a query changes.

• Trigger
  Spreadsheet Search Match

  Fires when a spreadsheet matching search criteria is found.

• Trigger
  Table Query Result Changed

  Fires when the result of a SQL-style table query changes.

• Trigger
  Table Schema Changed

  Fires when a table's column schema changes.

• Trigger
  Worksheet Names Changed

  Fires when worksheet (tab) names change.

• Action
  Add Row

  Append a row to a Google Sheet

• Action
  Aggregate Column Data

  Read a range and compute an aggregate (sum|avg|min|max|count) over one column, skipping blank/non-numeric cells (so a header row is skipped automatically).

• Action
  Auto-Resize Rows or Columns

  Auto-fit row heights or column widths over an index range via autoResizeDimensions.

• Action
  Change Sheet Properties

  Update a worksheet's grid properties (row/column count) using an explicit field mask.

• Action
  Clear Basic Filter

  Remove the basic filter from a sheet via clearBasicFilter.

• Action
  Clear Spreadsheet Row(s)

  Clear the values in a range (formatting preserved).

• Action
  Copy Range

  Copy a source cell range to a destination range within the spreadsheet.

• Action
  Copy Worksheet

  Copy a worksheet into a destination spreadsheet.

• Action
  Create Chart

  Add a basic embedded chart (column/bar/line/etc.) built from a domain range and a series range on a sheet. Returns the new chartId.

• Action
  Create Conditional Formatting Rule

  Add a boolean conditional formatting rule (e.g. NUMBER_GREATER) that colors matching cells.

• Action
  Create Multiple Spreadsheet Rows

  Append many rows in one call.

• Action
  Create Spreadsheet

  Create a new Google Sheets spreadsheet with the given title.

• Action
  Create Spreadsheet Column

  Insert a blank column at a given index.

• Action
  Create Spreadsheet Row

  Append a single row of values to a sheet range.

• Action
  Create Spreadsheet Row at Top

  Insert a blank row just below the header (row 2), then write the given values into it in one operation.

• Action
  Create Worksheet

  Add a new worksheet (tab) to an existing spreadsheet.

• Action
  Delete Chart

  Delete an embedded chart via deleteEmbeddedObject.

• Action
  Delete Sheet

  Delete a worksheet from a spreadsheet by sheetId (gid).

• Action
  Delete Spreadsheet Row(s)

  Delete a contiguous block of rows by index.

• Action
  Find and Replace

  Find and replace text across the spreadsheet. Supply EXACTLY ONE scope: all_sheets=true OR sheet_id. Leave the other unset (do not pass all_sheets=false together with sheet_id).

• Action
  Find Spreadsheet

  Find spreadsheets by exact name via the Drive API (cross-host through the googlesheets connection).

• Action
  Find Worksheet

  Return the worksheet whose title matches the given title (sheet_id/index/found), reading the spreadsheet's sheet properties.

• Action
  Format Cell Range

  Apply background color and bold formatting to a cell range via repeatCell.

• Action
  Format Spreadsheet Row

  Apply a background color across an entire row via repeatCell over a row range.

• Action
  Get Conditional Format Rules

  List all conditional-format rules on each sheet (paired with the sheetId so a follow-up update can target a rule by index).

• Action
  Get Data Range

  Read all values in one or more ranges via batchGet.

• Action
  Get Data Validation Rules

  Read the data-validation rule set on every cell of a range (per-cell dataValidation, via includeGridData with a field mask).

• Action
  Get Many Spreadsheet Rows (Advanced)

  Read multiple ranges at once via batchGet.

• Action
  Get Row by ID

  Read a single row range. NOTE: Google Sheets has no row ID; the row number IS the identity.

• Action
  Get Sheet Names

  Return the titles of all sheets (tabs) in the spreadsheet.

• Action
  Get Spreadsheet by ID

  Fetch spreadsheet metadata (title, sheets, gids, grid properties).

• Action
  List Charts

  List all embedded charts (chartId + title) across every sheet in the spreadsheet.

• Action
  Lookup Spreadsheet Row

  Read a range and return the FIRST row whose cell at column_index equals match_value (Sheets has no server-side filter; this op filters the returned rows).

• Action
  Lookup Spreadsheet Rows (Advanced)

  Read multiple ranges via batchGet and return ALL rows whose cell at column_index equals match_value (Sheets has no server-side filter; this op filters the returned rows).

• Action
  Move Chart

  Reposition an embedded chart to a new overlay anchor cell via updateEmbeddedObjectPosition.

• Action
  Rename Sheet

  Rename a worksheet's title.

• Action
  Search Spreadsheets

  Search spreadsheets by name substring (or full-text) via the Drive API, cross-host through the googlesheets connection.

• Action
  Set Basic Filter

  Apply a basic filter to a range on a sheet via setBasicFilter.

• Action
  Set Data Validation

  Apply a ONE_OF_LIST dropdown data-validation rule to a cell range.

• Action
  Sort Range

  Sort a cell range by one column in ascending or descending order.

• Action
  Update Chart

  Replace an existing chart's spec (title, chart type, domain/series ranges) via updateChartSpec.

• Action
  Update Conditional Format Rules

  Replace an existing conditional-format rule (identified by its index on the sheet) with a new boolean rule.

• Action
  Update Data Validation Rule

  Overwrite the data-validation rule on a cell range with a ONE_OF_LIST dropdown (same endpoint as create; setDataValidation replaces whatever rule the range held).

• Action
  Update Spreadsheet Row

  Overwrite the values at a specific range.

• Action
  Update Spreadsheet Row(s)

  Update one or more disjoint ranges in a single batch.

• Action
  Upsert Row

  Read a range, find the row whose column_index cell equals match_value; UPDATE that row when found, otherwise APPEND a new row. One adaptive write request (method+path chosen by the match script).

• Trigger
  List Assignments

  Triggers when a new assignment is added in Tovuti, optionally limited to assignments matching the filters you set.

• Trigger
  List Awards

  Triggers when a new award (badge, milestone, or certificate) is added in Tovuti.

• Trigger
  List Awards Earned

  Triggers when a user earns an award, such as a badge, certificate or milestone, and returns the earned award with the user who received it.

• Trigger
  List Checklists

  Triggers when a new checklist is created in Tovuti, returning its title, due date, access settings and items.

• Trigger
  List Course Categories

  Triggers when a new course category appears in Tovuti, optionally limited to specific categories or titles.

• Trigger
  List Course Progresses

  Triggers when a learner gets a new course progress record, returning the learner, course, score, status and key dates.

• Trigger
  List Course Progresses (Alt)

  Triggers when a new course progress record appears for a user, with the user's name and the course title included.

• Trigger
  List Courses

  Triggers when a course appears in Tovuti LMS, returning the course with its category, pricing, access settings and custom fields.

• Trigger
  List Event Registrations

  Triggers when a new event registration is created, returning the registrant, event, payment and check-in details.

• Trigger
  List Events

  Triggers when a new event is added in Tovuti, returning the event's schedule, registration settings, counts and custom field values.

• Trigger
  List Lessons

  Triggers when a new lesson is added to Tovuti, with optional filters by course, title, language, teacher, publish status and dates.

• Trigger
  List Media Categories

  Triggers when a new media category is created in Tovuti.

• Trigger
  List Media Items

  Triggers when a new media item is added to your Tovuti media library, optionally limited by title, publish status or creation date.

• Trigger
  List Meetings

  Triggers when a new meeting is added in Tovuti, optionally limited by name, type, or meeting and creation dates.

• Trigger
  List Object Types

  Triggers when a new object type is added in Tovuti, returning its id, title and enabled status.

• Trigger
  List Profile Fields

  Triggers when a new custom profile field is added to your Tovuti account, returning the field's type, name, visibility and settings.

• Trigger
  List Quiz Results

  Triggers when a new quiz or assessment result is recorded, returning the learner, the score and whether they passed.

• Trigger
  List Quizzes

  Triggers when a new quiz is added in Tovuti, returning the quiz's details.

• Trigger
  List Subscriptions

  Triggers when a new subscription plan is added in Tovuti, returning the plan's title, pricing and availability.

• Trigger
  List Teams

  Triggers when a new team is created in Tovuti, optionally limited to specific teams, a title or a member type.

• Trigger
  List User Checklist Progress

  Triggers when a user's progress on a checklist item is recorded or changes, such as when an item is assigned or completed.

• Trigger
  List User Groups

  Triggers when a new user group is added in Tovuti, returning its title, parent group and member users.

• Action
  Create Assignment

  Creates an assignment that assigns or recommends courses or learning paths to users or user groups, and returns the new assignment.

• Action
  Create Award

  Creates a badge, certificate or milestone award in Tovuti and returns the new award.

• Action
  Create Checklist

  Creates a checklist in Tovuti with its due date, access restrictions and checklist items, and returns the new checklist.

• Action
  Create Course Category

  Creates a course category in Tovuti, optionally nested under a parent category and limited to chosen viewers. Returns the new category.

• Action
  Create Course Progress

  Creates a course progress record that tracks a user's progress through a course.

• Action
  Create Event

  Creates an event in Tovuti LMS and returns the new event, including its id, dates and registration settings.

• Action
  Create Lesson

  Creates a lesson in Tovuti, optionally placing it in a course and assigning its teachers, and returns the new lesson.

• Action
  Create Media Category

  Creates a media category in Tovuti, with its title, publishing status and who can access it.

• Action
  Create Meeting

  Creates a meeting in Tovuti LMS and returns the new meeting, including its join link details and access settings.

• Action
  Create Object

  Creates an object of a chosen object type in Tovuti, such as an organization, with its title, description, image and custom field values.

• Action
  Create Object Type

  Creates an object type in Tovuti LMS and returns the new object type.

• Action
  Create Quiz

  Creates a quiz or survey in Tovuti, optionally with its questions and assigned to a course or lesson. Returns the new quiz.

• Action
  Create Subscription

  Creates a subscription plan in Tovuti LMS with its title, pricing, billing period and availability, and returns the new plan.

• Action
  Create Team

  Creates a user team in Tovuti LMS, with its members, team leads and what those leads are allowed to manage. Returns the new team.

• Action
  Create User

  Creates a new user in Tovuti LMS, with optional user groups, teams, course enrollments, objects and profile fields, and returns the new user.

• Action
  Create User Group

  Creates a user group under a parent group in Tovuti, optionally adding users to it, and returns the new group.

• Action
  Event Registration

  Registers one or more existing users for a free event as individuals, optionally checking them in at the same time.

• Action
  Find Assignment

  Returns one assignment by its id, including its courses or learning paths, assigned users and groups, and dates.

• Action
  Find Assignments

  Returns the assignments that match the title, ids, dates, users, groups or teams you specify. Leave every filter blank to return all assignments.

• Action
  Find Award

  Returns one award, such as a badge, certificate, or milestone, by its ID, including its expiration settings, requirements, and recipients.

• Action
  Find Award Earned

  Returns the first award a user has earned that matches the given title, type or modified-date criteria, including when it was earned and when it expires.

• Action
  Find Awards

  Returns the awards that match the title, type, ids, or date filters you specify.

• Action
  Find Awards Earned

  Returns the awards users have earned across the account, matched by user, award title or type, group, team, or last-modified date.

• Action
  Find Checklist

  Returns a single checklist by its ID, including its items, access settings and due date details.

• Action
  Find Checklists

  Returns the checklists that match the title, ids, due dates, created dates or last-modified dates you specify.

• Action
  Find Course

  Returns a single course by its id, including its category, pricing, access settings and custom fields.

• Action
  Find Course Categories

  Returns the course categories that match a title, a set of category ids, or a last-modified date range.

• Action
  Find Course Category

  Returns a single course category by its ID, including its title, slug, parent category and visibility settings.

• Action
  Find Course Progress

  Returns one course progress record by its id, including the learner, the course, completed lessons, score, progress and status.

• Action
  Find Course Progress (Alt)

  Returns a user's course progress records, optionally narrowed to one course or lesson.

• Action
  Find Course Progresses

  Returns the course progress records that match the learner, course, lesson and date criteria you supply.

• Action
  Find Course Progresses (Alt)

  Returns course progress records across users, filtered by course title, user name, users, groups, teams, archived state, or started, last activity and completed dates.

• Action
  Find Courses

  Returns the courses that match the title, ids, categories, publication status or dates you specify.

• Action
  Find Event

  Returns one event by its id, including its schedule, registration counts and custom field values.

• Action
  Find Event Registration

  Returns the first event registration that matches the event, user, group, team, name or date criteria you specify.

• Action
  Find Event Registrations

  Returns the event registrations that match the search criteria, such as user name, event title, or user, group, team and event ids.

• Action
  Find Events

  Returns the events that match the criteria you supply, such as title, event ids, languages, or start, end, registration and modified dates.

• Action
  Find Lesson

  Returns one lesson by its id, including its course, teachers, activities and publish status.

• Action
  Find Lessons

  Returns the lessons that match the criteria you supply, such as title, course, teacher, language, publish status or date ranges.

• Action
  Find Media Categories

  Returns the media categories that match a title, a set of ids or a published status.

• Action
  Find Media Category

  Returns one media category by its id, including its title, parent category, published status and access settings.

• Action
  Find Media Item

  Returns one media item, such as a video, audio file, PDF or link, by its id.

• Action
  Find Media Items

  Returns the media items that match the title, ids, published status or creation dates you specify.

• Action
  Find Meeting

  Returns a single meeting by its numeric id, including its schedule, hosts, access settings and attendees.

• Action
  Find Meetings

  Returns the meetings that match the name, type, ids or date ranges you specify.

• Action
  Find Object

  Returns one object by its id, including its title, type, description and custom field values.

• Action
  Find Object Type

  Returns one object type by its id, including its title and whether it is enabled.

• Action
  Find Object Types

  Returns the object types that match a title, a list of ids or a last-modified date range.

• Action
  Find Profile Field

  Returns one custom user profile field definition, including its type, options and form settings.

• Action
  Find Profile Fields

  Returns the custom profile fields defined on user profiles in Tovuti that match the name, type, visibility, ids or modification dates you specify.

• Action
  Find Quiz

  Returns a quiz by its ID, including its settings, messages, questions, answer choices, and the course and lesson it belongs to.

• Action
  Find Quiz Result

  Returns one quiz or assessment result by its ID, including the score, pass status and the learner's answer to each question.

• Action
  Find Quiz Results

  Returns quiz and assessment results that match the criteria you give, such as the assessment, user, group, team, lesson, course or submission date. Each result is a summary with the score and pass status.

• Action
  Find Quizzes

  Returns the quizzes that match the title, course, lesson, status or last-modified date you specify.

• Action
  Find Subscription

  Returns one subscription plan by its ID, including its title, pricing, length, availability and user groups.

• Action
  Find Subscriptions

  Returns the subscription plans that match a title, a list of ids, or a last-modified date range.

• Action
  Find Survey Responses

  Returns the survey responses that match the survey, user, lesson, event, question or date criteria you specify.

• Action
  Find Team

  Returns one user team by its ID, including its members, team leads and what the leads are allowed to manage.

• Action
  Find Teams

  Returns user teams that match the title, team ids, member type, or created and modified dates you specify.

• Action
  Find User

  Returns one user by id, including their groups, teams, course enrollments, objects and custom profile field values.

• Action
  Find User Checklist Progress

  Returns learners' progress on their assigned checklist items, filtered by user, group, team, or assigned, created and modified dates.

• Action
  Find User Group

  Returns one user group by its id, including its name, parent group and the users in it.

• Action
  Find User Groups

  Returns the user groups that match the title, group, user, parent, hierarchy range or modified date you specify.

• Action
  Subscribe

  Subscribes one or more existing users to a subscription plan. For a paid plan, subscribes a single user and records the payment they made outside Tovuti.

• Action
  Unsubscribe

  Removes one or more users from a free subscription plan.

• Action
  Update User

  Updates an existing user's profile, password, status, group and team memberships, course enrollments, associated objects and custom profile fields. Returns the updated user.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.