Connect Seven Time and Google Sheets to unlock the power of automation
- No credit card required
- Free forever for core features
- 14-day trial for premium features and apps
Top companies trust Zapier to automate work that solves their unique business problems—no coding required.
How Zapier works
Zapier makes it easy to integrate Seven Time with Google Sheets - no code necessary. See how you can get setup in minutes.
Select a trigger from Seven Time
Setup an action from Google Sheets
That’s it! You just connected Seven Time to Google Sheets
Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023
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
Connect Seven Time and Google Sheets 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
Create more impactful campaigns with automation
Provide world-class support with a little help from automation
Automate your way to actionable, up-to-date data
Resolve incidents faster with automation
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.
- New Invoice
Triggers when a new invoice is created in Seven Time.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan - New Task
Triggers when a new task is created in Seven Time.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan - New Work Order
Triggers when a new work order is created in Seven Time.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan - Updated Contact Person
Triggers when a contact person is updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan - Updated Invoice
Triggers when an invoice is updated in Seven Time.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan - Updated Task
Triggers when a task is updated in Seven Time.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan - Updated User
Triggers when a user is updated in Seven Time.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan - Customer
- NameRequired
- Title
- Work phone
- Cell phone
- Email
- Is active
- Main contact
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Customer
- Created by userRequired
- LanguageRequired
- NameRequired
- Invoice date
- Due date
- Project
- Marking
- Your order number
- Contact person
- Our reference
- Work order
- Result unit
- Delivery address
- Invoice type
- Price list
- Multiple taxes on rows
- Tax percent
- Currency code
- Currency rate
- Notes
- Invoice items
- Use footer from settings
- Footer text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Created by userRequired
- Title
- Work order
- Project
- User
- Start date
- Due date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Title
- Customer
- Created by userRequired
- Project
- Start date
- End date
- Estimated time
- Description
- Your order number
- Work addresss
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- IDRequired
- User
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- IDRequired
- Modified by userRequired
- NameRequired
- Customer number
- Address
- Address 2
- Zip code
- City
- Country
- Phone
- Email
- Organization number
- VAT number
- Payment days
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- IDRequired
- Modified by userRequired
- NameRequired
- Project number
- Customer
- Contact person
- Project leader
- Department
- Start date
- End date
- Notes
- Billing method
- Price per hour
- Fixed price
- Time category price list
- Marking
- Your order number
- Delivery address
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- IDRequired
- Modified by userRequired
- User
- TimestampRequired
- End timestamp
- Time
- Invoiceable time
- Customer
- Project
- Time category
- Work order
- Price per hour
- Description
- Internal description
- Supplement order
- Is invoiceable
- Is absence
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- User
- Project
- Customer
- Work order
- Time category
- Task
ActionThis is an event a Zap performs.SearchFind existing data in your app- Customer
- NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- 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 plan- 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
- Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- Title
- 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
- 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
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 app- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row Count
- First Row
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- Title
- 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
- New Customer
Triggers when a new customer is created in Seven Time.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan - New Project
Triggers when a new project is created in Seven Time.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan - New Time Log
Triggers when a new time log is created in Seven Time.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan - User
- Work order
- Project
- Customer
- Time category
- Task
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan- Updated Customer
Triggers when a customer is updated in Seven Time.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan - Updated Project
Triggers when a project is updated in Seven Time.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan - Updated Time Log
Triggers when a time log is updated in Seven Time.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan - Updated Work Order
Triggers when a work order is updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan - Created by userRequired
- NameRequired
- Customer number
- Address
- Address 2
- Zip code
- City
- Country
- Phone
- Email
- Organization number
- VAT number
- Payment days
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Created by userRequired
- NameRequired
- Project number
- Customer
- Contact person
- Project leader
- Department
- Start date
- End date
- Notes
- Billing method
- Price per hour
- Fixed price
- Time category price list
- Marking
- Your order number
- Delivery address
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Created by userRequired
- User
- TimestampRequired
- End timestamp
- Time
- Invoiceable time
- Customer
- Project
- Time category
- Work order
- Price per hour
- Description
- Internal description
- Supplement order
- Is invoiceable
- Is absence
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- NameRequired
- Customer number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- NameRequired
- Project number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- User
- Customer
- Project
- Work order
- Time category
- Task
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- IDRequired
- Customer
- NameRequired
- Title
- Work phone
- Cell phone
- Email
- Is active
- Main contact
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- IDRequired
- Modified by userRequired
- Customer
- LanguageRequired
- NameRequired
- Invoice date
- Due date
- Project
- Marking
- Your order number
- Contact person
- Our reference
- Work order
- Result unit
- Delivery address
- Invoice type
- Price list
- Multiple taxes on rows
- Tax percent
- Currency code
- Currency rate
- Notes
- Invoice items
- Use footer from settings
- Footer text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- IDRequired
- Modified by userRequired
- Title
- Work order
- Project
- User
- Start date
- Due date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- IDRequired
- Modified by userRequired
- Title
- Customer
- Project
- Start date
- End date
- Estimated time
- Description
- Your order number
- Work addresss
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Invoice numberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Title
- Work order number
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan- 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.- Title
- 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.- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Headers
- Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- Title
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
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