AgencyZoom + Microsoft Excel

Add new AgencyZoom leads to Microsoft Excel rows

When a new lead enters the AgencyZoom system, this automation efficiently organizes and stores them for you in your Microsoft Excel. It ensures all your generated business leads are readily accessible and traceable in an Excel spreadsheet. This workflow not only helps streamline your data collection process but also aids in maintaining a clean and updated leads database for your business campaigns.

When this happens...
Lead Created
Triggers when a new Lead is added.
TriggerInstant
automatically do this!
Add Row
Adds a new row to the end of a worksheet.
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

Lead Created
Triggers when a new Lead is added.
Trigger
Instant
Try It
New Policy Sold
Triggers when a new policy is sold.
Trigger
Instant
Try It
Service Request Status Change
Triggers when the status of a Service Request changes.
Trigger
Instant
Try It
- Business NameRequired
- Contact Name
Action
Write
- LeadRequired
Action
Write

- Service RequestRequired
- SummaryRequired
- Description
- CategoryRequired
- PriorityRequired
- PipelineRequired
- StageRequired
- csrRequired
- Due Date
- Other Producers
- Tags
Action
Write
- Field to Search ByRequired
- Create Agencyzoom lead if it doesn't exist yet?Required
Action
Search

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- TableRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- Column IndexRequired
- Apply To
- Header Preservation
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- RowRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- RangeRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Search or write

Lead Status Change
Triggers when the status of a Lead changes.
Trigger
Instant
Try It
Service Request Created
Triggers when a new Service Request is created.
Trigger
Instant
Try It
- TitleRequired
- Lead contact emailRequired
- Activity noteRequired
Action
Write
- NameRequired
Action
Write
- Customer NameRequired
- Customer Email AddressRequired
- Policy Number
- SummeryRequired
- CategoryRequired
- PriorityRequired
- PipelineRequired
- StageRequired
- Customer Service Representative
- CSR Assignment Group
- Due after daysRequired
- Tag
- DescriptionRequired
Action
Write
- TitleRequired
- Assigned ToRequired
- Contact (lead or customer) emailRequired
- TypeRequired
- Comments
- Task Date (and time)Required
Action
Write
- Customer Name
- Pipeline
- Stage
- Created Date Start
- Created Date End
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- TableRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Trigger Column
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- RangeRequired
- Apply To
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- Row IDRequired
- Apply To
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- New NameRequired
Action
Write
- Api Docs Info
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- Row IDRequired
- No Match Copy
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or write

About AgencyZoom

AgencyZoom is a sales and automation software specifically made for P&C insurance agents.

Related categories

CRM (Customer Relationship Management)

Similar apps

Zapier Forms

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

About Microsoft Excel

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Learn more

AgencyZoom + Microsoft Excel

Add new AgencyZoom leads to Microsoft Excel rows

Lead Created

New Policy Sold

Service Request Status Change

Create Business Lead

Update Lead

Update Service Request

Find a Lead

New Row

New Worksheet

Add Row

Add Row to Table

Clear Column by Index

Create Workbook

Delete Worksheet

Update Row

Find Row

Get Cells in Range

Get Worksheet by ID

Find or Create Worksheet

Lead Status Change

Service Request Created

Create a Note

Create Personal Lead

Create Service Request

Create Task

Find Service Request

New Row in Table

Updated Row

Add Row(s)

Clear Cells by Range

Clear Row by ID

Create Worksheet

Rename Worksheet

API Request (Beta)

Find Worksheet(s)

Get Row by ID

Find or Create Row

About AgencyZoom

Related categories

Similar apps

Zapier Forms

About Microsoft Excel

Related categories

Similar apps

OneDrive

Smartsheet

Quip

Related Zap Templates

Related Zap Templates