Exact Online + Google Sheets
Track new or updated bank accounts in Exact Online and create worksheets in Google Sheets
Manage your bank account records the smart way. With this workflow, as soon as there's a new or updated bank account in Exact Online, an equivalent worksheet will be created instantly in Google Sheets. This automation helps you keep track of financial changes efficiently, making your financial record keeping process straightforward and error-free.
Manage your bank account records the smart way. With this workflow, as soon as there's a new or updated bank account in Exact Online, an equivalent worksheet will be created instantly in Google Sheets. This automation helps you keep track of financial changes efficiently, making your financial record keeping process straightforward and error-free.
- When this happens...
New or Updated Bank AccountTriggers when a bank account is created or updated.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create WorksheetCreates a new worksheet in a Google Sheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
DivisionRequired
Event Type
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.DivisionRequired
Event Type
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.DivisionRequired
Event Type
Expand Batch Numbers
Expand Serial Numbers
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.DivisionRequired
Event Type
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.DivisionRequired
Event Type
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.DivisionRequired
Event Type
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.DivisionRequired
Event Type
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.DivisionRequired
Event Type
Expand Account Details
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Create Purchase Entry
Creates a Purchase Entry in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Account
Creates an account in Exact Online.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Bank Account
Creates a Bank Account in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Bill of Material (Bom) Material
Creates a Bill of Material (BOM) Material
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Contact
Creates a new contact in Exact Online.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Cost Unit
Creates a Cost Unit in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Document
Creates a Document in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create General Journey Entry
Creates a General Journey Entry in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Goods Delivery
Creates a Good Delivery in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Opportunity
Creates an Opportunity in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Project Classification
Creates a Project Classification in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Purchase Order
Creates a Purchase Order in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Sales Invoice
Creates a Sales Invoice in Exact Online.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Sales Entry
Create a Sales Entry in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Sales Order
Creates a Sales Order in Exact Online.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Subscription
Creates a Subscription in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Delete Account
Deletes an Account in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Delete Sales Invoice
Deletes a Sales Invoice in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Delete Sales Order
Deletes a Sales Order in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Delete Subscription
Deletes a Subscription in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Delete Webhook Subscription
Deletes a Webhook Subscription
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Item
Creates a new Item in Exact Online.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Send Sales Invoice
Sends a Sales Invoice in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Update Address
Updates an Address in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Update Contact
Updates a Contact in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Update Cost Unit
Updates a Cost Unit in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Update Purchase Entry
Updates a Purchase Entry in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Update Sales Order Line
Updates a Sales Order Line in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Update Sales Order
Updates a Sales Order in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Find Account
Finds an account in Exact Online.
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Address
Finds an address in Exact Online.
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Bank Account
Finds a Bank Account in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Contact
Finds a Contact in Exact Online.
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Cost Unit
Finds a Cost Unit in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Document
Finds a Document in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Goods Delivery
Finds a Goods Delivery in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Item(s)
Finds one or multiple items in Exact Online.
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Mail Message Sent
Finds a Sent Mail Message in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Many Items
Finds many items in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Payment
Finds a Payment in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Project Time Transaction
Finds a Project Time Transaction in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Purchase Invoice
Finds a Purchase Invoice in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Purchase Order
Finds a Purchase Order in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Receivable
Finds a Receivable in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Sales Order Line
Finds a Sales Order Line in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Sales Invoice
Finds a Sales Invoice in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Sales Order
Finds a Sales Order in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Sales Price List Volume Discount
Finds Sales Price List Volume Discounts in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Warehouse Transfer
Finds a Warehouse Transfer in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind or Create Address
Finds an address in Exact Online.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFind or Create Contact
Finds a Contact in Exact Online.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFind or Create Cost Unit
Finds a Cost Unit in Exact Online
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFind or Create Item
Finds one or multiple items in Exact Online.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFind or Create Purchase Entry
Finds a Purchase Entry in Exact Online
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFind or Create Quotation
Finds a Quotation in Exact Online
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFind or Create Sales Order Line
Finds a Sales Order Line in Exact Online
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFind or Create Sales Order
Finds a Sales Order in Exact Online
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFind or Create Warehouse Transfer
Finds a Warehouse Transfer in Exact Online
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNo Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
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.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Apply standard error handling?Required
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
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
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
DivisionRequired
Event Type
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.DivisionRequired
Event Type
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.DivisionRequired
Event Type
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.DivisionRequired
Event Type
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.DivisionRequired
Event Type
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.DivisionRequired
Event Type
Expand Account Details
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.DivisionRequired
Event Type
Expand Account Details
Expand Contact Details
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.DivisionRequired
Event Type
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Create Warehouse Transfer
Creates a Warehouse Transfer in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Address
Creates an Address in Exact Online.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Bank Entry
Creates a Bank Entry in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Cash Entry
Creates a Cash Entry in Exact Online.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Cost Center
Creates a Cost Center in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Direct Debit Mandate
Creates a Direct Debit Mandate in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Document Attachment
Creates a Document Attachment in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Goods Receipt
Creates a Goods Receipt in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Sales Invoice From Sales Order
Creates a Sales Invoice from a Sales Order in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Project
Creates a Project in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Purchase Invoice
Creates a Purchase Invoice in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Quotation
Creates a Quotation in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Sales Invoice Line
Creates a Sales Invoice Line in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Sales Item Price
Creates a Sales Item Price in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Sales Order Line
Creates a Sales Order Line in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create WBS Activity
Creates a WBS Activity in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Delete Contact
Deletes a Contact in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Delete Sales Invoice Line
Deletes a Sales Invoice Line in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Delete Sales Order Line
Deletes a Sales Order Line in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Delete Subscription Line
Deletes a Subscription Line in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Download URLRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Send Sales Order
Sends a Sales Order in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Update Account
Updates an Account in Exact Online.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Update Bank Account
Updates a Bank Account in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Update Cost Center
Updates a Cost Center in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Update Opportunity
Creates an Opportunity in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Update Purchase Order
Updates a Purchase Order in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Update Sales Entry
Updates a Sales Entry in Exact Online
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Find Profit Loss Overview
Finds the Profit Loss Overview in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Many Accounts
Finds many Accounts in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appDivisionRequired
TimestampRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Bank Entry
Finds a Bank Entry in Exact Online.
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Cost Center
Finds a Cost Center in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appStatusRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appFind General Ledger Account
Finds a General Ledger Account in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Goods Receipt Line
Finds a Goods Receipt Line in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Item Group(s)
Finds one or multiple Item Groups in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Many Contacts
Finds many Contacts in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Opportunity
Finds an Opportunity in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Project
Finds a Project in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Purchase Entry
Finds a Purchase Entry in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Purchase Entry Line
Finds a Purchase Entry Line in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Quotation
Finds a Quotation in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Sales Entry
Finds a Sales Entry in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Sales Price List
Finds a Sales Price Lists in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Sales Item Price
Finds a Sales Item Price in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Sales Price List Linked Account
Finds a Sales Price List Linked Account in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Subscription
Finds a Subscription in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind or Create an Account
Finds an account in Exact Online.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFind or Create Bank Account
Finds a Bank Account in Exact Online
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFind or Create Cost Center
Finds a Cost Center in Exact Online
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFind or Create Goods Delivery
Finds a Goods Delivery in Exact Online
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFind or Create Project
Finds a Project in Exact Online
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFind or Create Purchase Invoice
Finds a Purchase Invoice in Exact Online
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFind or Create Sales Entry
Finds a Sales Entry in Exact Online
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFind or Create Sales Invoice
Finds a Sales Invoice in Exact Online
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFind or Create Subscription
Finds a Subscription in Exact Online
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNo 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.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.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
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
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
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
About Exact Online
Related categories
About Google Sheets
Related categories
Related Zap Templates
- Create new Exact Online accounts from new or updated rows in Google Sheets team drive
- Create multiple rows in Google Sheets for new or updated sales orders in Exact Online
- Create spreadsheet rows in Google Sheets for new or updated sales orders in Exact Online
- Create multiple spreadsheet rows in Google Sheets for new or updated sales orders in Exact Online