Fortnox + Google Sheets
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 RowTriggers when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create or Update CustomerCreates 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 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.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
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.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
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
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.Stop on errorRequired
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
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
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
Customer Created
Triggers when a new customer is created or first time we see an update on it.
Try ItTriggerThis is the start of your ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier checks for new data every 15 min on the Free planHTTP MethodRequired
EndpointRequired
Query Parameters
Request Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
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 ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
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
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
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.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
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
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
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
Row count
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
Row count
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 ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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
Housework Type
Housework?
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
About Fortnox
Related categories
About Google Sheets
Related categories
Related Zap Templates
- Track bookkept Fortnox invoices by creating new rows in Google Sheets
- Create new Google Sheets rows for new orders in Fortnox
- Create Google Sheets rows for new Fortnox articles for easy tracking
- Create new Google Sheets rows from newly created Fortnox customers
- Create multiple rows in Google Sheets when new invoices are bookkept in Fortnox