DisputeFox + Email by Zapier + Filter by Zapier + Google Sheets + Formatter by Zapier + Microsoft Dynamics 365 CRM

Lookup Google Sheets rows and create Microsoft Dynamics 365 CRM contacts for new DisputeFox leads

Anytime a new lead is added in DisputeFox and their SSN exists, this template will lookup a Google Sheets row for the state ID and create a Microsoft Dynamics 365 CRM contact.

When this happens...
New Lead Added - Legacy
trigger fire after adding new Lead.
TriggerScheduled
automatically do this...
Only continue if...
Set up rules to specify when this Zap can continue running.
ActionFilter
then do this...
Lookup Spreadsheet Row
Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.
ActionSearch
then do this...
Numbers
Work with numeric data to do math operations, reformat currencies, and more (with line-item support).
ActionWrite
then do this...
Create Contact
Creates a new contact.
ActionWrite
then do this!
Send Outbound Email
Send up to 5 emails per day on Free or Trial Zapier plans, or up to 10 emails per hour on paid Zapier plans from a custom zapiermail.com address.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

What does this mean?

Affiliate Updated
Trigger fire after updating new affiliate.
Trigger
Instant
Try It
Client Updated
Triggers when client updated.
Trigger
Instant
Try It
Lead Updated
Triggers when lead updated.
Trigger
Instant
Try It
New Affiliate Added
trigger fire after adding new affiliate.
Trigger
Instant
Try It
New Client Added
Triggers when new client added.
Trigger
Instant
Try It

New Lead Added
Triggers when new lead added.
Trigger
Instant
Try It
New Task Added
Triggers when new task added.
Trigger
Instant
Try It

Task Updated
Triggers when existing task updated.
Trigger
Instant
Try It
- First NameRequired
- Middle Name
- Last NameRequired
- Email AddressRequired
- Cell Phone
- Home Phone
- Social Security Number
- Date of Birth
- Current Address
- Current City
- Current State
- Current Zipcode
- Previous Address
- Previous City
- Previous State
- Previous Zipcode
- Assigned To
- Sales Representative
- Status
- Folder
- Process
- Portal Access
- Setup Amount
- Monthly Amount
- Processing Issue
- Affiliate / Referral
- Monitoring Agency
- Username
- Password
- Secret Key
- Sticky Note
- Customer Type
Action
Write
- Event Begins AtRequired
- Attendee EmailRequired
- Event Assigned ToRequired
- Event Title / Subject
- Description
- Is this Complete?
Action
Write
- First NameRequired
- Middle Name
- Last NameRequired
- Email AddressRequired
- Cell Phone
- Home Phone
- Social Security Number
- Date Of Birth
- Current Address
- Current City
- Current State
- Current Zipcode
- Previous Address
- Previous City
- Previous State
- Previous Zipcode
- Credit Card Number
- Expiration (MM)
- Expiration (YYYY)
- Cvv
- Assigned To
- Sales Representative
- Status
- Folder
- Process
- Portal Access
- Setup Amount
- Monthly Amount
- Processing Issue
- Affiliate / Referral
- Monitoring Agency
- Username
- Password
- Secret Key
- Sticky Note
- Customer Type
Action
Write
- Only continue if...Required
Action
Filter
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite existing worksheets
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Text Bold
- Text Italic
- Text Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
- Row Count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row CountRequired
- First Row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite existing worksheets
Action
Search or write
- TransformRequired
Action
Write
- TransformRequired
Action
Write
New Account
Triggers when a new account is created.
Trigger
Scheduled
Try It
New Contact
Triggers when a new contact is created.
Trigger
Scheduled
Try It
- Custom EntityRequired
Trigger
Scheduled
Try It
- Info
Trigger
Scheduled
Try It
- Info
Trigger
Scheduled
Try It
- Info
Trigger
Scheduled
Try It
- Info
Trigger
Scheduled
Try It
- Info
Trigger
Scheduled
Try It
- Info
- Owner
Action
Write
- Info
- Owner
Action
Write
- Info
- Customer typeRequired
- Status
Action
Write
- Info
- Owner
Action
Write
- Info
- Owner
Action
Write
- Info
- AccountRequired
Action
Write
- Info
- ContactRequired
Action
Write
- Info
- Case/IncidentRequired
- State
Action
Write
- Info
- LeadRequired
Action
Write
- Info
- OrderRequired
Action
Write
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Search By Email Only
Action
Search
- Info
- Info Field Enable
- Custom EntityRequired
- Match if any of the fields match (otherwise only match if all the fields match)
- Search By Email Only
Action
Search
- State Code
Action
Search
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Search By Email Only
- Owner
Action
Search or write
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Owner
Action
Search or write
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Owner
Action
Search or write
- Email AddressRequired
Trigger
Instant
Try It
- Free Test Limitation
- ToRequired
- SubjectRequired
- Body (HTML or Plain)Required
- Attachment
- From Name
- Reply To
- Cc
- Bcc
- Force Linebreaks?
- Enable read receipts?
Action
Write

Affiliate Updated - Legacy
Trigger fire after updating new affiliate.
Trigger
Scheduled
Try It
Client Updated - Legacy
Trigger fire after updating new client.
Trigger
Scheduled
Try It
Lead Updated - Legacy
Trigger fire after updating new lead.
Trigger
Scheduled
Try It
New Affiliate Added - Legacy
trigger fire after adding new affiliate.
Trigger
Scheduled
Try It
New Client Added - Legacy
trigger fire after adding new client.
Trigger
Scheduled
Try It
New Lead Added - Legacy
trigger fire after adding new Lead.
Trigger
Scheduled
Try It
New Task Added - Legacy
Triggers when new task added.
Trigger
Scheduled
Try It
Task Updated - Legacy
Triggers when existing task updated.
Trigger
Scheduled
Try It
- First NameRequired
- Middle Name
- Last NameRequired
- Email AddressRequired
- Cell Phone
- Home Phone
- Social Security Number
- Date Of Birth
- Current Address
- Current City
- Current State
- Current Zipcode
- Previous Address
- Previous City
- Previous State
- Previous Zipcode
- Credit Card Number
- Expiration (MM)
- Expiration (YYYY)
- Cvv
- Assigned To
- Sales Representative
- Status
- Folder
- Process
- Portal Access
- Setup Amount
- Monthly Amount
- Processing Issue
- Affiliate / Referral
- Monitoring Agency
- Username
- Password
- Secret Key
- Sticky Note
- Customer Type
Action
Write
- First NameRequired
- Middle Name
- Last NameRequired
- Email AddressRequired
- Cell Phone
- Home Phone
- Social Security Number
- Date Of Birth
- Current Address
- Current City
- Current State
- Current Zipcode
- Previous Address
- Previous City
- Previous State
- Previous Zipcode
- Credit Card Number
- Expiration (MM)
- Expiration (YYYY)
- Cvv
- Assigned To
- Sales Representative
- Status
- Folder
- Process
- Portal Access
- Setup Amount
- Monthly Amount
- Processing Issue
- Affiliate / Referral
- Monitoring Agency
- Username
- Password
- Secret Key
- Sticky Note
- Customer Type
Action
Write
- First NameRequired
- Middle Name
- Last NameRequired
- Email AddressRequired
- Cell Phone
- Home Phone
- Social Security Number
- Date Of Birth
- Current Address
- Current City
- Current State
- Current Zipcode
- Previous Address
- Previous City
- Previous State
- Previous Zipcode
- Credit Card Number
- Expiration (MM)
- Expiration (YYYY)
- Cvv
- Assigned To
- Sales Representative
- Status
- Folder
- Process
- Portal Access
- Setup Amount
- Monthly Amount
- Processing Issue
- Affiliate / Referral
- Monitoring Agency
- Username
- Password
- Secret Key
- Sticky Note
- Customer Type
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Drive
Trigger
Scheduled
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search or write
- TransformRequired
Action
Write
- TransformRequired
Action
Write
- Info
Trigger
Scheduled
Try It
- Info
Trigger
Scheduled
Try It
New Case/Incident
Triggers when a new case/incident is created.
Trigger
Scheduled
Try It
New Invoice
Triggers when a new invoice is created.
Trigger
Scheduled
Try It
New Lead
Triggers when a new lead is created.
Trigger
Scheduled
Try It
New Opportunity
Triggers when a new opportunity is created.
Trigger
Scheduled
Try It
New Order
Triggers when a new order is created.
Trigger
Scheduled
Try It
- Info
Trigger
Scheduled
Try It
- Owner
Action
Write
- Owner
Action
Write
- Custom EntityRequired
Action
Write
- Info
- Owner
Action
Write
- Info
- Owner
Action
Write
- Owner
Action
Write
- Info
- Custom Entity ActionRequired
Action
Write
- Info
- InvoiceRequired
Action
Write
- Info
- OpportunityRequired
Action
Write
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Search By Email Only
Action
Search
- Campaign NameRequired
Action
Search
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Search By Email Only
- Owner
Action
Search or write
- Info
- Info Field Enable
- Custom EntityRequired
- Match if any of the fields match (otherwise only match if all the fields match)
- Search By Email Only
Action
Search or write
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Owner
Action
Search or write
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Owner
Action
Search or write
- Setup Directions
Trigger
Instant
Try It

About DisputeFox

DisputeFox was designed from the ground up to be the World's Most Advanced All-in-One Credit Dispute Software.

Related categories

CRM (Customer Relationship Management)

Similar apps

Zapier Interfaces

App Builder, CRM (Customer Relationship Management), Forms & Surveys, Zapier

About Email by Zapier

Send and receive email via a custom Zapier email address at "zapiermail.com". This is great for triggering off of emails and sending custom emails. (Max of 10 email sends per hour.) Have direct access to your own email servers? Check out our IMAP and SMTP services!

Learn more

Related categories

About Filter by Zapier

Only allow a Zap to proceed when a certain condition is met. For example, if you're sending a text message when you receive a new email, you could use a Filter that only sends a text message when the email received is from a certain address.

Learn more

Related categories

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more

Related categories

Similar apps

About Formatter by Zapier

Data isn't always in the format you need. Perhaps a date is in International format, but your app needs it in American format. Or maybe you need to Title Case a subject, truncate text for a Tweet, or turn Markdown text into HTML for your blog. Zapier's Formatter tool can help.

Learn more

Related categories

About Microsoft Dynamics 365 CRM

Microsoft Dynamics is built for any device, anywhere. Built for you. For Dynamics Version 9 and Dynamics 365.

Learn more

DisputeFox + Email by Zapier + Filter by Zapier + Google Sheets + Formatter by Zapier + Microsoft Dynamics 365 CRM

Lookup Google Sheets rows and create Microsoft Dynamics 365 CRM contacts for new DisputeFox leads

Affiliate Updated

Client Updated

Lead Updated

New Affiliate Added

New Client Added

New Lead Added

New Task Added

Task Updated

Add New Lead

Add New Event

Add / Update Lead

Only continue if...

New Spreadsheet Row

New or Updated Spreadsheet Row (Team Drive)

New Worksheet

Create Spreadsheet Row

Copy Worksheet

Create Worksheet

Format Spreadsheet Row

Update Spreadsheet Row(s)

Lookup Spreadsheet Rows (Advanced)

Get many Spreadsheet Rows (Advanced)

Find or Create Worksheet

Date / Time

Text

New Account

New Contact

New Custom Entity

Updated Case/Incident

Updated Invoice

Updated Lead

Updated Opportunity

Updated Order

Create Account

Create Contact

Create Case/Incident

Create Invoice

Create Opportunity

Update Account

Update Contact

Update Case/Incident

Update Lead

Update Order

Find Account

Find Custom Entity

Find Campaign Response

Find Lead

Find Order

Find or Create Contact

Find or Create Invoice

Find or Create Opportunity

New Inbound Email

Send Outbound Email

Affiliate Updated - Legacy

Client Updated - Legacy

Lead Updated - Legacy

New Affiliate Added - Legacy

New Client Added - Legacy

New Lead Added - Legacy

New Task Added - Legacy

Task Updated - Legacy

Add New Client

Add / Update Client

Update Client / Lead

New Spreadsheet Row (Team Drive)

New Spreadsheet

New or Updated Spreadsheet Row

Create Spreadsheet Column

Create Multiple Spreadsheet Rows

Create Spreadsheet

Clear Spreadsheet Row

Update Spreadsheet Row

API Request (Beta)

Find Worksheet

Lookup Spreadsheet Row

Find or Create Row

Numbers

Utilities