bexio + Google Sheets
Create new Google Sheets spreadsheets for each new sales-invoice in bexio
Improve your sales tracking process with this efficient workflow. When a new sales invoice is created in Bexio, it initiates the creation of a spreadsheet in Google Sheets. This keeps your data organized and easily accessible, saving you from the hassle of manual data entry. With this automation flow, keep all your sales data at your fingertips for quick analysis and decision making.
Improve your sales tracking process with this efficient workflow. When a new sales invoice is created in Bexio, it initiates the creation of a spreadsheet in Google Sheets. This keeps your data organized and easily accessible, saving you from the hassle of manual data entry. With this automation flow, keep all your sales data at your fingertips for quick analysis and decision making.
- When this happens...
New Sales-InvoiceTriggers when a Sales-Invoice is created or updated with the chosen status (line items not provided).
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Create SpreadsheetCreates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with 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
New/Updated Company
Triggers when a company is added or updated.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planStatus of Order
Trigger each status changeRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Product
Triggers new Products.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planStatus of Quote
Trigger each status changeRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planCompany NameRequired
Department
Number
EMail
Second EMail
Address
Zip
City
Country
Correspondence Type
Categories
Sectors
Phone
Phone second
Mobile
Fax
Skype Name
Language Id
Remarks
Number of Staff
Tax Nr
Trade Register Number
Url
Contact Person
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Identifier For Existing PeopleRequired
Person Id
Last Name
First Name
Number
Birthday (Format yyyy-mm-dd)
E-Mail
Second E-Mail
Address
Zip
City
Country
Correspondence Type
Group Ids
Phone
Second Phone
Mobile
Fax
Skype Name
Language Id
Remarks
Salutation Form
Salutation Id
Title Id
Company Id
Position
Url
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company or PersonRequired
Company Contact Person
Invoice Date
Payment Due Date
API Reference
Invoice Title
Invoice Status
VAT included in the total
Currency
Bank Account
Project
Line Item Product Key
Line Item Name/Id/CodeRequired
Line Item QuantityRequired
Line Item PriceRequired
Line Item Text
Line Item Discount in %
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.InvoiceRequired
Recipient MailRequired
SubjectRequired
MessageRequired
Mark as pending
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product TypeRequired
NameRequired
Description
CodeRequired
Remarks
UnitRequired
Sales PriceRequired
CurrencyRequired
Vat
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Project TypeRequired
Project StateRequired
Company or PersonRequired
Company Contact Person
Start Date
End Date
Comment
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.BillableRequired
Business ActivityRequired
Company or Person
Company Contact Person
Project
Status
TypeRequired
Date
Duration
Start Time
End Time
Text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Account NumberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appName
ISO 3166
ActionThis is an event a Zap performs.SearchFind existing data in your appOrder Number
API Reference
Include Order PositionsRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appName
Code
ActionThis is an event a Zap performs.SearchFind existing data in your appQuote Number
API Reference
Include Quote PositionsRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appLast NameRequired
First NameRequired
EMail
Number
Phone
Mobile
Birthday
Second EMail
Address
Zip
City
Country
Correspondence Type
Categories
Sectors
Second Phone
Fax
Skype Name
Language Id
Remarks
Salutation Form
Salutation Id
Title Id
Company Id
Position
Url
Contact Person
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDont Change Sheet Structure
No 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.Drive
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
Status of Invoice
Trigger each status changeRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew/Updated Person
Triggers when a person is added or updated.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planState of Project
Trigger each status changeRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planCombined EntryRequired
Automatic Reference Number
Date (line item support)Required
Reference Number (line item support)
CurrencyRequired
Debit Account Numbers (line item support)Required
Credit Account Numbers (line item support)Required
Vat (line item support)
VAT Account
Description (line item support)
Amount (line item support)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Last NameRequired
First NameRequired
Number
Birthday
EMail
Second EMail
Address
Zip
City
Country
Correspondence Type
Categories
Sectors
Phone
Second Phone
Mobile
Fax
Skype Name
Language Id
Remarks
Salutation Form
Salutation Id
Title Id
Company Id
Position
Url
Contact Person
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.File to uploadRequired
FilenameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.InvoiceRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company or PersonRequired
Company Contact Person
Order Date
API Reference
Order Title
VAT included in the total
Project
Line Item Name/IdRequired
Line Item QuantityRequired
Line Item PriceRequired
Line Item Text
Line Item Discount in %
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CodeRequired
Name
Description
Remarks
Sales Price
Currency
Vat
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company or PersonRequired
Company Contact Person
Quote Date
API Reference
quote Title
VAT included in the total
Project
Line Item Name/IdRequired
Line Item QuantityRequired
Line Item PriceRequired
Line Item Text
Line Item Discount in %
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Identifier For Existing CompanyRequired
Company Id
Name
Department
Number
EMail
Second EMail
Address
Zip
City
Country
Correspondence Type
Group Ids
Phone
Second Phone
Mobile
Fax
Skype Name
Language Id
Remarks
Number of staff
Tax Nr
Trade Register Number
Url
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
E-Mail
Number
Phone
Mobile
ActionThis is an event a Zap performs.SearchFind existing data in your appInvoice Number
API Reference
Include Invoice PositionsRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appLast Name
First Name
E-Mail
Number
Phone
Mobile
ActionThis is an event a Zap performs.SearchFind existing data in your appProject NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCompany NameRequired
EMail
Number
Phone
Mobile
Department
Second EMail
Address
Zip
City
Country
Correspondence Type
Categories
Sectors
Phone second
Fax
Skype Name
Language Id
Remarks
Number of Staff
Tax Nr
Trade Register Number
Url
Contact Person
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
CodeRequired
Product TypeRequired
Description
Remarks
UnitRequired
Sales PriceRequired
CurrencyRequired
Vat
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Dont Change Sheet Structure
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 found
About bexio
Related categories
About Google Sheets
Related categories
Related Zap Templates
- Log new Bexio sales-invoices in a Google Sheet
- Update people in Bexio from new or updated rows in Google Sheets
- Update companies in Bexio from new or updated Google Sheets rows
- Add new or updated bexio people to Google Sheets rows effortlessly
- Create bexio sales invoices from new Google Sheets rows
- Create Google Sheets rows for new bexio sales-invoices
- Create Google Sheets rows from new bexio quotes
- Create new Google Sheets rows for every new product in bexio
- Create new bexio persons from new or updated rows in Google Sheets team drive
- Create manual entries in bexio from new or updated rows in Google Sheets
- Create spreadsheets in Google Sheets for new or updated persons in bexio
- Create spreadsheet rows in Google Sheets for new projects in bexio
- Create new Google Sheets columns for newly arrived bexio sales-invoices
- Create spreadsheet rows in Google Sheets for new or updated companies in bexio
- Create new bexio entries from new rows in Google Sheets
Related Zap Templates
- Log new Bexio sales-invoices in a Google Sheet
- Add new or updated bexio people to Google Sheets rows effortlessly
- Create Google Sheets rows from new bexio quotes
- Create manual entries in bexio from new or updated rows in Google Sheets
- Create new Google Sheets columns for newly arrived bexio sales-invoices
- Update people in Bexio from new or updated rows in Google Sheets
- Create bexio sales invoices from new Google Sheets rows
- Create new Google Sheets rows for every new product in bexio
- Create spreadsheets in Google Sheets for new or updated persons in bexio
- Create spreadsheet rows in Google Sheets for new or updated companies in bexio
- Update companies in Bexio from new or updated Google Sheets rows
- Create Google Sheets rows for new bexio sales-invoices
- Create new bexio persons from new or updated rows in Google Sheets team drive
- Create spreadsheet rows in Google Sheets for new projects in bexio
- Create new bexio entries from new rows in Google Sheets