Google Sheets + Maximizer CRM

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

Easily streamline your customer database management with this smart workflow. Whenever there's a new or updated row in your Google Sheets, a corresponding entry will be created in your Maximizer CRM address book. This saves you from manual data entry and ensures your contact list in Maximizer CRM is always up-to-date with the latest information from your Google Sheets. An efficient solution to maintain consistency and accuracy across your platforms.

When this happens...
New or Updated Spreadsheet Row
Triggered when a new row is added or modified in a spreadsheet.
TriggerInstant
automatically do this!
Create Address Book Entry
Creates new company, individual or contact in your Address Book
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?

- 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
- Bottom-Up
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
Action
Search or write
- Entry typeRequired
- CriteriaRequired
- Select User Defined Fields (UDFs) to include
Trigger
Scheduled
Try It
New or Updated Appointment Entry
Triggers when there is a new or updated Appointment entry
Trigger
Scheduled
Try It
- CriteriaRequired
- Select User Defined Fields (UDFs) to include
Trigger
Scheduled
Try It
New or Updated Interaction Entry
Triggers when there is a new or updated Interaction entry
Trigger
Scheduled
Try It
Date Notification for Lead
Triggers when lead entry reaches notification date
Trigger
Scheduled
Try It
- CriteriaRequired
- Select User Defined Fields (UDFs) to include
Trigger
Scheduled
Try It
New or Updated Task Entry
Triggers when there is a new or updated Task entry
Trigger
Scheduled
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 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

- 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 To
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite?
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
- Bottom-Up
- Row Count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row CountRequired
- First Row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite?
Action
Search or write
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
Scheduled
Try It
Date Notification for Appointment Entry
Triggers when Appointment entry reaches notification date
Trigger
Scheduled
Try It
Date Notification for Case
Triggers when Case entry reaches notification date
Trigger
Scheduled
Try It
New or Updated Lead Entry
Triggers when there is a new or updated Lead entry
Trigger
Scheduled
Try It
- Parent TypeRequired
- Category
- Type
Trigger
Scheduled
Try It
Date Notification for Opportunity
Triggers when Opportunity reaches notification date
Trigger
Scheduled
Try It
Date Notification for Task
Triggers when Task reaches notification date
Trigger
Scheduled
Try It
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
- 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 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 Help

Related categories

Similar apps

Zapier Tables

Databases, Spreadsheets, Zapier

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

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 Help

Related categories

CRM (Customer Relationship Management)

Similar apps

Zapier Interfaces

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

PRODUCTS

CAPABILITIES

By team

Google Sheets + Maximizer CRM

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

New Spreadsheet Row (Team Drive)

Drive

WorksheetRequired

New Spreadsheet

Drive

New or Updated Spreadsheet Row

No Team Drive

SpreadsheetRequired

WorksheetRequired

Trigger Column

Create Spreadsheet Column

Drive

SpreadsheetRequired

WorksheetRequired

Column NameRequired

Index

Create Multiple Spreadsheet Rows

Drive

SpreadsheetRequired

WorksheetRequired

Create Spreadsheet

TitleRequired

Spreadsheet to Copy

Headers

Delete Spreadsheet Row

Drive

SpreadsheetRequired

WorksheetRequired

RowRequired

Update Spreadsheet Row

Drive

SpreadsheetRequired

WorksheetRequired

RowRequired

API Request (Beta)

Api Docs Info

HTTP MethodRequired

URLRequired

Query String Parameters

Headers

Additional Request Headers

Body

Find Worksheet

Drive

SpreadsheetRequired

TitleRequired

Lookup Spreadsheet Row

Drive

SpreadsheetRequired

WorksheetRequired

Lookup ColumnRequired

Lookup ValueRequired

Supporting Lookup Column

Supporting Lookup Value

Bottom-Up

Find or Create Row

Drive

SpreadsheetRequired

WorksheetRequired

Lookup ColumnRequired

Lookup ValueRequired

Supporting Lookup Column

Supporting Lookup Value

Bottom-Up

New or Updated Address Book Entry

Entry typeRequired

CriteriaRequired

Select User Defined Fields (UDFs) to include

New or Updated Appointment Entry

New or Updated Case Entry

CriteriaRequired

Select User Defined Fields (UDFs) to include

New or Updated Interaction Entry

Date Notification for Lead

New or Updated Opportunity Entry