Google Sheets + Maximizer CRM

Create new Maximizer CRM leads when new rows are added to Google Sheets

This workflow initiates when a new row is added to a Google Sheets spreadsheet, prompting the creation of a fresh lead in Maximizer CRM. This automated process ensures all data from your Google Sheets will directly populate into your sales pipeline, relieving you of manual data entry and keeping your customer database up-to-date with real-time information. With this workflow, save time and maintain accuracy by seamlessly integrating your spreadsheet updates into Maximizer CRM.

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

- Dont Change Sheet Structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- Dont Change Sheet Structure
- 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
New or Updated Address Book Entry (Via Webhook)
Triggers when an Address Book entry is created, updated, or deleted through the Octopus API. Supported only for Maximizer Cloud.
Trigger
Instant
Try It
New or Updated Lead Entry (Via Webhook)
Triggers when a new Lead entry is created, updated, or deleted. Supported only for Maximizer Cloud.
Trigger
Instant
Try It
- Entry typeRequired
- CriteriaRequired
- Select User Defined Fields (UDFs) to include
Trigger
Polling
Try It
New or Updated Appointment Entry
Triggers when there is a new or updated Appointment entry
Trigger
Polling
Try It
- CriteriaRequired
- Select User Defined Fields (UDFs) to include
Trigger
Polling
Try It
New or Updated Interaction Entry
Triggers when there is a new or updated Interaction entry
Trigger
Polling
Try It
Date Notification for Lead
Triggers when lead entry reaches notification date
Trigger
Polling
Try It
- CriteriaRequired
- Select User Defined Fields (UDFs) to include
Trigger
Polling
Try It
New or Updated Task Entry
Triggers when there is a new or updated Task entry
Trigger
Polling
Try It
Add Subscriber to Campaign
Add Subscriber to Campaign
Action
Write
Create Address Book Entry
Creates new company, individual or contact in your Address Book
Action
Write
Create Case
Creates new Customer Service Case
Action
Write
Create Favourite List
Creates new Favourite list
Action
Write
Create Lead Entry
Creates new Lead Entry
Action
Write
Create Opportunity Entry
Creates new Opportunity entry
Action
Write
- Remove existing value for selected fields
- Add User Defined Fields (UDFs) to search criteria
Action
Write
Update Case
Updates existing Customer Service Case
Action
Write
Update Lead Entry
Updates existing Lead Entry
Action
Write
Update Opportunity
Updates existing Opportunity
Action
Write
Find Appointment
Searches for existing Appointment entry
Action
Search
Find Case
Searches for existing Case entry
Action
Search
Find Note
Searches for existing Note entry
Action
Search
Find Task
Searches for existing Task entry
Action
Search
- User Key
- First Name
- Last Name
- Email Address
- Restrict single record
- Select User Defined Fields (UDFs) to include
Action
Search
- Add User Defined Fields (UDFs) to search criteria
- Sort by
- Sort Order
- Search Limit
- Restrict single record
- Select User Defined Fields (UDFs) to include
Action
Search or write

- Dont Change Sheet Structure
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Dont Change Sheet Structure
- 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
New or Updated Appointment (Via Webhook)
Triggers when an appointment is created, updated, or deleted through the Octopus API. Supported only for Maximizer Cloud.
Trigger
Instant
Try It
Opportunity Stage Changed
Triggers when an opportunity stage is changed. Supported only for Maximizer Cloud.
Trigger
Instant
Try It
Date Notification for Address Book Entry
Triggers when Address Book entry reaches notification date
Trigger
Polling
Try It
Date Notification for Appointment Entry
Triggers when Appointment entry reaches notification date
Trigger
Polling
Try It
Date Notification for Case
Triggers when Case entry reaches notification date
Trigger
Polling
Try It
New or Updated Lead Entry
Triggers when there is a new or updated Lead entry
Trigger
Polling
Try It
- Parent TypeRequired
- Category
- Type
Trigger
Polling
Try It
Date Notification for Opportunity
Triggers when Opportunity reaches notification date
Trigger
Polling
Try It
Date Notification for Task
Triggers when Task reaches notification date
Trigger
Polling
Try It
Convert Lead Entry
Converts Lead to new company or individual entry or to existing Address Book entry, and optionally creates opportunity
Action
Write
Create Appointment
Creates new Appointment entry
Action
Write
Create Document
Creates new Document tiered to existing contact. NOTE: Create Document action only supports Maximizer CRM Version 2020R2 or later.
Action
Write
Create Hotlist Task
Creates new Hotlist Task for Address Book/Opportunity/Lead/Case entry
Action
Write
Create Note
Creates new Note for Address Book/Opportunity/Lead/Case entry
Action
Write
Create Personal Task
Creates new Personal Task
Action
Write
Update Appointment
Updates existing Appointment
Action
Write
Update Favourite List
Updates existing Favourite List
Action
Write
Update Note
Updates existing Note
Action
Write
Update Task
Updates existing Task
Action
Write
Find Campaign
Searches for existing Campaign
Action
Search
Find Lead
Searches for existing Lead entry
Action
Search
Find Opportunity
Searches for existing Opportunity entry
Action
Search
- Add User Defined Fields (UDFs) to search criteria
- Sort by
- Sort Order
- Search Limit
- Restrict single record
- Select User Defined Fields (UDFs) to include
Action
Search
Find or Create Lead entry
Find or Create Lead entry
Action
Search or 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 Maximizer CRM

Maximizer has fully integrated sales, marketing and customer service modules making it easy to gain deep customer insight and drive retention and loyalty within a single, affordable CRM solution.

Learn more

Related categories

CRM (Customer Relationship Management)

Similar apps

Zapier Interfaces

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

Related Zap Templates

Create new Maximizer CRM appointments from new rows in Google Sheets

Create Maximizer CRM address book entries from new Google Sheets rows

Create address book entries in Maximizer CRM for new or updated rows in Google Sheets

Google Sheets + Maximizer CRM

Create new Maximizer CRM leads when new rows are added to 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

New or Updated Address Book Entry (Via Webhook)

New or Updated Lead Entry (Via Webhook)

New or Updated Address Book Entry

New or Updated Appointment Entry

New or Updated Case Entry

New or Updated Interaction Entry

Date Notification for Lead

New or Updated Opportunity Entry

New or Updated Task Entry

Add Subscriber to Campaign

Create Address Book Entry

Create Case

Create Favourite List

Create Lead Entry

Create Opportunity Entry

Update Address Book Entry

Update Case

Update Lead Entry

Update Opportunity

Find Appointment

Find Case

Find Note

Find Task

Find Maximizer User

Find or Create Address Book entry

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

New or Updated Appointment (Via Webhook)

Opportunity Stage Changed

Date Notification for Address Book Entry

Date Notification for Appointment Entry

Date Notification for Case

New or Updated Lead Entry

New or Updated Note Entry

Date Notification for Opportunity

Date Notification for Task

Convert Lead Entry

Create Appointment

Create Document

Create Hotlist Task

Create Note

Create Personal Task

Update Appointment

Update Favourite List