bexio + Google Sheets
Update people in Bexio from new or updated rows in Google Sheets
If you need to update the contacts of your Bexio account, this Zapier integration can help. Once activated, after you add or update a row in Google Sheets, Zapier will lookup and update the person record in Bexio. Keep in mind that the spreadsheet should have a unique identifier to locate the Bexio record you want to update.
If you need to update the contacts of your Bexio account, this Zapier integration can help. Once activated, after you add or update a row in Google Sheets, Zapier will lookup and update the person record in Bexio. Keep in mind that the spreadsheet should have a unique identifier to locate the Bexio record you want to update.
- When this happens...
New or Updated Spreadsheet RowTriggered when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Update PersonUpdates a person.
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 foundStatus of Invoice
Trigger each status changeRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan
New/Updated Person
Triggers when a person is added or updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planState of Project
Trigger each status changeRequired
Try ItTriggerThis is the start of your ZapScheduledZapier 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 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 foundNew/Updated Company
Triggers when a company is added or updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planStatus of Order
Trigger each status changeRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Product
Triggers new Products.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planStatus of Quote
Trigger each status changeRequired
Try ItTriggerThis is the start of your ZapScheduledZapier 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 found
About bexio
Bexio is a business platform for offering accounting, invoices, payroll, and more for small companies in Switzerland.
Related categories
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Similar apps
Zapier Tables
Databases, Spreadsheets, Zapier
Zoho Creator
App Builder, Zoho
