Create or update Fortnox customers from new or updated Google Sheets rows
Effortlessly keep your customer information up-to-date with this Google Sheets to Fortnox automation. When you add or modify rows in your Google Sheets spreadsheet, this workflow will conveniently create or update customer records in Fortnox. Save valuable time and maintain accurate records by eliminating the need for manual data entry.
Effortlessly keep your customer information up-to-date with this Google Sheets to Fortnox automation. When you add or modify rows in your Google Sheets spreadsheet, this workflow will conveniently create or update customer records in Fortnox. Save valuable time and maintain accurate records by eliminating the need for manual data entry.
- When this happens...New or Updated Spreadsheet Row
Triggered when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!Create or Update Customer
Creates or updates a customer
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
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 foundInvoice Bookkept
Triggers when an invoice is bookkept.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planInvoice Payment Bookkept
Triggers when an invoice payment is bookkept.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Order
Triggers when a new order is created. Note that a order created from an Offer may have rows but if you just created the order manually it will probably not. Please use something like "Delay by Zapier" and then fetch the order again using "Find Order" to give yourself more time to set rows and other properties.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planName
Customer Number
Customer Email
Active
Invoicing email
Invoicing email CC
Invoicing email BCC
Default Delivery Type For Invoice
Default Delivery Type For Order
Default Delivery Type For Offer
Address 1
Address 2
Zip Code
City
Country code
Fax
Comments
Currency
External reference
GLN
Invoice remark
Our reference
Your reference
Phone number
Price List
Organisation number
Type
Show prices with VAT included
VAT number
VAT type
Delivery Address 1
Delivery Address 2
Delivery Zip code
Delivery City
Delivery Country Code
Delivery Fax
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Document NumberRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order NumberRequired
Article Number
DescriptionRequired
Quantity
Unit
Price
Discount
Discount Type
VAT
Account Number
Project
Cost Center
Stock Point Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Article Number
DescriptionRequired
Bulky
Construction Account
Disposable Quantity
EAN
EU Account
EU VAT Account
Export Account
Height
Width
Depth
Weight
Housework
Housework Type
Active
Manufacturer
Manufacturer Article Number
Note
Purchase Account
Purchase Price
Quantity In Stock
Sales Account
Stock Goods
Stock Place
Stock Value
Stock Warning
Supplier Name
Supplier Number
Type
Unit
VAT
Webshop Article
Expired
Direct Cost
Freight Cost
Other Cost
Stock Account
Stock Change Account
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer NumberRequired
Order Number
Delivery Date
Currency
External Invoice Reference
VAT Included
Remarks
Customer's Order Number
Customer's Reference
Tax Reduction Type
Terms Of Payment
Terms Of Delivery
Way Of Delivery
Language
Freight
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Article NumberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCustomer NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appOrder numberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDescriptionRequired
Article Number
Bulky
Construction Account
Disposable Quantity
EAN
EU Account
EU VAT Account
Export Account
Height
Width
Depth
Weight
Housework
Housework Type
Active
Manufacturer
Manufacturer Article Number
Note
Purchase Account
Purchase Price
Quantity In Stock
Sales Account
Stock Goods
Stock Place
Stock Value
Stock Warning
Supplier Name
Supplier Number
Type
Unit
VAT
Webshop Article
Expired
Direct Cost
Freight Cost
Other Cost
Stock Account
Stock Change Account
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundCustomer NumberRequired
Name
Customer Email
Active
Invoicing email
Invoicing email CC
Invoicing email BCC
Default Delivery Type For Invoice
Default Delivery Type For Order
Default Delivery Type For Offer
Address 1
Address 2
Zip Code
City
Country code
Fax
Comments
Currency
External reference
GLN
Invoice remark
Our reference
Your reference
Phone number
Price List
Organisation number
Type
Show prices with VAT included
VAT number
VAT type
Delivery Address 1
Delivery Address 2
Delivery Zip code
Delivery City
Delivery Country Code
Delivery Fax
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundInvoice numberRequired
Customer NumberRequired
Invoice date
Due date
Currency
External Invoice Reference
VAT Included
Remarks
Customer's order number
Customer's reference
Tax Reduction Type
Language
Freight
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
No 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 foundCustomer Created
Triggers when a new customer is created or first time we see an update on it.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planInvoice Fully Paid
Triggers when an invoice is fully paid.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Article
Triggers when a new article is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planInvoice numberRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer NumberRequired
Invoice number
Invoice date
Due date
Currency
External Invoice Reference
VAT Included
Remarks
Customer's order number
Customer's reference
Tax Reduction Type
Language
Freight
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Invoice NumberRequired
Article Number
Description
Quantity
Unit
Price
Discount
Discount type
VAT
Account number
Project
Cost Center
Stock Point Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project Number
DescriptionRequired
Contact Person
Project Leader
Status
Start Date
End Date
Comments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CodeRequired
DescriptionRequired
Note
Active
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Article nameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCustomer NumberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDocument NumberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appOrder numberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appArticle NumberRequired
DescriptionRequired
Bulky
Construction Account
Disposable Quantity
EAN
EU Account
EU VAT Account
Export Account
Height
Width
Depth
Weight
Housework
Housework Type
Active
Manufacturer
Manufacturer Article Number
Note
Purchase Account
Purchase Price
Quantity In Stock
Sales Account
Stock Goods
Stock Place
Stock Value
Stock Warning
Supplier Name
Supplier Number
Type
Unit
VAT
Webshop Article
Expired
Direct Cost
Freight Cost
Other Cost
Stock Account
Stock Change Account
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNameRequired
Customer Number
Customer Email
Active
Invoicing email
Invoicing email CC
Invoicing email BCC
Default Delivery Type For Invoice
Default Delivery Type For Order
Default Delivery Type For Offer
Address 1
Address 2
Zip Code
City
Country code
Fax
Comments
Currency
External reference
GLN
Invoice remark
Our reference
Your reference
Phone number
Price List
Organisation number
Type
Show prices with VAT included
VAT number
VAT type
Delivery Address 1
Delivery Address 2
Delivery Zip code
Delivery City
Delivery Country Code
Delivery Fax
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundOrder NumberRequired
Customer NumberRequired
Delivery Date
Currency
External Invoice Reference
VAT Included
Remarks
Customer's Order Number
Customer's Reference
Tax Reduction Type
Terms Of Payment
Terms Of Delivery
Way Of Delivery
Language
Freight
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