Microsoft Excel + Sage Intacct

Create new Sage Intacct contacts from new rows in Microsoft Excel

This workflow begins with the addition of a new row in your Microsoft Excel spreadsheet and results in the creation of a new contact in your Sage Intacct application. It saves you time on data entry and ensures that all new Excel information is swiftly and accurately reflected in your Sage Intacct database. Enhance efficiency, eliminate the risk of manual errors, and keep your contact list updated with this seamless process.

When this happens...
New Row
Triggers when a new row is added to a worksheet in a spreadsheet.
TriggerPolling
automatically do this!
Create Contact
Triggers when a new contact is created.
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
- Worksheet IDRequired
- Row IDRequired
- No Match Copy
Action
Search

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or write
- Status
Trigger
Polling
Try It
New Payment Received (Accounts Receivable)
Triggers when a new AR payment is added.
Trigger
Polling
Try It
- Vendor IDRequired
- Bill Number
- Transaction DateRequired
- Due DateRequired
- Payment Term
- Reference Number
- GL Posting Date
- Transaction Currency
- Base Currency
- Exchange Rate Type
- Exchange Rate Date
- Exchange Rate Value
- Attachments ID
- GL Account NumberRequired
- Transaction AmountRequired
- Description
- Department ID
- Location ID
- Project ID
- Customer ID
- Item ID
- Contract ID
Action
Write
- Customer NameRequired
- Active
- One Time Use
- First Name
- Middle Name
- Last Name
- Primary Contact Name
- Primary Phone Number
- Mobile Phone Number
- Pager
- Fax
- Primary Email Address
- Secondary Email Address
- URL
- Currency
- Address Line 1
- Address Line 2
- City
- State/Province
- ZIP/Postal Code
- Country
- Print As
- Exclude from the company contact list
Action
Write
Find Bill
Finds a bill based on a search criteria.
Action
Search
Find Invoice
Finds a invoice based on a search criteria.
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 IDRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Search or write
- State
Trigger
Polling
Try It
- Status
Trigger
Polling
Try It
- Contact NameRequired
- Print AsRequired
- Last Name
- First Name
- Middle Name
- Prefix
- Company Name
- Taxable
- Tax ID
- Contact Tax Group Name
- Active
- Primary Phone Number
- Secondary Phone Number
- Cellular Phone Number
- Pager Number
- Fax Number
- Primary Email Address
- Secondary Email Address
- Primary URL
- Secondary URL
- Address Line 1
- Address Line 2
- City
- State/Province
- ZIP/Postal Code
- Country
Action
Write
- Invoice Number
- Reference Number
- Customer IDRequired
- Due Date
- Payment Term
- Create Draft
- GL Account Number
- AR Account Label
- Offset GL Account Number
- Transaction AmountRequired
- Location ID
- Allocation ID
- Customer ID
- Class ID
- Contract ID
- Department ID
- Employee ID
- Vendor ID
- Warehouse ID
- Project ID
- Item ID
- Memo
- Rev Rec Template ID
- Deferred Revenue GL Account Number
- Rev Rec End Date
- Rev Rec Start Date
- Total Due
- Total Paid
- External ID
- Description
- Bill To Contact
- Ship To Contact
- Summary Record No
- Attachments ID
- Base Currency Code
- Transaction Currency Code
- Exchange Rate Date
- Exchange Rate Type
- Exchange Rate Value
- Transaction Date
- GL Posting Date
- Post to GL?
Action
Write
Find Customer
Finds a customer based on search criteria.
Action
Search
Find Vendor
Finds a vendor based on a search criteria.
Action
Search

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

About Sage Intacct

Sage Intacct is a cloud-based financial management software that streamlines & automates accounting business processes, providing real-time financial insights.

Related categories

Accounting

Microsoft Excel + Sage Intacct

Create new Sage Intacct contacts from new rows in Microsoft Excel

New Row

New Worksheet

Add Row

Add Row to Table

Create Worksheet

Find Row

Get Row by ID

Find or Create Row

New Contact

New Payment Received (Accounts Receivable)

Create Bill

Create Customer

Find Bill

Find Invoice

New Row in Table

Updated Row

Add Row(s)

Create Workbook

Update Row

Find Worksheet(s)

Get Worksheet by ID

Find or Create Worksheet

New Invoice

New Vendor

Create Contact

Create Invoice

Find Customer

Find Vendor

About Microsoft Excel

Related categories

Similar apps

OneDrive

Smartsheet

Quip

About Sage Intacct

Related categories

Related Zap Templates

Related Zap Templates