BaseLinker + Microsoft Excel

BaseLinker + Microsoft Excel integrations

Create spreadsheets in Microsoft Excel for new invoices in BaseLinker

Manage your financial documents easily and efficiently with this workflow. When a new invoice is generated in BaseLinker, it instantly creates a spreadsheet in Microsoft Excel. This seamless process ensures no invoice goes unrecorded, keeping your records accurate and up-to-date with minimal effort. You can streamline your accounting tasks and focus more on other important aspects of your business.

When this happens...
New InvoiceTriggers when a new invoice is created.
TriggerInstant
automatically do this!
Create WorkbookCreates a new workbook
ActionWrite

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with BaseLinker and Microsoft Excel

Discover other triggers and actions you can use with BaseLinker and Microsoft Excel

New Invoice
Triggers when a new invoice is created.
Trigger
Instant
Try It
- Order status
  Required
Trigger
Instant
Try It
- Order status
  Required
- Creation date (in unix time format)
- Currency symbol
- Payment method
- Cash on delivery
- Order is already paid?
- Buyer comments
- Seller comments
- Buyer e-mail address
- Buyer phone number
- Delivery method name
- Gross delivery price
- Delivery address - name and surname
- Delivery address - company
- Delivery address - street and number
- Delivery address - postcode
- Delivery address - city
- Delivery address - state
- Delivery address - country code (two-letter, e.g. EN)
- Pick-up point delivery - pick-up point identifier
- Pick-up point delivery - pick-up point name
- Pick-up point delivery - pick-up point address
- Pick-up point delivery - pick-up point postcode
- Pick-up point delivery - pick-up point city
- Billing details - name and surname
- Billing details - company
- Billing details - Vat Reg. no./tax number
- Billing details - street and house number
- Billing details - postcode
- Billing details - city
- Billing details - state
- Billing details - country code (two-letter, e.g. EN)
- Wants an invoice
- additional field 1
- additional field 2
- storage
- storage id
- product id
- variant id
- product name
  Required
- product sku
- product ean
- product attributes
- single item gross price
  Required
- VAT rate
- Quantity of pieces
  Required
- single item weight
Action
Write
- order id
  Required
- courier code
  Required
- package number
  Required
- pickup date
  Required
Action
Write
- order ID
  Required
Action
Write

- Order ID
  Required
- Status ID
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Table
  Required
Trigger
Polling
Try It

- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Trigger Column
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Range
  Required
- Apply To
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Row ID
  Required
- Apply To
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
- Column Headers
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- New Name
  Required
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Row ID
  Required
- No_match_copy
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Value
  Required
Action
Search or write

New Order
Triggers when a new order is confirmed.
Trigger
Instant
Try It
- order id
  Required
- series id
Action
Write
- order id
  Required
- payment done
  Required
- payment date
- payment comment
Action
Write
- Order ID
  Required
Action
Write
- Order ID
  Required
- admin comments
- user comments
- payment method
- payment method COD
- email
- phone
- user login
- delivery method
- delivery price
- delivery fullname
- delivery company
- delivery address
- delivery postcode
- delivery city
- delivery state
- delivery country code
- delivery point id
- delivery point name
- delivery point address
- delivery point postcode
- delivery point city
- invoice fullname
- invoice company
- invoice nip
- invoice address
- invoice postcode
- invoice city
- invoice state
- invoice country code
- want invoice
- extra field 1
- extra field 2
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Table
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Column Index
  Required
- Apply To
- Header Preservation
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Title
  Required
- Column Headers
- Zap_step_id
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Row
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Value
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Range
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
- Column Headers
Action
Search or write

About BaseLinker

BaseLinker is a cloud-based system integrating 1000+ marketplaces, stores, carriers, accounting and many more. Handle orders 10x faster!

Learn moreLearn moreHelpHelp

Related categories

eCommerce

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 moreLearn moreHelpHelp

Related categories

Microsoft

Spreadsheets

Similar apps

OneDrive

File Management & Storage, Microsoft

Smartsheet

Spreadsheets

Quip

Documents

Related Zap Templates

Update Microsoft Excel rows when BaseLinker order statuses change