Autotask + Microsoft Excel

Update Autotask contacts when new rows are updated in Microsoft Excel

This workflow immediately updates your Autotask contacts when any changes occur in your Microsoft Excel rows. Stay organized and efficient, as this workflow saves you the time and effort of manual data entry by seamlessly transferring your updated Excel information to Autotask. It simplifies contact management by ensuring your Autotask app is always up-to-date with the latest details from your Excel sheets.

When this happens...
Updated Row
Triggers when a row is added or updated in a worksheet.
TriggerPolling
automatically do this!
Update Contact
Update a 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

- 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 NameRequired
- Column Headers
Action
Write

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or write

- Help Text
Trigger
Instant
Try It
- Help Text
Trigger
Instant
Try It
New Invoice
Triggers when a new invoice is found.
Trigger
Polling
Try It
- Company
Trigger
Polling
Try It
- Opportunity
Trigger
Polling
Try It
New Task
Triggers when a new Task is found.
Trigger
Polling
Try It
New Time Entry
Triggers when a new time entry is found.
Trigger
Polling
Try It
- Company
- Assigned To Resource
Trigger
Polling
Try It
Updated Contact
Triggers when a contact is updated.
Trigger
Instant
Try It
- Company
Trigger
Polling
Try It
Updated Service Call
Triggers when an existing service call is updated (not when created).
Trigger
Polling
Try It
- Help Text
- Field
Trigger
Instant
Try It
Create Company
Creates a company.
Action
Write
- CompanyRequired
Action
Write
Create Ticket Note
Creates a ticket note.
Action
Write
- Article CategoryRequired
Action
Write
- OpportunityRequired
Action
Write
- ProjectRequired
Action
Write
- CompanyRequired
Action
Write
- OpportunityRequired
Action
Write
- TaskRequired
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Contract ID
- Company Name
Action
Search
- ID
- First Name
- Last Name
- Email Address
- Company
- Country
- Fax Number
- Phone Number
Action
Search
- Quote Name
- Quote ID
Action
Search
- Country IDRequired
Action
Search
- Resource IDRequired
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
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- RowRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Search or write
- Company
- Assigned To Resource ID
Trigger
Polling
Try It
New Contact
Triggers when a new contact is found.
Trigger
Instant
Try It
- Help Text
Trigger
Instant
Try It
New Project
Triggers when a new Project is found.
Trigger
Polling
Try It
New Service Call
Triggers when a new service call is created.
Trigger
Polling
Try It
- Help Text
Trigger
Instant
Try It
- Help Text
Trigger
Instant
Try It
- Help Text
Trigger
Instant
Try It
- Company
Trigger
Polling
Try It
Updated Quote
Triggers when a quote is updated.
Trigger
Polling
Try It
- Project
Trigger
Polling
Try It
- Company
Trigger
Polling
Try It
Create Company To-Do
Creates a new Company To-Do.
Action
Write
- CompanyRequired
Action
Write
- NameRequired
- Submitter IDRequired
- Organizational Level Association ID
- reimbursement Currency Cash Advance Amount
- Reimbursement Currency ID
- The week ending date (YYYY-MM-DD)Required
- Status
- Submit
Action
Write
- CompanyRequired
Action
Write
- QuoteRequired
Action
Write
Create Time Entry
Creates a Time Entry.
Action
Write
- ContactRequired
Action
Write
- QuoteRequired
Action
Write
- TicketRequired
Action
Write
- Account ID
- Account Name
Action
Search
- Company Name
- Company ID
Action
Search
- Opportunity Title
- Opportunity ID
Action
Search
- Ticket ID
- Ticket Number
- Title
- Ticket Type
- Created By
- Assigned To
- Completed By
- Company
Action
Search
- Currency IDRequired
Action
Search
- Company Name
- Company ID
Action
Search or write

About Autotask

Autotask provides an IT business management solution that combines service desk, CRM, projects, time and expense, billing and more.

Related categories

CRM (Customer Relationship Management)

Similar apps

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

Related categories

Similar apps

Related Zap Templates

Add new Autotask contacts as new rows in Excel

Add new Autotask invoices as rows in Microsoft Excel for streamlined data management

Autotask + Microsoft Excel

Update Autotask contacts when new rows are updated in Microsoft Excel

New Row

New Worksheet

Add Row

Add Row to Table

Create Worksheet

Find Row

Find or Create Row

New Company

New Configuration Item

New Invoice

New Opportunity

New Quote

New Task

New Time Entry

Updated Company "To Do" Event

Updated Contact

Updated Project

Updated Service Call

Updated Ticket

Create Company

Create Contact

Create Ticket Note

Create Knowledge Base Article

Create Quote

Create Task

Update Company

Update Opportunity

Update Task

API Request (Beta)

Find Contract

Find Contact

Find Quote

Find Country

Find Resource

New Row in Table

Updated Row

Add Row(s)

Create Workbook

Update Row

Find Worksheet

Find or Create Worksheet

New Company "To Do" Event

New Contact

New Ticket

New Project

New Service Call

New or Updated Ticket Note

Updated Company

Updated Configuration Item

Updated Opportunity

Updated Quote

Updated Task

Updated Time Entry

Create Company To-Do

Create Ticket

Create Expense Report

Create Opportunity

Add Quote Items

Create Time Entry

Update Contact

Update Quote

Update Ticket

Find Account

Find Company

Find Opportunity

Find Ticket

Find Currency

Find Company

About Autotask

Related categories

Similar apps

Jira Software Server

Odoo ERP Self Hosted

ConnectWise Manage

About Microsoft Excel

Related categories

Similar apps

OneDrive