Skip to content

Connect Google Sheets and Yoobi to unlock the power of automation

No credit card required
Free forever for core features
14-day trial for premium features and apps

Choose a Trigger

Choose an Action

Start with Google for free

Top companies trust Zapier to automate work that solves their unique business problems—no coding required.

Set up your first integration

Quickly connect Google Sheets to Yoobi with a Zapier template.

Our most popular template

Create new Yoobi customers from new rows in your Google Sheets team drive spreadsheet
Details
Try it
Google Sheets + Yoobi

Create new Yoobi customers from new rows in your Google Sheets team drive spreadsheet

Google Sheets + Yoobi

How Zapier works

Zapier makes it easy to integrate Google Sheets with Yoobi - no code necessary. See how you can get setup in minutes.

Select a trigger from Google Sheets

A trigger is an event that starts your Zap and runs the workflow. For example, with Google Sheets, a trigger could be "New Spreadsheet Row (Team Drive)."

A trigger is the event that kicks off your automated workflow.

Setup an action from Yoobi

An action is what takes place after the automation is triggered. For example, with Yoobi, the action could be "Create CRM Sale."

An action is the event that your automated workflow performs when triggered.

That’s it! You just connected Google Sheets to Yoobi

With Zapier, it’s never been easier to connect your apps together and automate your most tedious work. Save hours every month.

Triggers and actions are the main components of every automated workflow.

Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023

G2 Badge - Best Est. ROI - Winter 2024

G2 Badge - Best Results - Winter 2024

G2 Badge - Most Implementable - Winter 2024

G2 Badge - Leader Mid-Market - Winter 2024

93%

Customers who say using Zapier has made them better at their job

25m

Customers have created over 25 million Zaps on the platform

6 mins

The average user takes less than 6 minutes to set up a Zap

Make work flow with AI

Level up your Google Sheets to Yoobi integration with AI. Extract, summarize, and transform your integration data with leading AI models like OpenAI, Anthropic, and more.

Learn about AI automation

Illustration of AI enhancing Zapier workflows with automation and app integrations.

Connect Google Sheets and Yoobi to integrate crucial parts of your business

With Zapier, you can integrate everything from basic data entry to end-to-end processes. Here are some of the business-critical workflows that people automate with Zapier.

Automate your lead management and improve conversions

With Zapier, you can automate every part of your lead funnel and give yourself the best chance at converting leads. Automate everything from lead capture to outreach to reporting—and close more deals as a result.

An illustration representing how to automate lead management with Zapier.

Create more impactful campaigns with automation

Measuring campaign performance across platforms can get chaotic. Plus, digging up the right metrics costs you precious time and effort. With Zapier, you can create a centralized view of your performance, skillfully manage your lists, and ensure your campaigns drive ROI across the business.

An illustration representing how to measure campaign impact with Zapier.

Provide world-class support with a little help from automation

Support reps can't be productive when they have to track down crucial information for every incident or ticket. With Zapier, you can automatically send your reps the context they need to resolve tickets quickly and create a seamless customer experience.

An illustration representing how to automate customer support with Zapier.

Automate your way to actionable, up-to-date data

The days of manually exporting and importing data are over. With Zapier, you can send data where it needs to go, in the format you need it—so you can centralize your data and unlock more insights.

An illustration representing how to move and manage data with Zapier.

Resolve incidents faster with automation

Your technical support team wants to focus on tech tickets rather than admin work. With Zapier, you can automate everything from ticket creation to routing to inter-team communication—eliminating friction from incident management and increasing speed to resolution.

An illustration of a flow chart representing how to resolve tickets and incidents with Zapier.

Supported triggers and actions

Zapier helps you create workflows that connect your apps to automate repetitive tasks. A trigger is an event that starts a workflow, and an action is an event a Zap performs.

- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Scheduled
Try It
- Drive
Trigger
Scheduled
Try It
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger Column
Trigger
Instant
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Column_name
  Required
- Index
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write

- Title
  Required
- Spreadsheet to Copy
- Headers
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
Action
Write

- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
Action
Write
- HTTP Method
  Required
- URL
  Required
- Query String Parameters
- Headers
- Headers
- Body
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Value
  Required
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Value
  Required
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search or write
- Primary Contact
  Required
Trigger
Scheduled
Try It
- Status
Trigger
Scheduled
Try It
- Status
Trigger
Scheduled
Try It
- Include Activities
- Include Budget
- Include Description
- Status
Trigger
Scheduled
Try It
- Customer Code
  Required
- CRM Sale code
- CRM Sale Name
- CRM Sale Scheme
  Required
- CRM Sales Scheme Phase
  Required
- CRM Sale source
- Product Group
- Employee number
- First name
- Infix
- Last Name
- Percentage of this sale
- Value of this sale
  Required
- Currency
  Required
- Expected sale date
  Required
- Description
Action
Write
- Name
  Required
- Code
  Required
- 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
- Invoice state
  Required
- 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
  Required
- Function
- Department
- Note
- Employee Number
- Show Custom Fields
Action
Write
- Name
- Code
- State
- Start Date
- End Date
- Label
- Classification
- Customer Code
- Department Name
- Ledger Account
- Cost Center
- Cost Unit
- Currency
  Required
- Main Project Code
- E-mail
- External Approval Report Comment
- External Approval Weekly
- External Approval Reminder Days
- External Approval Language Code
- Fist Name
- Last Name
- Infix
- Project Role Name
- Employee Number
- Name
  Required
- Start Date
- Description
- End Date
- Invoice state
  Required
- Exclude Approval
- Type
- Is Billable
- Ledger Account
- Cost Center
- Cost Unit
- Activity Specify
- Note Required
- Link Project Employee
- Show Custom Fields
- Budget Type
Action
Write
- Employee Number
- Day of Registrations
  Required
- Month
- Year of Registrations
  Required
- Project code or ID
- State of periode
  Required
Action
Write
- Number Registration
- Amount
  Required
- Fully Paid
  Required
- Currency
  Required
Action
Write
- Type
- Email or Phone
  Required
Action
Search
- Code
  Required
- Level of detail
Action
Search
- VAT Number
Action
Search
- Number Registration
Action
Search
- Code
  Required
Action
Search
- Code
  Required
- Level of detail
- Name
  Required
- 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
- Invoice state
  Required
- 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
  Required
- Function
- Department
- Note
- Employee Number
- Show Custom Fields
Action
Search or write
- VAT Number
- Name
  Required
- Code
  Required
- 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
- Invoice state
  Required
- 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
  Required
- Function
- Department
- Note
- Employee Number
- Show Custom Fields
Action
Search or write
- Code
  Required
- Name
- Code
- State
- Start Date
- End Date
- Label
- Classification
- Customer Code
- Department Name
- Ledger Account
- Cost Center
- Cost Unit
- Currency
  Required
- Main Project Code
- E-mail
- External Approval Report Comment
- External Approval Weekly
- External Approval Reminder Days
- External Approval Language Code
- Fist Name
- Last Name
- Infix
- Project Role Name
- Employee Number
- Name
  Required
- Start Date
- Description
- End Date
- Invoice state
  Required
- Exclude Approval
- Type
- Is Billable
- Ledger Account
- Cost Center
- Cost Unit
- Activity Specify
- Note Required
- Link Project Employee
- Show Custom Fields
- Budget Type
Action
Search or write

- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Instant
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger Column
Trigger
Scheduled
Try It
- Drive
- Spreadsheet
  Required
Trigger
Scheduled
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Copy Worksheet Destination
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Value
  Required
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
- Row Count
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Columns
  Required
- Row Count
- First Row
Action
Search
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write
- Changed Since date
  Required
- Primary Contact
  Required
Trigger
Scheduled
Try It
New CRM Sale
Triggers when a new CRM sale record is created
Trigger
Scheduled
Try It
New Department
Triggers when a new department is created.
Trigger
Scheduled
Try It
- Month
- Invoice state
  Required
Trigger
Scheduled
Try It
New Relation
Triggers when a New Relationship Record is created in Yoobi through selection atm. this is not good
Trigger
Scheduled
Try It
- Customer 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
Action
Write
- Fist Name
- Initials
- Infix
- Last Name
- Gender
- Date of Birth
- Employee Number
- BSN
- Employee Abbreviation
- Job Name
- Start Registration Date
- Start Date
- End Date
- Cost Center
- Cost Unit
- Allow Overtime
- Department
- Resourcegroup
- Invoice state
  Required
- Contract Start Date
- Contract End Date
- Contract FTE
- User State
- Username
- User Email
- User Language
- Show Custom Fields
Action
Write
- Employee Number
- Registration Date
  Required
- Project Name
  Required
- Activity Name
  Required
- Type of Registration
  Required
- Cost Registration
- Time Registration
  Required
- Number Registration
- Registration Remarks
Action
Write
- Version
  Required
Action
Write
- Primary Contact
  Required
- Customer Name
- Contact Name
- Keyword
Action
Search
- CRM Sale code
- Customer Code
  Required
Action
Search
- CoC Number
Action
Search
- E-mail
Action
Search
- Number Registration
- Level of detail
Action
Search
- CRM Sale code
- Customer Code
  Required
- CRM Sale Name
- CRM Sale Scheme
  Required
- CRM Sales Scheme Phase
  Required
- CRM Sale source
- Product Group
- Employee number
- First name
- Infix
- Last Name
- Percentage of this sale
- Value of this sale
  Required
- Currency
  Required
- Expected sale date
  Required
- Description
Action
Search or write
- CoC Number
- Name
  Required
- Code
  Required
- 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
- Invoice state
  Required
- 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
  Required
- Function
- Department
- Note
- Employee Number
- Show Custom Fields
Action
Search or write
- E-mail
- Name
  Required
- Code
  Required
- 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
- Invoice state
  Required
- 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
  Required
- Function
- Department
- Note
- Employee Number
- Show Custom Fields
Action
Search or write

Learn how to automate Google Sheets on the Zapier blog

Learn how to automate Yoobi on the Zapier blog

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more Help

Related categories

Similar apps

Zapier Tables

Databases, Spreadsheets, Zapier

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

About 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.

Related categories

Productivity

Connect Google Sheets to Yoobi on the world's largest no-code automation platform

Sign up with Google