Exact Online + Google Sheets

Exact Online + Google Sheets integrations

Create spreadsheet rows in Google Sheets for new or updated sales orders in Exact Online

Keep your sales data organized by setting up this workflow. Any time there's a new or updated sales order in Exact Online, a corresponding row will be created in your Google Sheets spreadsheet. This helps you have a real-time and searchable record of your sales transactions, alleviating the hassle of manually updating your sheets. Streamline your sales management with this efficient automated process.

When this happens...
New or Updated Sales OrderTriggers when a new sales order is created or updated.
TriggerInstant
automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
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 Exact Online and Google Sheets

Discover other triggers and actions you can use with Exact Online and Google Sheets

- Division
  Required
- Receive Updates on Deleted Accounts
- Event Type Copy
Trigger
Instant
Try It
- Division
  Required
- Receive Updates on Deleted Bank Entries
- Event Type Copy
Trigger
Instant
Try It
- Division
  Required
- Expand Batch Numbers
- Expand Serial Numbers
- Receive Updates on Deleted Goods Deliveries
- Event Type Copy
Trigger
Instant
Try It
- Division
  Required
- Output ID only
Trigger
Instant
Try It
- Division
  Required
- Receive Updates on Deleted Opportunities
- Event Type Copy
Trigger
Instant
Try It

- Division
  Required
- Receive Updates on Deleted Purchase Entries
- Include Purchase Order Credit Lines
- Info on Event Type
Trigger
Instant
Try It
- Division
  Required
- Expand Account Details
- Receive Updates on Deleted Quotations
- Event Type Copy
Trigger
Instant
Try It

- Division
  Required
- Expand Account Details
- Expand Contact Details
- Receive Updates on Deleted Sales Invoices
- Event Type Note
Trigger
Instant
Try It
- Division
  Required
- Receive Updates on Deleted Subscriptions
- Event Type Copy
Trigger
Instant
Try It
- Division
  Required
Trigger
Instant
Try It
- Division
  Required
- Journal (Code)
  Required
- Supplier (ID)
  Required
- Description
- Document (ID)
- Currency (Code)
- Entry Number
- Due Date
- Entry Date
- Invoice Number
- Payment Reference
- Payment Condition (Code)
- Order Number
- Reversal
- Your Ref
- Reporting Period
- Reporting Year
- General Ledger Account (ID)
  Required
- Amount FC
  Required
- VAT (Code)
- Quantity
- From
- To
- Cost Center (Code)
- Cost Unit (Code)
- Description
- Project (ID)
- Serial Number
- Asset (ID)
- Notes
- VAT Amount FC
Action
Write
- Division
  Required
- Status
- Name
  Required
- Code
- Email address
- Phone
- Address Line 1
- Address Line 2
- Address Line 3
- Postcode
- City
- State/Province/County (Code)
- Country (Code)
- Language (Code)
- Chamber Of Commerce
- VAT-Number
- Sales VAT Code
- Invoice Account (ID)
- Shipping Method (ID)
- Price List (ID)
- Is Supplier
- Lead Source (ID)
- Payment Condition Sales (Code)
- General Ledger Account Sales (ID)
- Discount Sales
- Search Code
- Account Manager (ID)
- Blocked
- Remarks
- Extra Fields
- Show Address ID in Output
- Info on Contact
- Contact First Name
- Contact Middle Name
- Contact Last Name
- Contact Email address
- Contact Phone
- Contact Mobile
- Contact Notes
Action
Write
- Division
  Required
- Account (ID)
  Required
- Bank Account Holder Name
- Description
- Main
- Blocked
- Extra Fields
Action
Write
- Division
  Required
- Bank Journal (Code)
  Required
- Bank General Ledger Account (Code)
  Required
- Description
  Required
- Currency (Code)
- Entry Number
- Opening Balance FC
- Closing Balance FC
- Date
  Required
- Counterparty General Ledger Account (Code)
  Required
- Account (Code)
  Required
- Description
- Amount FC
  Required
- VAT (Code)
- Cost Center (Code)
- Cost Unit (Code)
Action
Write
- Division
  Required
- Opening Balance FC
- Closing Balance FC
- Currency (Code)
- Financial Period
- Financial Year
- Journal (Code)
  Required
- Account (ID)
- Amount FC
  Required
- Amount VAT FC
- Asset (ID)
- Cost Center
- Cost Unit
- Date
- Description
- General Ledger Account (ID)
  Required
- Document (ID)
- Exchange Rate
- Our Ref
- Project (ID)
- Quantity
- VAT (Code)
- Extra remarks
Action
Write
- Division
  Required
- Account (ID)
  Required
- First Name
- Middle Name
- Last Name
- Email address
- Phone
- Mobile
- Is Mailing Excluded
- Notes
- Extra Fields
Action
Write
- Division
  Required
- Code
  Required
- Description
  Required
- End Date
Action
Write
- Division
  Required
- Account (ID)
  Required
- Bank Account (ID)
  Required
- Type
- Payment Type
- Description
- Reference
- Signature Date
- Cancellation Date
- Attachment
- Attachment File Name
- First Send
- Extra Fields
Action
Write
- Division
  Required
- Document (ID)
  Required
- File Name
  Required
- Attachment
  Required
Action
Write
- Division
  Required
- Journal (Code)
  Required
- Currency (Code)
- Entry Number
- Exchange Rate
- Financial Period
- Financial Year
- General Ledger Account (ID)
  Required
- Account (ID)
- Amount FC
- Amount VAT FC
- Asset (ID)
- Cost Center (Code)
- Cost Unit (Code)
- Entry Date
- Description
- Document (ID)
- Our Ref
- Quantity
- VAT (Code)
- Project (ID)
- Notes
Action
Write
- Division
  Required
- Delivery Date
  Required
- Description
- Tracking Number
- Shipping Method (ID)
- Remarks
- Sales Order Line (ID)
  Required
- Description
- Quantity Delivered
  Required
- Tracking Number
- Batch Number (ID)
- Notes
Action
Write
- Division
  Required
- Name
- Account (ID)
- Contact (ID)
- Owner (ID)
- Reason (ID)
- Lead Source (ID)
- Project (ID)
- Opportunity Stage (ID)
- Campaign (ID)
- Sales Type (ID)
- Action Date
- Next Action
- Currency (Code)
- Amount DC
- Amount FC
- Rate FC
- Close Date
- Probability
- Notes
Action
Write
- Division
  Required
- Description
  Required
- Code
  Required
- Use Employee Cost Center and Cost Unit
- Cost Center (Code)
- Cost Unit (Code)
Action
Write
- Division
  Required
- Type
  Required
- Supplier (ID)
  Required
- Contact Person (ID)
- Currency (Code)
- Description
- Document (ID)
- Due Date
- Exchange Rate
- Financial Period
- Financial Year
- Invoice Date
- Journal (Code)
  Required
- Payment Condition (Code)
- Payment Reference
- Warehouse (ID)
- Your Ref
- Remarks
- Extra Fields
- Amount
- Cost Center (Code)
- Cost Unit (Code)
- Description
- Discount
- Expense
- Item (ID)
- Purchase Order Line (ID)
- Net Price
- Unit Price
- Quantity
- VAT (Code)
- VAT Amount
- Rebill
- Project (ID)
- Extra notes
Action
Write
Create Purchase Order
Creates a purchase order in the system.
Action
Write
- Division
  Required
- Type
- Description
- Order Number
- Order Date
- Payment Reference
- Your Ref
- Currency (Code)
- Journal
  Required
- Ordered By
  Required
- Ordered By Contact Person
- Invoice To
- Invoice To Contact Person
- Deliver To
- Deliver To Contact Person
- Deliver To Address
- Warehouse
- Payment Condition
- Document (ID)
- Remarks
- Extra Fields
- Item
  Required
- Description
- Quantity
- Unit Price
- Net Price
- Cost Center
- Cost Unit
- General Ledger Account
- Unit (Code)
- VAT (Code)
- Delivery Date
- Start Time
- End Time
- Extra notes
- Project
- VAT Amount FC
- Print Sales Invoice
- Document Layout
- Email Layout
- Send Email To Customer
- Sender Email Address
- Invoice Date
- Reporting Period
- Reporting Year
- Send Invoice Via Peppol
Action
Write
- Division
  Required
- Journal (Code)
  Required
- Customer (ID)
  Required
- Description
- Batch Number
- Currency (Code)
- Document (ID)
- Due Date
- Entry Date
- Entry Number
- External Link Reference
- G Account Amount FC
- Invoice Number
- Is Extra Duty
- Order Number
- Payment Condition (Code)
- Payment Reference
- Process Number
- Rate
- Reporting Period
- Reporting Year
- Reversal
- Your Ref
- Amount FC
  Required
- General Ledger Account (ID)
  Required
- Description
- Project (ID)
- Quantity
- Serial Number
- Asset (ID)
- VAT (Code)
- From
- To
- Cost Center (Code)
- Cost Unit (Code)
Action
Write
- Division
  Required
- Order Number
- Order Date
- Description
- Payment Reference
- Shipping Method
- Your Ref
- Currency (Code)
- Ordered By (ID)
  Required
- Ordered By Contact Person (ID)
- Invoice To (ID)
- Invoice To Contact Person (ID)
- Deliver To (ID)
- Deliver To Contact Person (ID)
- Delivery Address (ID)
- Warehouse (ID)
- Salesperson (ID)
- Selection Code (ID)
- Delivery Date
- Remarks
- Extra Fields
- Info on Custom Fields
- Show Custom Fields
- Item (ID)
  Required
- Description
- Quantity
- Cost Center
- Cost Unit
- Unit Price
- Unit (Code)
- Discount
- Delivery Date
- Extra notes
- Full details in output
- Info on Goods Delivery
- Delivery Date
- Description
- Tracking Number
- Shipping Method
- Remarks
Action
Write
- Division
  Required
- Item (ID)
  Required
- Planned Quantity
  Required
- Description
- Project (ID)
- Warehouse (ID)
- Cost Center (Code)
- Cost Unit (Code)
- Entry Date
- Planned Date
- Your Ref
- Notes
- Extra Fields
Action
Write
- Division
  Required
- Task Type
- Custom Task Type (ID)
- Description
- Action Date
- Account (ID)
- Contact (ID)
- User (ID)
- Opportunity (ID)
- Project (ID)
- Document (ID)
- Employee (ID)
- HID
- Notes
- Extra Fields
Action
Write
- Division
  Required
- Account (ID)
  Required
Action
Write
- Division
  Required
- Sales Invoice (ID)
  Required
Action
Write
- Division
  Required
- Sales Order (ID)
  Required
Action
Write
- Division
  Required
- Subscription (ID)
  Required
Action
Write
- Division
  Required
- Webhook
  Required
Action
Write
- Division
  Required
- Item (ID)
  Required
- Unit (ID)
  Required
- Supplier (ID)
  Required
- Purchase Unit (Code)
  Required
- Main Supplier
- Notes
- Extra Fields
Action
Write
- Division
  Required
- Sales Order (ID)
  Required
- Document Layout (ID)
- Email Layout (ID)
- Send Email To Customer
- Sender Email Address
- Extra Fields
Action
Write
- Division
  Required
- Account (ID)
  Required
- Status
- Code
- Name
- Address Line 1
- Address Line 2
- Address Line 3
- Postcode
- City
- State/Province/County (Code)
- Country (Code)
- Language (Code)
- Chamber Of Commerce
- VAT-Number
- Email address
- Phone
- Sales VAT Code
- Shipping Method (ID)
- Price List (ID)
- Is Supplier
- Lead Source (ID)
- Blocked
- Payment Condition Sales (Code)
- General Ledger Account Sales (ID)
- Discount Sales
- Search Code
- AccountManager (ID)
- Remarks
Action
Write
- Division
  Required
- Bank Account (ID)
  Required
- Account (ID)
- Description
- Bank Account Holder Name
- Blocked
- Main
- Extra Fields
Action
Write
- Division
  Required
- Cost Center (ID)
  Required
- Description
- End Date
Action
Write
- Custom Fields URL
  Required
- Show Custom Fields
  Required
Action
Write
- Division
  Required
- Opportunity (ID)
  Required
- Name
- Account (ID)
- Contact (ID)
- Owner (ID)
- Lead Source (ID)
- Reason (ID)
- Project (ID)
- Campaign (ID)
- Opportunity Stage (ID)
- Sales Type (ID)
- Action Date
- Next Action
- Close Date
- Amount DC
- Amount FC
- Rate FC
- Currency (Code)
- Probability
- Notes
Action
Write
Update Purchase Entry
Updates a purchase entry in the system.
Action
Write
Update Purchase Order
Updates a purchase order in the system.
Action
Write
- Division
  Required
- Sales Order Line (ID)
  Required
- Item (ID)
- Delivery Date
- Cost Center (Code)
- Cost Unit (Code)
Action
Write
- Division
  Required
- Sales Entry Line (ID)
  Required
- Amount FC
- Quantity
- VAT (Code)
- Description
- From
- To
- Notes
- Extra Fields
Action
Write
- Division
  Required
- Shop Order (ID)
  Required
- Item (ID)
- Planned Quantity
- Description
- Project (ID)
- Warehouse (ID)
- Cost Center (Code)
- Cost Unit (Code)
- Entry Date
- Planned Date
- Your Ref
- Notes
- Extra Fields
Action
Write
- Division
  Required
- Account (ID)
- Name
- Code
- Email address
- Phone
- Postcode
- Chamber Of Commerce
- VAT Number
- Is Sales
- Is Supplier
- Search Code
- Legacy Mode
Action
Search
- Division
  Required
- Name
- Name (Partial Match)
- Account (ID)
- Email address
- Phone Number
- Chamber Of Commerce
- Code
- VAT Number
- Is Sales
- Is Supplier
- Skip Token
- Load All Results
Action
Search
Find Address
Finds an address in the system.
Action
Search
Find Bank Account
Finds a bank account in the system.
Action
Search
- Division
  Required
- Status
- Created
- Info on timeframe
- Created (From)
- Created (Until)
Action
Search
Find Contact
Finds a contact in the system.
Action
Search
Find Cost Unit
Finds a cost unit in the system.
Action
Search
- Division
  Required
- Document (ID)
- Sales Invoice Number
- Subject
- Document Type
Action
Search
- Division
  Required
- Goods Delivery (ID)
Action
Search
- Division
  Required
- Goods Delivery (ID)
Action
Search
- Division
  Required
- Item (ID)
- Code
- Barcode
- Description
- Note
Action
Search
- Division
  Required
- Item (ID)
- Warehouse (ID)
- Storage Location (ID)
- Skip Token
- Load All Results
Action
Search
- Division
  Required
- Account (ID)
- Contact (ID)
- First Name
- Last Name
- Email address (Exact Match)
- Email address (Partial Match)
- Is Main Contact
- Skip Token
- Load All Results
Action
Search
- Division
  Required
- Quotation (ID)
- Quotation Number
- Status
- Quotation Date From
- Quotation Date Until
- Skip Token
- Load All Results
Action
Search
- Division
  Required
- Sales Invoice (ID)
- Ordered By (ID)
- Invoice Number
- Description (Header)
- Payment Reference
- Order Number
- Your Ref
- Status
- Skip Token
- Load All Results
Action
Search
Find Payment
Finds a payment in the system.
Action
Search
- Division
  Required
- Project Time Transaction (ID)
- Account (ID)
- Project (ID)
- Entry Number
Action
Search
Find Purchase Entry
Finds a purchase entry in the system.
Action
Search
- Division
  Required
- Purchase Entry Line (ID)
- Description
- Info on Looping
- Load All Results
- Skip Token
Action
Search
- Division
  Required
- Purchase Order (ID)
Action
Search
- Division
  Required
- Receivable (ID)
- Account (ID)
- End Date
- Invoice Number
- Status
- Modified Since
Action
Search
- Division
  Required
- Sales Order Line (ID)
- Item (ID)
- Order Status
- Delivery Status
Action
Search
- Division
  Required
- Sales Invoice (ID)
- Ordered By (Account ID)
- Invoice Number
- Description
- Payment Reference
- Order Number
- Status
- Your Ref
- Info on Created range
- Created (from)
- Created (to)
Action
Search
- Division
  Required
- Sales Order (ID)
- Order Number
- Ordered By (Account ID)
- Status
- Delivery Status
- Expand Account Details
- Order Date Filter
- Order Date (From)
- Order Date (Before)
- Warehouse (ID)
Action
Search
- Division
  Required
- Sales Price List Volume Discounts (ID)
- Price List (Code)
Action
Search
Find Subscription
Finds a subscription in the system.
Action
Search
- Division
  Required
- Warehouse Transfer (ID)
- Transfer Number
- Description
Action
Search
- Division
  Required
- Timestamp
  Required
- Line Type
- Approval Status
- Output Fields
Action
Search
- Division
  Required
- Account (ID)
  Required
- Contact (ID)
- Type
- Address Line 1
- Address Line 2
- Address Line 3
- Postcode
- City
- State/Province/County (Code)
- Country (Code)
- Main
- Notes
Action
Search or write
- Division
  Required
- Account (ID)
  Required
- First Name
- Middle Name
- Last Name
- Email address
- Phone
- Mobile
- Is Mailing Excluded
- Notes
- Extra Fields
Action
Search or write
- Division
  Required
- Code
  Required
- Description
  Required
- End Date
Action
Search or write
- Division
  Required
- Goods Receipt (ID)
Action
Search or write
- Division
  Required
- Project (ID)
- Code
- Type
- Account (ID)
- Created
- Type
  Required
- Description
  Required
- Code
- Budget Type (ID)
- Account (ID)
- Account Contact (ID)
- Payment Condition (Code)
- Classification (ID)
- Start Date
- End Date
- Sales Time Quantity
- Fixed Price Item (ID)
- Notes
- Extra Fields
Action
Search or write
- Division
  Required
- Journal (Code)
  Required
- Supplier (ID)
  Required
- Description
- Document (ID)
- Currency (Code)
- Entry Number
- Due Date
- Entry Date
- Invoice Number
- Payment Reference
- Payment Condition (Code)
- Order Number
- Reversal
- Your Ref
- Reporting Period
- Reporting Year
- General Ledger Account (ID)
  Required
- Amount FC
  Required
- VAT (Code)
- Quantity
- From
- To
- Cost Center (Code)
- Cost Unit (Code)
- Description
- Project (ID)
- Serial Number
- Asset (ID)
- Notes
- VAT Amount FC
Action
Search or write
- Division
  Required
- Quotation (ID)
- Quotation Number
- Description
- Created From
- Quotation Date
- Due Date
- Your Ref
- Order Account (ID)
  Required
- Order Account Contact (ID)
- Invoice Account (ID)
- Invoice Account Contact (ID)
- Delivery Account (ID)
- Delivery Account Contact (ID)
- Delivery Address (ID)
- Payment Condition (Code)
- Warehouse (ID)
- Opportunity (ID)
- Currency (Code)
- Remarks
- Item (ID)
  Required
- Quantity
- Unit Price
- Net Price
- Unit (Code)
- Description
- Cost Center (Code)
- Cost Unit (Code)
Action
Search or write
- Division
  Required
- Sales Order Line (ID)
- Item (ID)
  Required
- Order Status
- Delivery Status
- Sales Order (ID)
  Required
- Cost Center (Code)
- Cost Unit (Code)
- Unit (Code)
- Quantity
- Unit Price
- Discount
- Delivery Date
- Description
- Extra notes
- Info on Goods Delivery
- Delivery Date
- Description
- Tracking Number
- Shipping Method
- Remarks
Action
Search or write
- Division
  Required
- Sales Order (ID)
- Order Number
- Ordered By (ID)
  Required
- Status
- Delivery Status
- Expand Account Details
- Order Date Filter
- Order Date (From)
- Order Date (Before)
- Warehouse (ID)
- Order Date
- Description
- Payment Reference
- Shipping Method
- Your Ref
- Currency (Code)
- Ordered By Contact Person (ID)
- Invoice To (ID)
- Invoice To Contact Person (ID)
- Deliver To (ID)
- Deliver To Contact Person (ID)
- Delivery Address (ID)
- Warehouse (ID)
- Salesperson (ID)
- Selection Code (ID)
- Delivery Date
- Remarks
- Extra Fields
- Info on Custom Fields
- Show Custom Fields
- Item (ID)
  Required
- Description
- Quantity
- Cost Center
- Cost Unit
- Unit Price
- Unit (Code)
- Discount
- Delivery Date
- Extra notes
- Full details in output
- Info on Goods Delivery
- Delivery Date
- Description
- Tracking Number
- Shipping Method
- Remarks
Action
Search or write
- Division
  Required
- Warehouse Transfer (ID)
- Transfer Number
- Description
- Status
- Entry Date
  Required
- Planned Delivery Date
- Planned Receipt Date
- Description
- Extra Remarks
- Warehouse From (ID)
  Required
- Warehouse To (ID)
- Extra Fields
- Item (ID)
  Required
- Quantity
- Description
- Storage Location From (ID)
- Storage Location To (ID)
Action
Search or write
- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Instant
Try It
- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Polling
Try It
- Drive
- Spreadsheet
  Required
Trigger
Polling
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Condition Type
  Required
- Background Color
- Text Color
- Bold Text
- Italic Text
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to Copy
  Required
- Worksheet to Copy
  Required
- Copy Worksheet Destination
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Confirm Deletion
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Format Type
  Required
Action
Write
- Spreadsheet
  Required
- Worksheet
  Required
- New Sheet Name
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Sort by Column
  Required
- Sort Order
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- A1 Range
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row ID
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search or write

- Division
  Required
- Receive Updates on Deleted Bank Accounts
- Event Type Copy
Trigger
Instant
Try It
- Division
  Required
- Receive Updates on Deleted Contacts
- Event Type Copy
Trigger
Instant
Try It
- Division
  Required
- Receive Updates on Deleted Items
- Event Type Copy
Trigger
Instant
Try It
- Division
  Required
- Output ID only
- Info on New and Updated
Trigger
Instant
Try It
- Division
  Required
- Receive Updates on Deleted Project Time Transactions
- Event Type Copy
Trigger
Instant
Try It
- Division
  Required
- Receive Updates on Deleted Purchase Orders
- Info on Event Type
Trigger
Instant
Try It
- Division
  Required
- Receive Updates on Deleted Sales Entries
- Event Type Copy
Trigger
Instant
Try It
- Division
  Required
- Expand Account Details
- Receive Updates on Deleted Sales Orders
- Event Type Copy
Trigger
Instant
Try It
- Division
  Required
- Receive Updates on Deleted General Ledger Accounts
Trigger
Instant
Try It
- Division
  Required
- Quotation (ID)
  Required
- Notification Layout
- Reason Code (ID)
- Action
- Opportunity Stage (ID)
- Your Ref
- Info on Project Fields
- Project Code
- Project Description
- Project Type
- Project Budget Type
- Create Project Item Price Agreement
- Project Price Agreement
- Create project WBS
- Project Classification (ID)
- Project (ID)
- Project Invoicing Action
- Project Invoice Date
- Project Prepaid Type
- Project WBS Part Of (ID)
- Update Project Budget And Price Agreement
- Info on Subscription Fields
- Subscription Type (ID)
- Subscription Description
- Subscription Start Date
- Info on Sales Invoice Fields
- Invoice Journal (Code)
Action
Write
- Division
  Required
- Status
- Entry Date
  Required
- Planned Delivery Date
- Planned Receipt Date
- Description
- Extra Remarks
- Warehouse From (ID)
  Required
- Warehouse To (ID)
- Extra Fields
- Item (ID)
  Required
- Quantity
- Description
- Storage Location From (ID)
- Storage Location To (ID)
Action
Write
- Division
  Required
- Account (ID)
  Required
- Contact (ID)
- Type
- Address Line 1
- Address Line 2
- Address Line 3
- Postcode
- City
- State/Province/County (Code)
- Country (Code)
- Main
- Notes
Action
Write
- Division
  Required
- Opening Balance FC
- Closing Balance FC
- Entry Number
- Currency (Code)
- Financial Period
- Financial Year
- Journal (Code)
  Required
- Account (ID)
- Amount FC
  Required
- Amount VAT FC
- Asset (ID)
- Cost Center (Code)
- Cost Unit (Code)
- Entry Date
- Description
- Document (ID)
- Exchange Rate
- General Ledger Account (ID)
  Required
- Our Ref
- Project (ID)
- Quantity
- VAT (Code)
- VAT Percentage
- VAT Type
- Extra remarks
Action
Write
- Division
  Required
- Item Version (ID)
  Required
- Part Item (ID)
  Required
- Type
- Backflush
- Calculator Type
- Cost Center (Code)
- Cost Unit (Code)
- Description
- Detail Drawing
- Net Weight
- Quantity
- Routing Step (ID)
- Waste Percentage
- Notes
- Extra Fields
Action
Write
- Division
  Required
- Subject
- Notes
- Date
- Account (ID)
- Contact (ID)
- Opportunity (ID)
- Document (ID)
- Campaign (ID)
Action
Write
- Division
  Required
- Code
  Required
- Description
  Required
- End Date
Action
Write
- Division
  Required
- Invoice (ID)
- Invoice Number
- Print Sales Invoice
- Document Layout (ID)
- Email Layout (ID)
- Send Email To Customer
- Sender Email Address
Action
Write
- Division
  Required
- Subject
  Required
- Document Type
  Required
- Document Folder
- Document Category
- Account (ID)
- Contact (ID)
- Item (ID)
- Info on Document Attachment
- File Name
- Attachment
Action
Write
- Division
  Required
- Code
  Required
- Description
  Required
- Type
- Allow Costs In Sales
- Balance Side
- Balance Type
- Cost Center (Code)
- Cost Unit (Code)
- Search Code
- VAT (Code)
- Extra Fields
Action
Write
Create Goods Receipt
Creates a goods receipt in the system.
Action
Write
- Division
  Required
- Create Mode
  Required
- Invoice Mode
  Required
- Journal (Code)
  Required
- Delivery Number
- Start Date
- End Date
- Sales Order (ID)
  Required
- Full details in output
- Details on Print Sales Invoice
- Print Sales Invoice
- Document Layout (ID)
- Email Layout (ID)
- Send Email To Customer
- Sender Email Address
Action
Write
- Division
  Required
- Type
  Required
- Description
  Required
- Code
- Budget Type (ID)
- Account (ID)
- Account Contact (ID)
- Payment Condition (Code)
- Classification (ID)
- Start Date
- End Date
- Sales Time Quantity
- Fixed Price Item (ID)
- Notes
- Extra Fields
Action
Write
Create Project Time Transaction
Creates a project time transaction in the system.
Action
Write
Create Purchase Entry Line
Creates a purchase entry line in the system.
Action
Write
- Division
  Required
- Quotation Number
- Quotation Date
- Due Date
- Description
- Your Ref
- Order Account (ID)
  Required
- Order Account Contact (ID)
- Invoice Account (ID)
- Invoice Account Contact (ID)
- Delivery Account (ID)
- Delivery Account Contact (ID)
- Delivery Address (ID)
- Payment Condition (Code)
- Warehouse (ID)
- Opportunity (ID)
- Currency (Code)
- Remarks
- Item (ID)
  Required
- Quantity
- Unit Price
- Net Price
- Unit (Code)
- Description
- Cost Center (Code)
- Cost Unit (Code)
Action
Write
- Division
  Required
- Sales Invoice (ID)
  Required
- Item (ID)
  Required
- Description
- General Ledger Account (ID)
- Quantity
- Unit Price
- Net Price
- Unit (Code)
- Delivery Date
- VAT (Code)
- Cost Center (Code)
- Cost Unit (Code)
- Notes
Action
Write
Create Sales Item Price
Creates a sales item price in the system.
Action
Write
- Division
  Required
- Sales Order (ID)
  Required
- Cost Center (Code)
- Cost Unit (Code)
- Item (ID)
  Required
- Unit (Code)
- Quantity
- Unit Price
- Discount
- Delivery Date
- Description
- Extra notes
- Info on Goods Delivery
- Delivery Date
- Description
- Tracking Number
- Shipping Method
- Remarks
Action
Write
- Division
  Required
- Subscription Type (ID)
  Required
- Description
  Required
- Ordered By
  Required
- Ordered By Contact Person (ID)
- Invoice To (ID)
- Invoice To Contact Person (ID)
- Currency (Code)
- Invoice Day
- Start Date
- End Date
- Invoicing Start Date
- Notes
- Line Type (ID)
- Description
- Item (ID)
  Required
- Quantity
- Unit Price
- Net Price
- From Date
- To Date
- VAT (Code)
- Unit (Code)
- Cost Center (Code)
- Cost Unit (Code)
Action
Write
- Division
  Required
- Description
  Required
- Part Of (ID)
- Project (ID)
  Required
- Invoice Method
- Auto Create Invoice Term
- Block Entry
- Budgeted Cost
- Budgeted Hours
- Budgeted Revenue
- Budget Overrun Hours
- Completed
- Default Item (ID)
- Default Item Is Mandatory
- Start Date
- End Date
- Invoice Date
- Invoice Separately
- Release Invoice Term
- Release Invoice Term Date
- Sequence Number
- Time Quantity To Alert
- Notes
- Extra Fields
Action
Write
- Division
  Required
- Contact (ID)
  Required
Action
Write
- Division
  Required
- Sales Invoice Line (ID)
  Required
Action
Write
Delete Sales Order Line
Deletes a sales order line from the system.
Action
Write
- Division
  Required
- Subscription Line (ID)
  Required
Action
Write
- Download URL
  Required
Action
Write
- Division
  Required
- Description
  Required
- Code
  Required
- Barcode
- Unit (Code)
- Cost Price Standard
- Cost Price Currency
Action
Write
- Division
  Required
- Invoice (ID)
  Required
- Document Layout
- Email Layout
- Send Email To Customer
- Sender Email Address
- Send Invoice Via Peppol
Action
Write
Update Address
Updates an address in the system.
Action
Write
Update Contact
Updates a contact in the system.
Action
Write
- Division
  Required
- Cost Unit (ID)
  Required
- Description
- End Date
Action
Write
- Division
  Required
- General Ledger Account (ID)
  Required
- Type
- Description
- Code
- Cost Center (Code)
- Cost Unit (Code)
- Is Blocked
- Search Code
- VAT (Code)
Action
Write
- Division
  Required
- Project (ID)
  Required
- Type
- Description
- Code
- Budget Type (ID)
- Account (ID)
- Account Contact (ID)
- Payment Condition (Code)
- Classification (ID)
- Start Date
- End Date
- Sales Time Quantity
- Fixed Price Item (ID)
- Notes
- Extra Fields
Action
Write
- Division
  Required
- Purchase Invoice (ID)
  Required
- Type
- Contact Person (ID)
- Currency (Code)
- Description
- Document (ID)
- Due Date
- Exchange Rate
- Invoice Date
- Journal (Code)
- Payment Condition (Code)
- Payment Reference
- Your Ref
- Remarks
Action
Write
- Division
  Required
- Purchase Order Line (ID)
  Required
- Item (ID)
- Cost Center (Code)
- Cost Unit (Code)
- Description
- Unit Price
- Net Price
- Discount
- Project (ID)
- Receipt Date
- Rebill
- VAT (Code)
- Notes
- Extra Fields
Action
Write
Update Sales Entry
Updates a sales entry in the system.
Action
Write
- Division
  Required
- Sales Order (ID)
  Required
- Order Number
- Order Date
- Description
- Payment Reference
- Your Ref
- Currency (Code)
- Ordered By Contact Person
- Deliver To Contact Person
- Delivery Address
- Warehouse (ID)
- Delivery Date
- Info on Custom Fields
- Show Custom Fields
- Document (ID)
Action
Write
Find Profit Loss Overview
Finds the profit loss overview in the system.
Action
Search
- Division
  Required
- Account Classification (ID)
  Required
Action
Search
- Division
  Required
- User (ID)
- Full Name (Exact Match)
- Full Name (Partial Match)
- Email Address
Action
Search
- Division
  Required
- Timestamp
  Required
Action
Search
- Division
  Required
- Bank Entry (ID)
- Entry Number
Action
Search
- Division
  Required
- Created
- Info on timeframe
- Created (From)
- Created (Until)
Action
Search
Find Cost Center
Finds a cost center in the system.
Action
Search
- Status
  Required
Action
Search
Find General Ledger Account(s)
Finds one or multiple general ledger accounts in the system.
Action
Search
- Division
  Required
- Goods Receipt Line (ID)
- Purchase Order (ID)
- Purchase Order Number
Action
Search
- Division
  Required
- Goods Receipt (ID)
Action
Search
- Division
  Required
- Item Group (ID)
- Code
Action
Search
- Division
  Required
- Mail Message (ID)
- Output Fields
  Required
Action
Search
- Division
  Required
- Item (ID)
- Code
- Barcode
- Output Fields
- Skip Token
- Load All Results
Action
Search
- Division
  Required
- Sales Invoice (ID)
- Description (Line)
- Skip Token
- Load All Results
Action
Search
Find Opportunity
Finds an opportunity in the system.
Action
Search
- Division
  Required
- Project (ID)
- Code
- Type
- Account (ID)
- Created
Action
Search
- Division
  Required
- Project Classification (ID)
- Code
- Description
Action
Search
- Division
  Required
- Purchase Invoice (ID)
- Supplier (ID)
- Entry Number
Action
Search
- Division
  Required
- Purchase Order (ID)
- Order Number
- Order Status
- Receipt Status
- Supplier (ID)
- Info on Receipt Date
- Receipt Date (from)
- Receipt Date (to)
Action
Search
- Division
  Required
- Quotation (ID)
- Quotation Number
- Description
- Created From
Action
Search
- Division
  Required
- Sales Entry (ID)
- Invoice Number
- Description
- Payment Reference
- Reporting Year
- Your Ref
- Status
- Info on Looping
- Load All Results
- Skip Token
Action
Search
- Division
  Required
- Sales Price List (ID)
- Code
Action
Search
- Division
  Required
- Sales Item Price (ID)
- Account (ID)
Action
Search
- Division
  Required
- Account (ID)
- Price List (ID)
Action
Search
- Division
  Required
- Item (ID)
Action
Search
- Division
  Required
- Transaction Line (ID)
- Description
- General Ledger Account (ID)
- Cost Center (Code)
- Cost Unit (Code)
- Financial Period
- Financial Year
- Transaction Type
- Load All Results
- Info on Skip Token
- Skip Token
Action
Search
- Division
  Required
- Financial Year
- Financial Period
- Info on Timerange
- Entry Date (From)
- Entry Date (Until)
Action
Search
- Division
  Required
- Account (ID)
- Name
- Code
- Email address
- Phone
- Postcode
- Chamber Of Commerce
- VAT Number
- Is Sales
- Is Supplier
- Search Code
- Legacy Mode
- Status
- Name
  Required
- Code
- Email address
- Phone
- Address Line 1
- Address Line 2
- Address Line 3
- Postcode
- City
- State/Province/County (Code)
- Country (Code)
- Language (Code)
- Chamber Of Commerce
- VAT-Number
- Sales VAT Code
- Invoice Account (ID)
- Shipping Method (ID)
- Price List (ID)
- Is Supplier
- Lead Source (ID)
- Payment Condition Sales (Code)
- General Ledger Account Sales (ID)
- Discount Sales
- Account Manager (ID)
- Blocked
- Remarks
- Extra Fields
- Show Address ID in Output
- Info on Contact
- Contact First Name
- Contact Middle Name
- Contact Last Name
- Contact Email address
- Contact Phone
- Contact Mobile
- Contact Notes
Action
Search or write
- Division
  Required
- Account (ID)
  Required
- Bank Account Holder Name
- Description
- Main
- Blocked
- Extra Fields
Action
Search or write
- Division
  Required
- Code
  Required
- Description
  Required
- End Date
Action
Search or write
- Division
  Required
- Goods Delivery (ID)
- Delivery Date
  Required
- Description
- Tracking Number
- Shipping Method (ID)
- Remarks
- Sales Order Line (ID)
  Required
- Description
- Quantity Delivered
  Required
- Tracking Number
- Batch Number (ID)
- Notes
Action
Search or write
- Division
  Required
- Item (ID)
- Code
- Barcode
- Description
- Note
- Description
  Required
- Code
  Required
- Barcode
- Unit (Code)
- Cost Price Standard
- Cost Price Currency
Action
Search or write
- Division
  Required
- Project Classification (ID)
- Code
- Description
- Description
  Required
- Code
  Required
- Use Employee Cost Center and Cost Unit
- Cost Center (Code)
- Cost Unit (Code)
Action
Search or write
- Division
  Required
- Purchase Invoice (ID)
- Supplier (ID)
  Required
- Entry Number
- Type
  Required
- Contact Person (ID)
- Currency (Code)
- Description
- Document (ID)
- Due Date
- Exchange Rate
- Financial Period
- Financial Year
- Invoice Date
- Journal (Code)
  Required
- Payment Condition (Code)
- Payment Reference
- Warehouse (ID)
- Your Ref
- Remarks
- Extra Fields
- Amount
- Cost Center (Code)
- Cost Unit (Code)
- Description
- Discount
- Expense
- Item (ID)
- Purchase Order Line (ID)
- Net Price
- Unit Price
- Quantity
- VAT (Code)
- VAT Amount
- Rebill
- Project (ID)
- Extra notes
Action
Search or write
- Division
  Required
- Sales Entry (ID)
- Invoice Number
- Description
- Payment Reference
- Reporting Year
- Your Ref
- Status
- Info on Looping
- Load All Results
- Skip Token
- Journal (Code)
  Required
- Customer (ID)
  Required
- Description
- Batch Number
- Currency (Code)
- Document (ID)
- Due Date
- Entry Date
- Entry Number
- External Link Reference
- G Account Amount FC
- Is Extra Duty
- Order Number
- Payment Condition (Code)
- Process Number
- Rate
- Reporting Period
- Reversal
- Amount FC
  Required
- General Ledger Account (ID)
  Required
- Description
- Project (ID)
- Quantity
- Serial Number
- Asset (ID)
- VAT (Code)
- From
- To
- Cost Center (Code)
- Cost Unit (Code)
Action
Search or write
- Division
  Required
- Sales Invoice (ID)
- Ordered By
  Required
- Invoice Number
- Description
- Payment Reference
- Order Number
- Status
- Your Ref
- Info on Created range
- Created (from)
- Created (to)
- Type
- Order Date
- Currency (Code)
- Journal
  Required
- Ordered By Contact Person
- Invoice To
- Invoice To Contact Person
- Deliver To
- Deliver To Contact Person
- Deliver To Address
- Warehouse
- Payment Condition
- Document (ID)
- Remarks
- Extra Fields
- Item
  Required
- Description
- Quantity
- Unit Price
- Net Price
- Cost Center
- Cost Unit
- General Ledger Account
- Unit (Code)
- VAT (Code)
- Delivery Date
- Start Time
- End Time
- Extra notes
- Project
- VAT Amount FC
- Print Sales Invoice
- Document Layout
- Email Layout
- Send Email To Customer
- Sender Email Address
- Invoice Date
- Reporting Period
- Reporting Year
- Send Invoice Via Peppol
Action
Search or write
- Division
  Required
- Subscription Type (ID)
  Required
- Description
  Required
- Ordered By
  Required
- Ordered By Contact Person (ID)
- Invoice To (ID)
- Invoice To Contact Person (ID)
- Currency (Code)
- Invoice Day
- Start Date
- End Date
- Invoicing Start Date
- Notes
- Line Type (ID)
- Description
- Item (ID)
  Required
- Quantity
- Unit Price
- Net Price
- From Date
- To Date
- VAT (Code)
- Unit (Code)
- Cost Center (Code)
- Cost Unit (Code)
Action
Search or write
- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Instant
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Column_name
  Required
- Index
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Source Range
  Required
- Destination Range
  Required
- Paste Type
Action
Write
- Drive
- Title
  Required
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Validation Type
  Required
- Input Message
- Strict Validation
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Columns
  Required
- Row count
  Required
- Output format
- First row
Action
Search
- Spreadsheet ID
  Required
- Include Grid Data
Action
Search
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write

About Exact Online

Exact Online is a cloud-based accounting and ERP software tailored for SMEs, offering financial management, invoicing, and inventory tracking.

Learn moreLearn moreHelpHelp

Related categories

Accounting

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn moreLearn moreHelpHelp

Related categories

Google

Spreadsheets

Similar apps

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

Quip

Documents

Related Zap Templates

Track new or updated Exact Online bank entries by creating rows in Google Sheets