Add new accounts in Autotask to a Google Sheets spreadsheet
Logging account data can be a rough job. Thankfully you have Zapier to help keep you on track! With this Zap, every time a new account appears in Autotask we'll shoot this information over to a Google Sheet. Now you can access your Accounts in Sheets, make a custom chart with your data, and then share it with your team!
- When this happens...

New CompanyTriggers when a new company is found.TriggerInstant - automatically do this!

Create Spreadsheet RowCreate a new row in a specific spreadsheet.ActionWrite
- Free forever for core features
- 14 day trial for premium features & apps
More things you can do with Autotask and Google Sheets
Discover other triggers and actions you can use with Autotask and Google Sheets
New InvoiceTriggers when a new invoice is found.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
New TaskTriggers when a new Task is found.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
New Time EntryTriggers when a new time entry is found.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Company
- Assigned To Resource
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Updated ContactTriggers when a contact is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated Service CallTriggers when an existing service call is updated (not when created).
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Create CompanyCreates a company.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- CompanyRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
Create Ticket NoteCreates a ticket note.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Article CategoryRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- OpportunityRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- ProjectRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- CompanyRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- OpportunityRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- TaskRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Contract ID
- Company Name
ActionThis is an event a Zap performs.SearchFind existing data in your app- ID
- First Name
- Last Name
- Email Address
- Company
- Country
- Fax Number
- Phone Number
ActionThis is an event a Zap performs.SearchFind existing data in your app- QuoteName
- QuoteID
ActionThis is an event a Zap performs.SearchFind existing data in your app- Country IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Resource IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Dont_change_sheet_structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Dont_change_sheet_structure
- No_team_drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Condition TypeRequired
- Background Color
- Text Color
- Bold Text
- Italic Text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- SpreadsheetRequired
- WorksheetRequired
- New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Sort by ColumnRequired
- Sort OrderRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- First row
- Row count
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
ActionThis is an event a Zap performs.SearchFind existing data in your app- Spreadsheet IDRequired
- Include Grid Data
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- Spreadsheet NameRequired
- Search Type
- Spreadsheet to Copy
- Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
- Company
- Assigned To Resource ID
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
New ContactTriggers when a new contact is found.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New ProjectTriggers when a new Project is found.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
New Service CallTriggers when a new service call is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Updated QuoteTriggers when a quote is updated.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Create Company To-DoCreates a new Company To-Do.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- CompanyRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- 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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- CompanyRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- QuoteRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
Create Time EntryCreates a Time Entry.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- ContactRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- QuoteRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- TicketRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Account ID
- Account Name
ActionThis is an event a Zap performs.SearchFind existing data in your app- Company Name
- Company ID
ActionThis is an event a Zap performs.SearchFind existing data in your app- Opportunity Title
- Opportunity ID
ActionThis is an event a Zap performs.SearchFind existing data in your app- Ticket ID
- Ticket Number
- Title
- Ticket Type
- Created By
- Assigned To
- Completed By
- Company
ActionThis is an event a Zap performs.SearchFind existing data in your app- Currency IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Company Name
- Company ID
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found- Dont_change_sheet_structure
- No_team_drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Dont_change_sheet_structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Dont_change_sheet_structure
- No_team_drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column_nameRequired
- Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Source RangeRequired
- Destination RangeRequired
- Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- TitleRequired
- Spreadsheet to Copy
- Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Validation TypeRequired
- Input Message
- Strict Validation
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Overwrite All Columns
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Api_docs_info
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- Spreadsheet NameRequired
- Search Type
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found







