Google Sheets + Yoobi
Create new Yoobi customers from new rows in your Google Sheets team drive spreadsheet
Easily turn new Google Sheets entries into Yoobi customer profiles with this convenient workflow. Whenever a new row is added to your team's spreadsheet in Google Sheets, a new customer is instantly created in Yoobi. This means no more manual data entry and more time focusing on serving your clients. Simplify your customer onboarding process with this seamless data-transfer solution.
Easily turn new Google Sheets entries into Yoobi customer profiles with this convenient workflow. Whenever a new row is added to your team's spreadsheet in Google Sheets, a new customer is instantly created in Yoobi. This means no more manual data entry and more time focusing on serving your clients. Simplify your customer onboarding process with this seamless data-transfer solution.
- When this happens...
New Spreadsheet Row (Team Drive)Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
TriggerScheduledZapier checks for new data every 15 min on the Free plan - automatically do this!
Create CustomerCreates a new 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 foundInclude Activities
Include Budget
Include Description
Status
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planCustomer CodeRequired
CRM Sale code
CRM Sale Name
CRM Sale SchemeRequired
CRM Sales Scheme PhaseRequired
CRM Sale source
Product Group
Employee number
First name
Infix
Last Name
Percentage of this sale
Value of this saleRequired
CurrencyRequired
Expected sale dateRequired
Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
CodeRequired
Customer Category
Keywords
Description
KvK
KvK City
VAT/BTW
Invoice Salutation
Invoice Expiration Days
IBAN
Mobile Phone
Fax
Website
Phone
E-mail
Billing E-mail
Ledger Account
Ledger Account Turnover
Cost Center
Cost Unit
StatusRequired
Visiting Address
Visiting Address City
Visiting Address Country
Visiting Address Postalcode
Visiting Address Note
Billing Address
Billing Address City
Billing Address Country
Billing Address Postcode
Billing Address Note
Mailing Address
Mailing Address City
Mailing Address Country
Mailing Address Postalcode
Mailing Address Note
Initials
Fist Name
Infix
Last Name
E-mailaddress
Phone
Gender
Title
Function
Department
Note
Employee Number
Show Custom Fields
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
Code
State
Start Date
End Date
Label
Classification
Customer Code
Department Name
Ledger Account
Cost Center
Cost Unit
Currency
Main Project Code
External Approval Email
External Approval Report Comment
External Approval Weekly
External Approval Reminder Days
External Approval Language Code
First Name
Last Name
Infix
Project Role Name
Employee Number
Name
Start Date
Description
End Date
State
Exclude Approval
Type
Is Billable
Ledger Account
Cost Center
Cost Unit
Activity Specify
Note Required
Link Project Employee
Show Custom Fields
Budget Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Employee NumberRequired
Day of RegistrationsRequired
Month of RegistrationsRequired
Year of RegistrationsRequired
Project code or ID
State of periodeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Invoice Number or Invoice IDRequired
AmountRequired
Fully PaidRequired
Currency
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Type
Email or PhoneRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCustomer Name or IDRequired
Level of detail
ActionThis is an event a Zap performs.SearchFind existing data in your appVAT Number
ActionThis is an event a Zap performs.SearchFind existing data in your appEmployee number or Employee IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProject Code or Project IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCodeRequired
Level of detail
NameRequired
Customer Category
Keywords
Description
KvK
KvK City
VAT/BTW
Invoice Salutation
Invoice Expiration Days
IBAN
Mobile Phone
Fax
Website
Phone
E-mail
Billing E-mail
Ledger Account
Ledger Account Turnover
Cost Center
Cost Unit
StatusRequired
Visiting Address
Visiting Address City
Visiting Address Country
Visiting Address Postalcode
Visiting Address Note
Billing Address
Billing Address City
Billing Address Country
Billing Address Postcode
Billing Address Note
Mailing Address
Mailing Address City
Mailing Address Country
Mailing Address Postalcode
Mailing Address Note
Initials
Fist Name
Infix
Last Name
E-mailaddress
Phone
Gender
Title
Function
Department
Note
Employee Number
Show Custom Fields
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundVAT Number
NameRequired
CodeRequired
Customer Category
Keywords
Description
KvK
KvK City
VAT/BTW
Invoice Salutation
Invoice Expiration Days
IBAN
Mobile Phone
Fax
Website
Phone
E-mail
Billing E-mail
Ledger Account
Ledger Account Turnover
Cost Center
Cost Unit
StatusRequired
Visiting Address
Visiting Address City
Visiting Address Country
Visiting Address Postalcode
Visiting Address Note
Billing Address
Billing Address City
Billing Address Country
Billing Address Postcode
Billing Address Note
Mailing Address
Mailing Address City
Mailing Address Country
Mailing Address Postalcode
Mailing Address Note
Initials
Fist Name
Infix
Last Name
E-mailaddress
Phone
Gender
Title
Function
Department
Note
Employee Number
Show Custom Fields
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundProject Code or Project IDRequired
Name
Code
State
Start Date
End Date
Label
Classification
Customer Code
Department Name
Ledger Account
Cost Center
Cost Unit
Currency
Main Project Code
External Approval Email
External Approval Report Comment
External Approval Weekly
External Approval Reminder Days
External Approval Language Code
First Name
Last Name
Infix
Project Role Name
Employee Number
Name
Start Date
Description
End Date
State
Exclude Approval
Type
Is Billable
Ledger Account
Cost Center
Cost Unit
Activity Specify
Note Required
Link Project Employee
Show Custom Fields
Budget Type
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 foundChanged Since dateRequired
Primary ContactRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan
New CRM Sale
Triggers when a new CRM sale record is created
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Department
Triggers when a new department is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Relation
Triggers when a New Relationship Record is created in Yoobi through selection atm. this is not good
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planCustomer ID
Customer Code
CRM Task Type
Subject
Task Description
Planned Date
Planned Time
Planned End Date
Planned End Time
Executed Date
Executed Time
Priority
Username
Resourcegroup
Contact First Name
Contact Last Name
Contact Email
Contact Phone
Person ID
Contact Info ID
Notification Moment
Notification User ID
Notification Date Offset
Project ID
CRM Sale ID
Taskreport
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First Name
Initials
Middle Name
Last NameRequired
Gender
Date of Birth
Employee NumberRequired
BSN
Employee Abbreviation
Job Name
Start Registration Date
Start Date
End Date
Cost Center
Cost Unit
Allow Overtime
Department
Resource Group
State
Contract Start Date
Contract End Date
Contract FTE
User State
Username
User Email
User Language
Show Custom fields
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Employee NumberRequired
Registration DateRequired
Project NameRequired
Activity NameRequired
Type of RegistrationRequired
Cost Registration
Time RegistrationRequired
Number Registration
Registration Remarks
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.VersionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Primary ContactRequired
Customer Name
Contact Name
Keyword
ActionThis is an event a Zap performs.SearchFind existing data in your appCRM Sale Code
Customer of Relation Code
ActionThis is an event a Zap performs.SearchFind existing data in your appCoC Number
ActionThis is an event a Zap performs.SearchFind existing data in your appEmailRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appInvoice Number or Invoice IDRequired
PDF toevoegen
ActionThis is an event a Zap performs.SearchFind existing data in your appCRM Sale code
Customer CodeRequired
CRM Sale Name
CRM Sale SchemeRequired
CRM Sales Scheme PhaseRequired
CRM Sale source
Product Group
Employee number
First name
Infix
Last Name
Percentage of this sale
Value of this saleRequired
CurrencyRequired
Expected sale dateRequired
Description
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundCoC Number
NameRequired
CodeRequired
Customer Category
Keywords
Description
KvK
KvK City
VAT/BTW
Invoice Salutation
Invoice Expiration Days
IBAN
Mobile Phone
Fax
Website
Phone
E-mail
Billing E-mail
Ledger Account
Ledger Account Turnover
Cost Center
Cost Unit
StatusRequired
Visiting Address
Visiting Address City
Visiting Address Country
Visiting Address Postalcode
Visiting Address Note
Billing Address
Billing Address City
Billing Address Country
Billing Address Postcode
Billing Address Note
Mailing Address
Mailing Address City
Mailing Address Country
Mailing Address Postalcode
Mailing Address Note
Initials
Fist Name
Infix
Last Name
E-mailaddress
Phone
Gender
Title
Function
Department
Note
Employee Number
Show Custom Fields
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundE-mailRequired
NameRequired
CodeRequired
Customer Category
Keywords
Description
KvK
KvK City
VAT/BTW
Invoice Salutation
Invoice Expiration Days
IBAN
Mobile Phone
Fax
Website
Phone
Billing E-mail
Ledger Account
Ledger Account Turnover
Cost Center
Cost Unit
StatusRequired
Visiting Address
Visiting Address City
Visiting Address Country
Visiting Address Postalcode
Visiting Address Note
Billing Address
Billing Address City
Billing Address Country
Billing Address Postcode
Billing Address Note
Mailing Address
Mailing Address City
Mailing Address Country
Mailing Address Postalcode
Mailing Address Note
Initials
Fist Name
Infix
Last Name
E-mailaddress
Phone
Gender
Title
Function
Department
Note
Employee Number
Show Custom Fields
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 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
Smartsheet
SpreadsheetsAbout Yoobi
Yoobi is Cloud software for CRM, project management, time tracking, leave, expenses, planning and invoicing in one tool. Yoobi is used by companies of all sizes.