Salesforce + Snowflake + Service Objects

Validate new Salesforce contact addresses with Service Objects and create Snowflake rows

Keep Snowflake up to date with clean, standardized address data. When a new Salesforce contact is created, this Zap validates the address through Service Objects’ AV3 API and adds the corrected and DPV-verified results to Snowflake rows for accurate analytics and reporting.

When this happens...
New Contact
Triggers when a new Contact is created.
TriggerPolling
automatically do this...
AV3 GetBestMatches
Our industry-leading, GetBestMatches operation combines Delivery Point Validation (DPV) to verify an address is deliverable, Residential Delivery Indicator (RDI) to identify residential or business, and SuiteLink (SLK) to add secondary suite information for businesses, into one robust API call to our USPS CASS Certified database engine.
ActionWrite
then do this!
Create Rows
Insert data into a table by specifying the column names and values to insert.
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

New Case Attachment
Triggers when a new Attachment is added to a case.
Trigger
Polling
Try It
- History ObjectRequired
Trigger
Polling
Try It
New Lead
Triggers when a new Lead is created.
Trigger
Polling
Try It
- Salesforce ObjectsRequired
Trigger
Polling
Try It
- Salesforce ObjectRequired
Trigger
Polling
Try It

- Salesforce ObjectRequired
- RecordRequired
- FileRequired
- VisibilityRequired
Action
Write
- Path after /services/apexrest/Required
- HTTP methodRequired
- Query parameters
- Extra headers
- Request body
- Timeout
Action
Write

- FileRequired
- Salesforce ObjectRequired
- Description
- Attachment visibility
Action
Write
Create Contact
Creates a new contact.
Action
Write
- FileRequired
- Title
- Description
- Salesforce Object
Action
Write
- Note TitleRequired
- Note
- Salesforce ObjectRequired
- Note Visibility
- Use Assignment Rules
Action
Write
- Salesforce ObjectRequired
- Use Assignment Rules
- Allow Duplicates
Action
Write
- FlowRequired
- Manual flow input parameters
Action
Write
- ToRequired
- CC
- BCC
- SubjectRequired
- Email FormatRequired
- Sender TypeRequired
Action
Write
- Lead to UpdateRequired
- Use Assignment Rules
Action
Write
- Salesforce ObjectRequired
- Record to UpdateRequired
- Use Assignment Rules
Action
Write
- Query TypeRequired
- Include Deleted Records
Action
Search
- Salesforce ObjectRequired
- Search ValueRequired
- Second Field to Search By
- Second Search Value
- Search Operator
Action
Search
- Salesforce ObjectRequired
Action
Search
- Salesforce ObjectRequired
- Record IDRequired
Action
Search
- Salesforce ObjectRequired
- SOQL WHERE ClauseRequired
- Sort by
- Sort Order
- Maximum Number of Records
- Use Assignment Rules
- Allow Duplicates
Action
Search or write
- EnvironmentRequired
- BusinessName
- AddressRequired
- Address2
- City
- State
- PostalCode
Action
Write
- EnvironmentRequired
- AddressRequired
- City
- State
- PostalCode
Action
Write
- EnvironmentRequired
- EmailAddressRequired
- AllowCorrectionsRequired
- TimeoutRequired
Action
Write
- Environment
- NameRequired
- Option
Action
Write
- The table to look for new columns on.Required
Trigger
Polling
Try It
New Table
Triggers when a new table is created.
Trigger
Polling
Try It
- TableRequired
- Columns to Return
- Updated Date ColumnRequired
- Primary Key
Trigger
Polling
Try It
- Disclaimer
- TableRequired
- Primary Key ColumnRequired
- Primary Key ValuesRequired
Action
Write
- TableRequired
- Primary Key ColumnRequired
- Primary Key ValuesRequired
- Column NameRequired
Action
Write

New Contact
Triggers when a new Contact is created.
Trigger
Polling
Try It
- Salesforce ObjectRequired
- Record (Optional)
Trigger
Polling
Try It
New Outbound Message
Triggers when a new outbound message is received in Salesforce.
Trigger
Instant
Try It
- Disclaimer
- Salesforce ObjectRequired
Trigger
Polling
Try It
- CampaignRequired
- ContactRequired
Action
Write
- CampaignRequired
- LeadRequired
Action
Write
- LeadRequired
- AccountRequired
- Opportunity
- Create new opportunity?
- Converted StatusRequired
Action
Write
- Parent ObjectRequired
- Use Assignment Rules
Action
Write
- Note TitleRequired
- Note ContentRequired
- Salesforce Object
Action
Write
- Use Assignment Rules
Action
Write
- Salesforce ObjectRequired
- Use Assignment Rules
- Allow Duplicates
Action
Write
- Warning
- Salesforce ObjectRequired
- Record IDRequired
Action
Write
- ReportRequired
- Include details
- Number of custom filters
- Row groupings
- Column groupings
- Summary calculations
- Detail columns
- Sort order
- Report format
- Advanced report options
Action
Write
- Contact to UpdateRequired
Action
Write
- Salesforce ObjectRequired
- Record to UpdateRequired
- Use Assignment Rules
Action
Write
- Api Docs Info
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Parent ObjectRequired
Action
Search
- Salesforce ObjectRequired
- SOQL WHERE clauseRequired
Action
Search
- Salesforce ObjectRequired
- SOQL WHERE ClauseRequired
- Sort by
- Sort Order
- Maximum Number of Records
Action
Search
- Salesforce ObjectRequired
- Search ValueRequired
- Second Field to Search By
- Second Search Value
- Search Operator
- Use Assignment Rules
- Allow Duplicates
Action
Search or write
- EnvironmentRequired
- AddressRequired
- City
- State
- PostalCode
Action
Write
- EnvironmentRequired
- BusinessName
- AddressRequired
Action
Write
- EnvironmentRequired
- City
- State
- ZIP
Action
Write
- EnvironmentRequired
- FullName
- Salutation
- FirstName
- LastName
- BusinessName
- BusinessDomain
- BusinessEIN
- Address1
- Address2
- Address3
- Address4
- Address5
- Locality
- AdminArea
- PostalCode
- CountryRequired
- Phone1
- Phone2
- Email
- IPAddress
- Gender
- DateOfBirth
- UTCCaptureTime
- OutputLanguageRequired
- TestType
Action
Write
- Environment
- PhoneRequired
- Country
- Options
Action
Write
- SQL StatementRequired
- Primary Key
Trigger
Polling
Try It
New View
Triggers when a new view is created (from yesterday onwards).
Trigger
Polling
Try It
- TableRequired
- Column NameRequired
Action
Write
- SQL StatementRequired
Action
Write
- TableRequired
- Column Name
- Where ClauseRequired
Action
Search

About Salesforce

Salesforce is a leading enterprise customer relationship manager (CRM) application.

Learn more

Related categories

CRM (Customer Relationship Management)

Similar apps

Zapier Interfaces

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

About Snowflake

Snowflake allows corporate users to store and analyze data using cloud-based hardware and software.

Learn more

Related categories

Databases

About Service Objects

Service Objects is a contact and data validation company.

Related categories

Developer Tools

Related Zap Templates

Get geocoordinates for new Salesforce contacts with Service Objects and create Snowflake rows

Salesforce + Snowflake + Service Objects

Validate new Salesforce contact addresses with Service Objects and create Snowflake rows

New Case Attachment

New Field History Tracking Event

New Lead

New Record

Updated Record

Add File to Record

Call Apex REST

Create Attachment

Create Contact

Create File

Create Note

Create Record (UTC)

Launch Flow

Send Email

Update Lead

Update Record (UTC)

Custom SOQL Query

Find Record

Find Records

Get Record Attachments

Find or Create Record by Query

AV3 GetBestMatches

AV3 GetSecondaryNumbers

EV3 ValidateEmailAddress

NV2 NameInfoV2

New Column

New Table

New or Updated Row

Delete Rows

Update Rows

New Contact

New or Updated File on Record

New Outbound Message

Updated Field on Record

Add Contact to Campaign

Add Lead to Campaign

Convert Lead to Contact

Create Child Records (with line item support)

Create Enhanced Note

Create Lead

Create Record

Delete Record

Run Report

Update Contact

Update Record

API Request (Beta)

Find Child Records

Find Records by Query

Find Record by Query

Find or Create Record

AGUS GetBestMatch_V4

AV3 GetBestMatchesSingleLine

AV3 ValidateCityStateZip

LVI ValidateLeadInternational

PVI GetPhoneDetails

New Row

New View

Create Rows

Execute SQL

Find Row

About Salesforce

Related categories

Similar apps

Zapier Interfaces

About Snowflake

Related categories

About Service Objects

Related categories

Related Zap Templates

Related Zap Templates