Connect Productive.io and Smartsheet

Both apps 64Productive.io 35Smartsheet 29

• Trigger
  New time entry

  Triggers when a new time entry is tracked in Productive.

• Action
  Add Comment to Deal

  Adds a comment to a deal in Productive.

• Action
  Add comment to task

  Adds a comment to a task in Productive.

• Action
  Add expense

  Creates a new expense in Productive, optionally allocated to a budget service.

• Action
  Add invoice

  Creates a new invoice for a client company in Productive.

• Action
  Add time entry

  Creates a time entry in Productive, logging minutes a person worked on a service (and optionally a task) on a given date.

• Action
  Create Booking

  Creates a booking that schedules a person's time on a service or an absence event over a date range in Productive.

• Action
  Create Company

  Creates a new company (client) in Productive with its billing, invoicing and contact details.

• Action
  Create Contact

  Creates a contact (person) in Productive, linked to a client company.

• Action
  Create Deal

  Creates a new deal in Productive with a name, owner, deal type and date, plus optional value, company, contact and other deal details.

• Action
  Create Project

  Creates a new project in Productive with a name, type, project manager and workflow, optionally linked to a client company.

• Action
  Create Service

  Creates a service (a billable line of work) on a Productive deal or budget.

• Action
  Create Task

  Creates a task in a Productive project task list, with optional assignee, dates, estimates, tags and recurrence.

• Action
  Create Task List

  Creates a task list inside a project folder in Productive.

• Action
  Delete task

  Permanently deletes a task in Productive.

• Action
  Find Company

  Finds companies in Productive by name or company code and returns the matches.

• Action
  Find Contact

  Finds contacts (client people) in Productive by search text, email or company, returning the matches and the first one.

• Action
  Find Deal

  Finds deals in Productive by name, number or company and returns the matches.

• Action
  Find invoices by criteria

  Returns invoices matching an invoice number and/or company, with the first match and a count.

• Action
  Find projects by criteria

  Finds projects matching a name, client company, project manager or status, returning the matches and the first one.

• Action
  Find Task

  Finds tasks matching a title, number, search text, project, task list, assignee or status, and returns the first match plus the full list.

• Action
  Find time entries by criteria

  Returns time entries matching the criteria you give, such as person, service, task or date range.

• Action
  Find User

  Finds users (team members) in your Productive organization by name or email and returns the matches.

• Action
  Get Booking

  Returns a single booking (resource-planning allocation of a person to a service or event) by its ID, including dates, hours and custom fields.

• Action
  Get Comment

  Returns a single comment by its ID, including its body, timestamps and the task, deal or other record it was posted on.

• Action
  Get Expense

  Returns a single expense by its ID, including amounts, dates, approval status, custom fields and related records.

• Action
  Get Service

  Returns a single service (a budget or deal line item) by its ID, including its attributes and custom field values.

• Action
  Get Task List

  Returns a single task list by its ID, including its name, position, archive status and its project, board and folder.

• Action
  Update booking

  Updates an existing booking in Productive, such as its dates, booked time, note or assigned service. Fields left blank are not changed.

• Action
  Update company

  Updates an existing company in Productive. Only the fields you fill in are changed.

• Action
  Update Contact

  Updates an existing contact (person) in Productive. Only the fields you fill in are changed.

• Action
  Update Deal

  Updates an existing deal or budget in Productive, changing only the fields you fill in.

• Action
  Update project

  Updates an existing project in Productive. Only the values you fill in are changed.

• Action
  Update Task

  Updates an existing task in Productive. Only the values you fill in are changed.

• Action
  Update time entry

  Updates an existing time entry in Productive, changing only the fields you fill in.

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

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