Google Sheets + Usherpa

Create Usherpa contacts with new rows in Google Sheets

Automatically create a contact within Usherpa from leads you store in a new row in a specified Google Sheets spreadsheet. This integration allows you to push any leads directly into Usherpa right from your spreadsheet so you can begin marketing to them without manual data entry.

When this happens...
New Spreadsheet Row
Triggers when a new row is added to the bottom of a spreadsheet.
TriggerInstant
automatically do this!
Import Contact
Creates a new Contact
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

- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Polling
Try It
- Drive
Trigger
Polling
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

- Drive
- SpreadsheetRequired
- WorksheetRequired
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Source RangeRequired
- Destination RangeRequired
- Paste Type
Action
Write

- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Validation TypeRequired
- Input Message
- Strict Validation
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
Action
Search
- Spreadsheet IDRequired
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write
Export Usherpa Contacts
Export new or updated loans from Usherpa
Trigger
Polling
Try It
- Contact 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
Action
Write

- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Condition TypeRequired
- Background Color
- Text Color
- Bold Text
- Italic Text
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Confirm DeletionRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Format TypeRequired
Action
Write
- SpreadsheetRequired
- WorksheetRequired
- New Sheet NameRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Sort by ColumnRequired
- Sort OrderRequired
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
- A1 RangeRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row IDRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search or write
Export Usherpa Loans
Export new or updated loans from Usherpa.
Trigger
Polling
Try It
- Loan 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
Action
Write

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 Usherpa

Usherpa is the easiest-to-use marketing crm for sales professionals that saves time, maximizes referrals and automates marketing.

Related categories

Similar apps

Zapier Interfaces

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

Google Sheets + Usherpa

Create Usherpa contacts with new rows in Google Sheets

New Spreadsheet Row (Team Drive)

New Spreadsheet

New or Updated Spreadsheet Row

Create Spreadsheet Column

Create Multiple Spreadsheet Rows

Change Sheet Properties

Copy Range

Create Spreadsheet

Clear Spreadsheet Row(s)

Delete Spreadsheet Row(s)

Format Spreadsheet Row

Set Data Validation

Update Spreadsheet Row

API Request (Beta)

Find Worksheet

Get Many Spreadsheet Rows (Advanced)

Get Spreadsheet by ID

Find or Create Worksheet

Export Usherpa Contacts

Import Contact

New Spreadsheet Row

New or Updated Spreadsheet Row (Team Drive)

New Worksheet

Create Spreadsheet Row

Create Spreadsheet Row at Top

Create Conditional Formatting Rule

Copy Worksheet

Create Worksheet

Delete Sheet

Format Cell Range

Rename Sheet

Sort Range

Update Spreadsheet Row(s)

Lookup Spreadsheet Rows (Advanced)

Get Data Range

Get Row by ID

Lookup Spreadsheet Row

Find or Create Row

Export Usherpa Loans

Import Loan

About Google Sheets

Related categories

Similar apps

Zapier Tables

Zoho Creator

Smartsheet

About Usherpa

Related categories

Similar apps

Zapier Interfaces