Connect Freshworks CRM and SQL Server

Both apps 34Freshworks CRM 23SQL Server 11

• Trigger
  New Account

  Polling trigger: fires when a new sales account is created. Sorted by created_at descending.

• Trigger
  New Contact

  Polling trigger: fires when a new contact is created. Sorted by created_at descending.

• Trigger
  New Deal

  Polling trigger: fires when a new deal is created. Sorted by created_at descending.

• Trigger
  New or Updated Account

  Polling trigger: fires when a sales account is created or updated. Sorted by updated_at descending.

• Trigger
  New or Updated Contact

  Polling trigger: fires when a contact is created or updated. Sorted by updated_at descending.

• Trigger
  New or Updated Deal

  Polling trigger: fires when a deal is created or updated. Sorted by updated_at descending.

• Action
  Add Note to Contact

  Adds a note to a contact (targetable_type=Contact) in Freshworks CRM.

• Action
  Create Account

  Creates a new sales account in Freshworks CRM.

• Action
  Create Appointment

  Creates an appointment in Freshworks CRM. from_date/end_date are ISO8601.

• Action
  Create Contact

  Creates a new contact in Freshworks CRM.

• Action
  Create Deal

  Creates a new deal in Freshworks CRM.

• Action
  Create Task

  Creates a task in Freshworks CRM. due_date is epoch milliseconds; targetable_type e.g. Contact/Deal/SalesAccount.

• Action
  Find Account by Name

  Looks up a sales account by name using the lookup endpoint.

• Action
  Find Contact by Email

  Looks up a contact by email address using the lookup endpoint.

• Action
  Find deal by custom field

  Searches for a deal by the selected custom field. If a single match is found, emits the deal's details. If none or multiple match, an error occurs.

• Action
  Find deal by name

  Searches for a deal by name. If a single match is found, emits the deal's details. If none or multiple match, an error occurs.

• Action
  Find deal stage by name

  Searches for a deal stage by name. If a single match is found, emits the stage's details. If none or multiple match, an error occurs.

• Action
  Find pipeline by name

  Searches for a pipeline by name. If a single match is found, emits the pipeline's details. If none or multiple match, an error occurs.

• Action
  Get Account

  Retrieves a sales account by ID in Freshworks CRM.

• Action
  Get Contact

  Retrieves a contact by ID in Freshworks CRM.

• Action
  Get Deal

  Retrieves a deal by ID in Freshworks CRM.

• Action
  Update Contact

  Updates an existing contact by ID in Freshworks CRM.

• Action
  Update Deal

  Updates an existing deal by ID in Freshworks CRM.

• Trigger
  New or Updated Row

  Triggers when a new row is added or modified.

• Trigger
  New or Updated Row (Custom Query)

  Fires for each new or changed row returned by a SELECT statement you write against the connected SQL Server database.

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected SQL Server database.

• Action
  Add Row

  Add one row to a table on the connected SQL Server database.

• Action
  Delete Row

  Delete the rows in a table whose chosen column equals a value.

• Action
  Find Row

  Find the first row in a table whose chosen column matches a value.

• Action
  Find Rows via Custom Query

  Runs a SELECT statement you write against the connected SQL Server database and returns every row it matches.

• Action
  Find Row via Custom Query

  Runs a SELECT statement you write against the connected SQL Server database and returns the first row it matches.

• Action
  Run Custom Statement

  Runs a statement you write against the connected SQL Server database that changes data rather than returning rows, and reports how many rows it changed.

• Action
  Update Row

  Change column values on every row of a table whose chosen column matches a value.

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