Autotask + Microsoft Excel

Add new Autotask accounts as rows in Excel

Manually logging account data into Excel can be a slog. You might even be thinking about hiring an intern, but don't! Let Zapier do the work for you. With this Zap, every time a new account appears in Autotask we'll shoot this information over to your Excel sheet. Now you can keep all your information in one place without doing any mind-numbing data entry.

When this happens...
Finds an account.
TriggerScheduled
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

What does this mean?

- Help Text
Trigger
Instant
Try It
- Help Text
Trigger
Instant
Try It
New Invoice
Triggers when a new invoice is found.
Trigger
Scheduled
Try It
- Company
Trigger
Scheduled
Try It
- Opportunity
Trigger
Scheduled
Try It

New Task
Triggers when a new Task is found.
Trigger
Scheduled
Try It
New Time Entry
Triggers when a new time entry is found.
Trigger
Scheduled
Try It

- Help Text
Trigger
Instant
Try It
- Company
Trigger
Scheduled
Try It
Updated Quote
Triggers when a quote is updated.
Trigger
Scheduled
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
- CompanyRequired
Action
Write
- OpportunityRequired
Action
Write
- TaskRequired
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- 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
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Storage Source
- Folder
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search

- Company
- Assigned To Resource ID
Trigger
Scheduled
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
Scheduled
Try It
New Service Call
Triggers when a new service call is created.
Trigger
Scheduled
Try It
- Help Text
Trigger
Instant
Try It
- Help Text
Trigger
Instant
Try It
Updated Contact
Triggers when a contact is updated.
Trigger
Instant
Try It
- Company
Trigger
Scheduled
Try It
- Project
Trigger
Scheduled
Try It
- Company
Trigger
Scheduled
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
- ProjectRequired
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
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Trigger
Scheduled
Try It
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Action
Write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
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.

Learn more Help

Related categories

CRM (Customer Relationship Management)

Similar apps

Jira Software Server

Project Management

NetSuite

CRM (Customer Relationship Management)

Odoo ERP Self Hosted

CRM (Customer Relationship Management)

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.

Help

Related categories

Similar apps

OneDrive

File Management & Storage, Microsoft

Smartsheet

Spreadsheets

Quip

Documents

PRODUCTS

CAPABILITIES

By team

Autotask + Microsoft Excel

Add new Autotask accounts as rows in Excel

New Company

Help Text

New Configuration Item

Help Text

New Invoice

New Opportunity

Company

New Quote

Opportunity

New Task

New Time Entry

Updated Configuration Item

Help Text

Updated Opportunity

Company

Updated Quote

Updated Ticket

Help Text

Field

Create Company

Create Contact

Create Ticket Note

Create Knowledge Base Article

Article CategoryRequired

Create Quote

OpportunityRequired

Update Company

CompanyRequired

Update Opportunity

OpportunityRequired

Update Task

TaskRequired

API Request (Beta)

Api Docs Info

HTTP MethodRequired

URLRequired

Query String Parameters

Headers

Additional Request Headers

Body

Find Contract

Contract ID

Company Name

Find Contact

ID

First Name

Last Name

Email Address

Company

Country

Fax Number

Phone Number

Find Quote

Quote Name

Quote ID

Find Country

Country IDRequired

Find Resource

Resource IDRequired

New Row

Storage Source

FolderRequired

SpreadsheetRequired

WorksheetRequired

New Worksheet

Storage Source

Folder

SpreadsheetRequired

Add Row

Storage Source

FolderRequired

SpreadsheetRequired

WorksheetRequired

Create Spreadsheet

Storage Source