Connect DonorPerfect and Smartsheet via API Token

Both apps 145DonorPerfect 42Smartsheet via API Token 103

• Trigger
  New donor

  Polling trigger. Fires when a new donor is added in DonorPerfect. Polls the dp table ordered by donor_id descending; dedups on each record's donor_id.

• Trigger
  New gift

  Polling trigger. Fires when a new gift (donation) is created in DonorPerfect. Polls the dpgift table ordered by gift_id descending; dedups on each record's gift_id.

• Trigger
  New or updated donor

  Triggered when a donor is added or updated.

• Trigger
  New or updated gift

  Triggered when a gift (donation) is created or modified.

• Trigger
  Two-way sync new or updated donors

  A trigger for two-way syncing new and updated donors, with enhanced on-the-fly mapping. Can only be used with enhanced two-way sync actions that support on-the-fly mapping.

• Trigger
  Two-way sync new or updated gifts

  A trigger for two-way syncing new and updated gifts (donations), with enhanced on-the-fly mapping. Polls the DonorPerfect dpgift table.

• Action
  Add code

  Adds a new code and description to the DPCODES table. Allows you to add things like new GL Code, Solicitation, Campaign code and other code values administered in the Code Maintenance screen of DPO.

• Action
  Add contact

  Adds a contact (activity/task) record to a donor in DonorPerfect via the dp_savecontact stored procedure. Supply Donor Id, Activity Code, and contact details.

• Action
  Add donor

  Creates a new donor in DonorPerfect via the dp_savedonor stored procedure. Leave Donor Id empty (0) to create; the new donor_id is returned. Common fields: first/last name, address, city, state, zip, email, phones.

• Action
  Add gift

  Creates a new gift (donation) for a donor in DonorPerfect via the dp_savegift stored procedure. Supply Donor Id, Amount, Gift Date and code fields (GL, Solicit, Sub-solicit, Gift Type, Campaign).

• Action
  Add new donor gift

  Creates a new donation (gift) for the donor with the specified ID.

• Action
  Add new donor gift by email

  Creates a new donation for the donor with the specified email. The gift will only be added if the donor's email is found.

• Action
  Add new pledge

  Adds a new pledge to the specified donor. If successful, the pledge's ID is output.

• Action
  Add other info

  Adds an Other Info record to a donor in DonorPerfect via the dp_saveotherinfo stored procedure. Supply Donor Id, and optionally the date and comments.

• Action
  Add other info by email

  Adds "other info" for the first donor found with the given email address. The other info is not added if the email address is not found.

• Action
  Delete donor

  Deletes the donor with the specified Donor Id from DonorPerfect via the dp_deletedonor stored procedure.

• Action
  Find donor by first and last name

  Returns the first donor whose first and last name exactly match, plus how many donors matched

• Action
  Find filters by name

  Returns one or more filters that match the specified name. Supports wildcard matching. An empty result is returned if no matching filter is found.

• Action
  Get 20 donor field values

  Returns up to 20 field values for the specified donor. An error occurs if the donor is not found.

• Action
  Get active code by description

  Returns the code having the specified description. An error occurs if the code is not found or is inactive.

• Action
  Get active code description

  Gets the specified code's description. An error occurs if the code is not found or is inactive.

• Action
  Get code description

  Returns the description for a code value in the specified DPO code field (e.g. GL, CAMPAIGN, SOLICIT) from the dpcodes table.

• Action
  Get contact

  Returns a single DonorPerfect contact (activity) record by its contact ID, with its standard contact columns.

• Action
  Get donor

  Returns all available fields for the donor with the specified Donor ID from the DPO donor (dp) table.

• Action
  Get donor by email

  Returns the DonorPerfect donor whose email address matches the one supplied, with the donor's standard fields. Use Get donor user-defined field values for custom fields. An error occurs if no donor has that email address.

• Action
  Get donor by email, first name, and last name

  Returns all available donor fields if one or more donor matches the email, first name, and last name. No error occurs if a donor is not found, the emitted 'donor_id' will be empty instead.

• Action
  Get donor default field info

  Returns information about the specified donor field.

• Action
  Get donor default fields

  Returns all default fields for donors.

• Action
  Get donor gifts

  Returns all gifts (donations) for the donor with the specified Donor ID from the DPO dpgift table.

• Action
  Get donors by filter

  Returns the donor IDs that match the saved DPO filter with the specified Filter ID, via the dp_filterids stored procedure.

• Action
  Get donor user-defined field info

  Returns information about the specified donor user-defined field.

• Action
  Get donor user-defined fields

  Returns all user-defined donor fields.

• Action
  Get donor user-defined field values

  Returns all user-defined field values for the specified donor. An error occurs if the donor is not found.

• Action
  Get field display type

  Gets the specified field's display type, which can either be "code" or "description"

• Action
  Get flags by donor ID

  Returns the specified donor's flags. No error occurs if the donor is not found.

• Action
  Get gift

  Returns all fields for the gift (donation) with the specified Gift ID from the DPO dpgift table.

• Action
  Get gift user-defined field values

  Returns all user-defined field values for the specified gift (donation). An error occurs if the gift is not found.

• Action
  Get other info

  Returns one DonorPerfect Other Info record by its id, with its standard columns.

• Action
  List filters

  Returns the ID and name of all saved DPO filters that have non-empty names from the dpfilter table.

• Action
  Post pledge payment

  Posts a payment to the specified pledge for the specified donor.

• Action
  Set gift custom field

  Sets one of your organization's custom fields (such as Class) on an existing gift

• Action
  Update donor

  Updates an existing donor in DonorPerfect via the dp_savedonor stored procedure. Supply the Donor Id of the record to update along with the field values.

• Trigger
  List contacts

  List contacts

• Trigger
  List dashboards

  List dashboards

• Trigger
  List org groups

  List org groups

• Trigger
  List reports

  List reports

• Trigger
  List sheets

  List sheets

• Trigger
  List workspaces

  List workspaces

• Trigger
  New favorite

  Triggers when a new item is added to your favorites.

• Trigger
  New row

  Polling trigger: fires when a new row is added to the specified sheet. Each row carries a stable id for deduplication.

• Trigger
  New search result

  Triggers when a new item matches your search query.

• Action
  Add columns

  Add columns

• Action
  Add favorites

  Add favorites

• Action
  Add image to cell

  Add image to cell

• Action
  Add rows

  Add one or more rows to a sheet. Provide an array of row objects with cells.

• Action
  Add summary fields

  Add summary fields

• Action
  Attach file or URL to comment

  Attach file or URL to comment

• Action
  Attach file or URL to row

  Attach file or URL to row

• Action
  Attach file or URL to sheet

  Attach file or URL to sheet

• Action
  Attach new version

  Attach new version

• Action
  Copy folder

  Copy folder

• Action
  Copy rows to another sheet

  Copy rows to another sheet

• Action
  Copy sheet

  Copy sheet

• Action
  Copy workspace

  Copy workspace

• Action
  Create a comment

  Create a comment

• Action
  Create a discussion on a row

  Create a discussion on a row

• Action
  Create an update request

  Create an update request

• Action
  Create cross-sheet references

  Create cross-sheet references

• Action
  Create discussion

  Create discussion

• Action
  Create folder

  Create a folder in the user's Home.

• Action
  Create folder in workspace

  Create folder in workspace

• Action
  Create proof

  Create proof

• Action
  Create proof discussion

  Create proof discussion

• Action
  Create proof request

  Create proof request

• Action
  Create sheet

  Creates a new sheet with the given name and columns in the user's home "Sheets" area. To create a sheet inside a specific folder or workspace, use Create sheet in folder or Create sheet in workspace.

• Action
  Create sheet in folder

  Create sheet in folder

• Action
  Create sheet in workspace

  Create sheet in workspace

• Action
  Create workspace

  Create workspace

• Action
  Delete a comment

  Delete a comment

• Action
  Delete a discussion

  Delete a discussion

• Action
  Delete an update request

  Delete an update request

• Action
  Delete attachment

  Delete attachment

• Action
  Delete column

  Delete column

• Action
  Delete favorites

  Removes one or more objects of a given type from the user's Smartsheet favorites. Accepts a single object ID or a comma-separated list.

• Action
  Delete folder

  Delete folder

• Action
  Delete report

  Delete report

• Action
  Delete rows

  Delete rows

• Action
  Delete sent update request

  Delete sent update request

• Action
  Delete sheet

  Delete a sheet by id.

• Action
  Delete summary fields

  Delete summary fields

• Action
  Delete workspace

  Delete workspace

• Action
  Edit a comment

  Edit a comment

• Action
  Get a comment

  Get a comment

• Action
  Get an update request

  Get an update request

• Action
  Get attachment

  Get attachment

• Action
  Get column

  Get column

• Action
  Get contact

  Get contact

• Action
  Get cross-sheet reference

  Get cross-sheet reference

• Action
  Get discussion

  Get discussion

• Action
  Get folder metadata

  Get folder metadata

• Action
  Get proof

  Get proof

• Action
  Get report

  Get report

• Action
  Get row

  Get a single row from a sheet by row id.

• Action
  Get sent update request

  Get sent update request

• Action
  Get sheet

  Get a sheet by id, including its rows and columns.

• Action
  Get sheet summary

  Get sheet summary

• Action
  Get summary fields

  Get summary fields

• Action
  Get user

  Get user

• Action
  Get workspace

  Retrieves a Smartsheet workspace by ID, including its sheets, folders, reports, sights, templates, permalink, and access level.

• Action
  Is favorite

  Is favorite

• Action
  List attachments

  List attachments

• Action
  List columns

  List all columns of a sheet.

• Action
  List contents

  List contents

• Action
  List cross-sheet references

  List cross-sheet references

• Action
  List discussion attachments

  List discussion attachments

• Action
  List discussions

  List discussions

• Action
  List discussions with a row

  List discussions with a row

• Action
  List folder children

  List folder children

• Action
  List folders

  List the folders in the user's Home.

• Action
  List proof attachments

  List proof attachments

• Action
  List proofs

  List proofs

• Action
  List row attachments

  List row attachments

• Action
  List sheet rows

  Convenience read: returns the rows of a sheet (the full sheet object with rows and columns).

• Action
  List sheets

  List all sheets the user has access to.

• Action
  Lists sent update requests

  Lists sent update requests

• Action
  List update requests

  List update requests

• Action
  List workspace children

  List workspace children

• Action
  List workspaces

  List all workspaces the user has access to.

• Action
  Move folder

  Move folder

• Action
  Move rows to another sheet

  Move rows to another sheet

• Action
  Move sheet

  Move sheet

• Action
  Search

  Search across all sheets the user can access for the given text.

• Action
  Search sheet

  Search a specific sheet for the given text.

• Action
  Send report via email

  Send report via email

• Action
  Send rows via email

  Send rows via email

• Action
  Send sheet via email

  Send sheet via email

• Action
  Sort rows in sheet

  Sort rows in sheet

• Action
  Update an update request

  Update an update request

• Action
  Update column

  Update column

• Action
  Update folder

  Update folder

• Action
  Update proof status

  Update proof status

• Action
  Update rows

  Update one or more existing rows in a sheet. Provide an array of row objects each with an id and cells.

• Action
  Update sheet

  Update sheet

• Action
  Update summary fields

  Update summary fields

• Action
  Update workspace

  Update workspace

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