Connect Apollo and SQL Server

Both apps 25Apollo 14SQL Server 11

• Trigger
  Account Updated

  Polls Apollo accounts/search for new or updated accounts (dedup on MD5 of the record; accounts/search returns no updated_at). Apollo has no record-change webhook API, so this is a polling trigger.

• Trigger
  Contact Updated

  Polls Apollo contacts/search for new or updated contacts (dedup on MD5 of the record). Apollo has no record-change webhook API, so this is a polling trigger.

• Trigger
  New Account

  Polls Apollo accounts/search for newly created accounts (dedup on account id). Apollo has no record-change webhook API, so this is a polling trigger.

• Trigger
  New Contact

  Polls Apollo contacts/search for newly created contacts (dedup on contact id). Apollo has no record-change webhook API, so this is a polling trigger.

• Action
  Create Account

  An Account is a company that your team has added to Apollo.

• Action
  Create Contact

  A Contact is a person your team has added to Apollo.

• Action
  Create Deal

  Deals are records that you can use to track possible opportunities with your prospective customers.

• Action
  Create Task

  Creates a task for the specified Apollo contact (via /tasks/bulk_create with a single contact).

• Action
  Find Contact

  Find a contact in your Apollo instance by searching for their email. If you have multiple contacts with the same email address, this search returns the contact that was created first.

• Action
  Find Deal

  Returns up to 100 deals (opportunities) that match the specified name. Leave name blank to return all deals.

• Action
  Find Task

  Returns up to 100 tasks for the specified contact. Leave contact_id blank to return all tasks.

• Action
  Get Account

  Returns the details of an existing Apollo account (a company saved in Apollo), including its custom field values.

• Action
  Update Account

  Update an existing Account.

• Action
  Update Contact

  Update an already existing Contact.

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