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 WorksheetCreate a blank worksheet with a title. Optionally, provide headers.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
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 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 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 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 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 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 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.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.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.Find Account
Finds an account 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 General Ledger Account
Finds a General Ledger Account 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 Purchase Entry
Finds a Purchase Entry 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 Invoice
Finds a Sales Invoice 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 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 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 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 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 ZapScheduledZapier 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 To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
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
Text Bold
Text Italic
Text 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
Bottom-Up
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
Headers
Overwrite?
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
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 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 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 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 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 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 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 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.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 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 Address
Finds an address in Exact Online.
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 appFind Document
Finds a Document in Exact Online
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Item
Finds an item 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 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 Order
Finds a Sales Order 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 Item
Finds an item 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
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 foundDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier 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.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
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.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
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
Bottom-Up
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
Bottom-Up
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
Similar apps
Zapier Tables
Databases, Spreadsheets, Zapier
Zoho Creator
App Builder, Zoho
