How to connect Google Sheets + Salesforce + Usherpa
Zapier lets you send info between Google Sheets and Salesforce and Usherpa automatically—no code required. With 8,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with Google Sheets + Salesforce + Usherpa
With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with Google Sheets, Salesforce, and Usherpa. And don’t forget that you can add more apps and actions to create complex workflows.
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNew Case Attachment
Triggers when a new Attachment is added to a case.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Lead
Triggers when a new Lead is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planSalesforce ObjectRequired
RecordRequired
FileRequired
VisibilityRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LeadRequired
AccountRequired
Opportunity
Create new opportunity?
Converted StatusRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Parent ObjectRequired
Use Assignment Rules
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Note TitleRequired
Note ContentRequired
Salesforce Object
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Use Assignment Rules
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Salesforce ObjectRequired
Use Assignment Rules
Allow Duplicates
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Warning
Salesforce ObjectRequired
Record IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact to UpdateRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Salesforce ObjectRequired
Record to UpdateRequired
Use Assignment Rules
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Salesforce ObjectRequired
Search ValueRequired
Second Field to Search By
Second Search Value
Search Operator
ActionThis is an event a Zap performs.SearchFind existing data in your appSalesforce ObjectRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSalesforce ObjectRequired
Record IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSalesforce ObjectRequired
SOQL WHERE ClauseRequired
Sort by
Sort Order
Maximum Number of Records
Use Assignment Rules
Allow Duplicates
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundExport Usherpa Loans
Export new or updated loans from Usherpa.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planLoan IdentifierRequired
Loan Officer EmailRequired
Borrower First Name
Borrower Middle Name
Borrower Last NameRequired
Borrower Salutation
Borrower Nick Name
Borrower Mobile Phone
Borrower Work Phone
Borrower Home Phone
Borrower Email
Borrower Best Way To Contact
Borrower Mailing Address
Borrower Mailing City
Borrower Mailing State
Borrower Mailing Postal Code
Borrower Company Name
Borrower Fico Score
Borrower Job Title
Borrower Birthday
Co-Borrower First Name
Co-Borrower Middle Name
Co-Borrower Last Name
Co-Borrower Salutation
Co-Borrower Nick Name
Co-Borrower Mobile Phone
Co-Borrower Home Phone
Co-Borrower Work Phone
Co-Borrower Email
Co-Borrower Best Way To Contact
Co-Borrower Fico Score
Co-Borrower Birth Day
Display Name
Group Name
Loan Notes
Language
Own Primary Residence
Referrer Name
Actual Close Date
Application Date
Appraisal Ordered Date
Appraisal Received Date
Approval Date
Cancellation Date
CD Sent Date
CD Receipt Date
Cleared to Close Date
Construction Close Date
Credit Pulled Date
Decision Date
Denied Date
Docs To Escrow Title Date
Estimated Close Date
First Payment Due Date
Lock Date
Lock Expiration Date
Loan In Process Date
Loan Modified Date
Servicing Next Payment Due Date
Signed Date
Sold Date
Submitted To Underwriting Date
Appraised Value
Association Dues
CLTV
Documentation Type
Hazard Insurance
Is In Flood Zone
Lien Position
Loan Status
Loan ARM Index
Loan ARM Margin
Loan Interest Rate
Loan Amount
Loan Number
Loan Product
Loan Type
Loan LTV
Loan Monthly Payment
Loan Purpose
Loan Term
Occupancy
PMI
Property Taxes
Purchase Price
Total Down Payment
Total Loan Amount
Total Monthly Payment
Secondary Loan ARM Margin
Secondary Loan ARM Index
Secondary Loan Interest Rate
Secondary Loan Amount
Secondary Loan Number
Secondary Loan Product
Secondary Loan Type
Secondary Loan LTV
Secondary Loan Monthly Payment
Property Street Address
Property City
Property County
Property State
Property Postal Code
Escrow Company Name
Escrow Street Address
Escrow City
Escrow State
Escrow Postal Code
Escrow Phone Number
Escrow Fax Number
Escrow No.
Title Attn
Buyer Agent Name
Buyer Agent Company
Buyer Agent Title
Buyer Agent License No.
Buyer Agent Email
Buyer Agent Mobile Phone Number
Buyer Agent Work Phone Number
Buyer Agent Fax Number
Buyer Agent Street Address
Buyer Agent City
Buyer Agent State
Buyer Agent Postal Code
Listing Agent Name
Listing Agent Company
Listing Agent Title
Listing Agent License No.
Listing Agent Email
Listing Agent Mobile Phone Number
Listing Agent Work Phone Number
Listing Agent Fax Number
Listing Agent Street Address
Listing Agent City
Listing Agent State
Listing Agent Postal Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNew Contact
Triggers when a new Contact is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planSalesforce ObjectRequired
Record (Optional)
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Outbound Message
Triggers when a new outbound message is received in Salesforce.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Disclaimer
Salesforce ObjectRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planCampaignRequired
ContactRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CampaignRequired
LeadRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Salesforce ObjectRequired
Description
Attachment visibility
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Contact
Creates a new contact.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Title
Description
Salesforce Object
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Note TitleRequired
Note
Salesforce ObjectRequired
Note Visibility
Use Assignment Rules
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Salesforce ObjectRequired
Use Assignment Rules
Allow Duplicates
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ToRequired
CC
BCC
SubjectRequired
Email FormatRequired
Sender TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Lead to UpdateRequired
Use Assignment Rules
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Salesforce ObjectRequired
Record to UpdateRequired
Use Assignment Rules
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Parent ObjectRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSalesforce ObjectRequired
SOQL WHERE clauseRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSalesforce ObjectRequired
SOQL WHERE ClauseRequired
Sort by
Sort Order
Maximum Number of Records
ActionThis is an event a Zap performs.SearchFind existing data in your appSalesforce ObjectRequired
Search ValueRequired
Second Field to Search By
Second Search Value
Search Operator
Use Assignment Rules
Allow Duplicates
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundExport Usherpa Contacts
Export new or updated loans from Usherpa
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planContact Type
Marketing Package
First NameRequired
Middle Name
Last NameRequired
Nick Name
Display Name
Salutation
Email
Address
City
State
Postal Code
Home Phone
Mobile Phone
Work Phone
Employer
Birthday
Title
Group Name
Referral Source
Website
Fico Score
Favorite Things
Own Current Residence
Contact Preference
Language
License Number
Additional Contact First Name
Additional Contact Middle Name
Additional Contact Last Name
Additional Contact Salutation
Additional Contact Nick Name
Additional Contact Email
Additional Contact Address
Additional Contact City
Additional Contact State
Additional Contact Postal Code
Additional Contact Home Phone
Additional Contact Work Phone
Additional Contact Mobile Phone
Additional Contact Employer
Additional Contact Title
Additional Contact Birthday
Additional Contact Website
Additional Contact Fico Score
Additional Contact Favorite Things
Additional Contact Own Current Residence
Additional Contact Contact Preference
Additional Contact Language
Additional Contact Licnese Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
Top companies trust Zapier to automate work and free up time
Join millions worldwide who automate their work using Zapier
How Google Sheets + Salesforce + Usherpa Integrations Work
- Step 1: Authenticate Google Sheets, Salesforce, and Usherpa.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.