Connect Smartsheet and Teachworks

Both apps 74Smartsheet 29Teachworks 45

• 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).

• Trigger
  Lesson Completed

  Triggers when a lesson is marked completed in Teachworks.

• Trigger
  New Availability

  Triggers when a new availability block is added for a teacher or employee.

• Trigger
  New Cost Premium

  Triggers when a new cost premium is created in Teachworks.

• Trigger
  New Employee

  Triggers when a new employee (teacher or staff member) is added in Teachworks.

• Trigger
  New Invoice

  Triggers when a new invoice is created in Teachworks.

• Trigger
  New Lesson

  Triggers when a new lesson is scheduled in Teachworks.

• Trigger
  New Lesson Participant

  Triggers when a student is added to a lesson as a new lesson participant.

• Trigger
  New Location

  Triggers when a new location (or sub-location) is added in Teachworks.

• Trigger
  New Other Event

  Triggers when a new other event (such as an open house or staff meeting) is added to the Teachworks calendar.

• Trigger
  New Package Balance Alert

  Triggers when a customer's package balance is created or recalculated in Teachworks (for example after lessons use package units).

• Trigger
  New Payment

  Triggers when a new payment is recorded in Teachworks.

• Trigger
  New Refund

  Triggers when a new refund is recorded against a customer's payment in Teachworks.

• Trigger
  New Service

  Triggers when a new service is created in Teachworks.

• Trigger
  New Student

  Triggers when a new student is added in Teachworks.

• Trigger
  New Unavailability

  Triggers when a new unavailability (time off) is added for an employee in Teachworks.

• Trigger
  New Wage Payment

  Triggers when a new wage payment to an employee is recorded in Teachworks.

• Trigger
  New Wage Tier

  Triggers when a new wage tier is created in Teachworks.

• Action
  Add location

  Creates a new location in your Teachworks account.

• Action
  Add payment allocation

  Allocates part or all of a payment to an invoice.

• Action
  Add profile note

  Creates a profile note on a customer (family) or student.

• Action
  Add student to lesson

  Adds a student to an existing scheduled lesson and returns the updated lesson with its participants.

• Action
  Add wage payment

  Creates a wage payment for an employee in Teachworks.

• Action
  Complete lesson

  Completes a Teachworks lesson: sets attendance status for the lesson or each participant, and records charges and lesson notes.

• Action
  Create Child Student

  Creates a child student who belongs to a family, with their fees billed to that family.

• Action
  Create Employee

  Creates a new employee (teacher or staff member) in Teachworks.

• Action
  Create Family

  Creates a family customer in Teachworks. Families are billed for the lessons of their child students.

• Action
  Create Independent Student

  Creates an independent student in Teachworks: a directly billed customer together with its associated student record.

• Action
  Create Lesson

  Creates a single lesson in Teachworks with a teacher, service, students, location and start/end date and time.

• Action
  Create Payment

  Creates a payment received from a customer (family or independent student).

• Action
  Find Child Student

  Finds child students (students belonging to a family) matching the name, email, phone or other details you supply.

• Action
  Find Customer

  Finds customers (families and independent students) matching name, email, phone, address, type or status, and returns the first match plus all matches.

• Action
  Find Employee

  Finds employees (teachers and staff) matching the name, email, location, status or subject you give, and returns the first match plus the full list.

• Action
  Find Family

  Finds family customers in Teachworks matching the name, email, phone, address or status you supply, returning the first match and the full list.

• Action
  Find Independent Student (Full Details)

  Finds independent-student customers matching the search criteria and returns their full customer profile, including the student details and custom fields.

• Action
  Find Independent Student (Student Details)

  Finds independent students matching name, email, phone, school, status or other criteria and returns their student details.

• Action
  Find Payment

  Finds payments by customer and/or payment date, returning the first match and the full list of matching payments.

• Action
  Get lesson

  Returns a single lesson, including its time, teacher, service, location and participants.

• Action
  List lessons

  Returns lessons in your Teachworks account, optionally filtered by teacher, student, location, service, status or date range.

• Action
  Update customer

  Updates an existing customer in Teachworks — a family or an independent student — including contact details, status, notification preferences and invoice schedules.

• Action
  Update Customer Custom Field Values

  Sets the values of up to 10 custom profile fields on a Teachworks customer.

• Action
  Update employee

  Updates an existing employee's profile, wage settings and user permissions in Teachworks.

• Action
  Update lesson

  Updates an existing lesson's details, schedule, cost override and participants, and returns the updated lesson.

• Action
  Update payment

  Updates an existing payment's customer, date, amount, description, payment method or Stripe transaction ID.

• Action
  Update student

  Updates an existing child student in Teachworks, such as their name, contact details, status, billing and default teachers.

• Action
  Update Student Custom Field Values

  Sets the values of up to 10 custom profile fields on a Teachworks student.

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