Connect Smartsheet to SchoolMaker

Both apps 59Smartsheet 29SchoolMaker 30

• Trigger
  New row

  Triggered when a new row is added to the specified sheet. Polls rows modified since the last check and emits new ones.

• Trigger
  New sheet

  Triggered when a new sheet is created. Polls the list of sheets and emits newly seen ones.

• Trigger
  Updated row

  Triggered when any row is updated in the specified sheet. Polls rows modified since the last check and emits updated ones.

• Action
  Add column

  /sheets/{sheetId}/columns - add columns to a sheet.

• Action
  Add comment

  /sheets/{sheetId}/discussions/{discussionId}/comments - add a comment to a discussion.

• Action
  Add discussion

  Starts a new discussion on a sheet with a first comment, and returns the discussion.

• Action
  Add folder

  /folders/{folderId}/folders or /home/folders - create a folder.

• Action
  Add home folder

  Creates a folder at the top level of your Sheets home and returns it.

• Action
  Add row

  Adds a new row to the specified sheet. Provide cells as an array of {columnId, value}. Set location to Top or Bottom.

• Action
  Add row attachment

  /sheets/{sheetId}/rows/{rowId}/attachments - attach file or URL to a row.

• Action
  Add sheet

  /sheets - create a sheet with columns.

• Action
  Copy row to another sheet

  Copies a row from one sheet to another sheet. The placement of the cells in the destination sheet is determined by Smartsheet's logic.

• Action
  Copy sheet

  /sheets/{sheetId}/copy - copy a sheet to a folder/workspace.

• Action
  Delete row

  Deletes a row from a sheet given its Row ID.

• Action
  Delete row if deal does not exist in ActiveCampaign (Cisco)

  Compares deals from ActiveCampaign with the Smartsheet 'ActiveCampaign Deal ID' column. Deletes rows whose deal ID is not present in the supplied list of existing ActiveCampaign deal IDs. Built from intent against Smartsheet API 2.0.

• Action
  Find rows

  Searches for rows in a specified sheet containing the specified value (in any column). Returns zero or more row IDs. Use the 'Get row' action within a Loop to fetch each row's contents.

• Action
  Find rows by column value

  Searches for rows in a specified sheet having the specified value in a specified column. Zero, one, or multiple row IDs may be returned.

• Action
  Find sheets by keyword

  Returns the sheets that match the specified keyword.

• Action
  Find single row

  Searches for a single row in a specified sheet matching the specified value (in any column). If zero or multiple rows are found, an error occurs.

• Action
  Find single row by column value

  Searches for a single row in a specified sheet having the specified value in a specified column. If zero or multiple rows are found, an error occurs.

• Action
  Get discussion

  Returns a sheet discussion with its title and comments.

• Action
  Get folder

  Returns a folder with the folders and sheets directly inside it.

• Action
  Get row

  Returns the column data for the specified row. An error occurs if the row is not found.

• Action
  Get sheet

  Fetches a sheet by ID, including its columns and rows. An error occurs if the sheet is not found.

• Action
  List row attachments

  Returns the attachments on a row of a Smartsheet sheet, such as files and links, with their names, types and addresses.

• Action
  Move row to another sheet

  Moves a row from one sheet to another sheet. The placement of the cells in the destination sheet is determined by Smartsheet's logic.

• Action
  Two-way sync add or update a row

  Creates or updates a row in a sheet. For use only with two-way sync triggers. If a Row ID is supplied the row is updated; otherwise a new row is added.

• Action
  Update row

  Updates a row in a specified sheet. Provide the Row ID and cells as an array of {columnId, value}.

• Action
  Update sheet

  /sheets/{sheetId} - update sheet properties (name, project settings).

• Action
  Add community comment

  Adds a comment, or a reply to an existing comment, on a community post as the school owner.

• Action
  Add community post

  Creates a post in your SchoolMaker community, as the school owner, in an open category.

• Action
  Add conversation message

  Sends a message from an admin or moderator to an existing conversation group.

• Action
  Add lesson

  Creates a lesson in a section of a SchoolMaker program. New lessons are published by default.

• Action
  Add offer

  Creates a new offer in your SchoolMaker school, with its settings, program accesses and prices. Offers are unpublished unless you choose to publish them.

• Action
  Add program

  Creates a new program (course) in your SchoolMaker school.

• Action
  Add section

  Creates a new section in a SchoolMaker program. New sections are published unless you choose otherwise.

• Action
  Award badge

  Awards a badge to a school member. Repeating an award returns the existing award without notifying the member again.

• Action
  Create a Coaching Appointment

  Creates a coaching appointment of a chosen coaching type with the selected members and coaches.

• Action
  Create a Conversation

  Creates a conversation group with the chosen members and sends its first message.

• Action
  Delete Member

  Deletes a member from your SchoolMaker school, identified by member id or email.

• Action
  Delete offer

  Moves an offer to Trash and removes its accesses from members. Members are not deleted, and the offer can be restored from Trash.

• Action
  Delete program

  Moves a SchoolMaker program to Trash and removes its logo and cover.

• Action
  Get All Coaching Types

  Returns every coaching type in your SchoolMaker school, with its coaches and publication status.

• Action
  Get Member Accesses

  Returns all offer accesses held by a SchoolMaker member, looked up by member ID or email.

• Action
  Get Member Progress

  Returns a member's progress across their programs (completion rate, time spent, unfinished lessons), plus their offers, coaching usage, recent activity, community stats, leaderboard and level.

• Action
  Get Offer Details

  Returns the details of a SchoolMaker offer, including its prices, accesses and member counts.

• Action
  Get Program Details

  Returns the details of a program, optionally with a specific member's progress through it.

• Action
  Get Top 10 Members in Leaderboard

  Returns the school's gamification leaderboard ranking (top 10 members by default), optionally filtered by time range, minimum points, or community space.

• Action
  List badges

  Returns all badges defined in your SchoolMaker school, newest first.

• Action
  List lessons

  Returns the lessons in a section of a SchoolMaker program, ordered by position, optionally filtered by name.

• Action
  List Members

  Returns the members of your SchoolMaker school, optionally filtered by program, offer, points, level, coaching usage or access.

• Action
  List Offers

  Returns all offers in your SchoolMaker school, optionally filtered by published status.

• Action
  List Programs

  Returns all programs in your school, optionally only those a given member can access, with that member's progress.

• Action
  List sections

  Returns the sections in a SchoolMaker program, optionally filtered by section group or search text.

• Action
  Set a Drip Boost

  Sets the drip boost value for a member's access to an offer, unlocking dripped content sooner.

• Action
  Set Member Ban

  Bans or unbans a member of your SchoolMaker school, identified by member ID or email, and returns the member's details.

• Action
  Set Member Suspend

  Suspends or unsuspends a member of your SchoolMaker school, identified by member id or email.

• Action
  Set Offer Access for a Member / Add New Member

  Grants or revokes a member's access to an offer, creating the member if they don't exist yet.

• Action
  Set Offer Details

  Updates an existing offer's details, publish status, accesses and prices. Fields left blank keep their current values.

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