Google Sheets + Simplicate
Update Google Sheets with newly updated hours from Simplicate
Keep your Google Sheets updated with this intuitive workflow. Whenever your hours are modified in Simplicate, a new row will be added in your selected Google Sheets. This automation helps to deliver real-time data, thereby providing an updated overview of your working hours, saving you from manual data entry and ensure your records remain consistent.
Keep your Google Sheets updated with this intuitive workflow. Whenever your hours are modified in Simplicate, a new row will be added in your selected Google Sheets. This automation helps to deliver real-time data, thereby providing an updated overview of your working hours, saving you from manual data entry and ensure your records remain consistent.
- When this happens...
Updated HoursTriggers when hours or updated.
TriggerScheduledZapier checks for new data every 15 min on the Free plan - automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Invoices Paid
Triggers when invoices are paid.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Companies
Triggers when new companies are created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Employees
Triggers when new employees are created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Projects
Triggers when new projects are created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Services
Triggers when new services are created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planQuotes Sent
Triggers when quotes are sent in a sales process.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew or Updated Companies
Triggers when companies are created or updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew or Updated Employees
Triggers when employees are created or updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew or Updated Projects
Triggers when projects are created or updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUpdated Services
Triggers when services or updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planFirst NameRequired
Initials
Family Name Preposition
Family NameRequired
GenderRequired
Relation Type
Email
Phone
Street and House Number
Zip Code
City
Country Code
Note
Company ID
Function
Email
Phone
Custom Field 1 - Name
Custom Field 1 - Value
Custom Field 2 - Name
Custom Field 2 - Value
Custom Field 3 - Name
Custom Field 3 - Value
Custom Field 4 - Name
Custom Field 4 - Value
Custom Field 5 - Name
Custom Field 5 - Value
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Project IDRequired
Amount
Price
Invoice from
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SubjectRequired
Company IDRequired
Contact ID
Expected Revenue
Start Date
End Date
Source
Chance to Score
Responsible Employee ID
Progress
Organization Profile ID
Note
Custom Field 1 - Name
Custom Field 1 - Value
Custom Field 2 - Name
Custom Field 2 - Value
Custom Field 3 - Name
Custom Field 3 - Value
Custom Field 4 - Name
Custom Field 4 - Value
Custom Field 5 - Name
Custom Field 5 - Value
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IDRequired
NameRequired
Street and House Number
Zip Code
City
Country Code
Relation Type
KVK
Person ID
Function
Email
Phone
Phone
Email
Note
Custom Field 1 - Name
Custom Field 1 - Value
Custom Field 2 - Name
Custom Field 2 - Value
Custom Field 3 - Name
Custom Field 3 - Value
Custom Field 4 - Name
Custom Field 4 - Value
Custom Field 5 - Name
Custom Field 5 - Value
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IDRequired
NameRequired
Project Number
Company IDRequired
Status
Start Date
End Date
Project Manager ID
Invoice Reference
Company Profile ID
Note
Custom Field 1 - Name
Custom Field 1 - Value
Custom Field 2 - Name
Custom Field 2 - Value
Custom Field 3 - Name
Custom Field 3 - Value
Custom Field 4 - Name
Custom Field 4 - Value
Custom Field 5 - Name
Custom Field 5 - Value
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appContact IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProject IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
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 found
Invoices Sent
Triggers when an invoice is sent.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Contacts
Triggers when new contacts are created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Hours
Triggers when new hours are created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Sales
Triggers when new sales are created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Timeline Notes
Triggers when new timeline notes are created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planSales Accepted
Triggers when sales processes are accepted.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew or Updated Contacts
Triggers when contacts created or are updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUpdated Hours
Triggers when hours or updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew or Updated Sales
Triggers when sales are created or updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNameRequired
Street and House Number
Zip Code
City
Country Code
Relation Type
KVK
Person ID
Function
Email
Phone
Phone
Email
Note
Custom Field 1 - Name
Custom Field 1 - Value
Custom Field 2 - Name
Custom Field 2 - Value
Custom Field 3 - Name
Custom Field 3 - Value
Custom Field 4 - Name
Custom Field 4 - Value
Custom Field 5 - Name
Custom Field 5 - Value
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Sales IDRequired
Default Service IDRequired
Revenue Group ID
VAT Code ID
Amount
Price
Track Hours
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Project Number
Company IDRequired
Status
Start Date
End Date
Project Manager ID
Invoice Reference
Company Profile ID
Note
Custom Field 1 - Name
Custom Field 1 - Value
Custom Field 2 - Name
Custom Field 2 - Value
Custom Field 3 - Name
Custom Field 3 - Value
Custom Field 4 - Name
Custom Field 4 - Value
Custom Field 5 - Name
Custom Field 5 - Value
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ContentRequired
Posted byRequired
Organization ID
Employee ID
Person ID
Sales ID
Project ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IDRequired
First NameRequired
Initials
Family Name Preposition
Family NameRequired
GenderRequired
Relation Type
Email
Phone
Street and House Number
Zip Code
City
Country Code
Note
Company ID
Function
Email
Phone
Custom Field 1 - Name
Custom Field 1 - Value
Custom Field 2 - Name
Custom Field 2 - Value
Custom Field 3 - Name
Custom Field 3 - Value
Custom Field 4 - Name
Custom Field 4 - Value
Custom Field 5 - Name
Custom Field 5 - Value
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IDRequired
SubjectRequired
Company IDRequired
Contact ID
Expected Revenue
Start Date
End Date
Source
Chance to Score
Responsible Employee ID
Progress
Status
Note
Custom Field 1 - Name
Custom Field 1 - Value
Custom Field 2 - Name
Custom Field 2 - Value
Custom Field 3 - Name
Custom Field 3 - Value
Custom Field 4 - Name
Custom Field 4 - Value
Custom Field 5 - Name
Custom Field 5 - Value
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appContact E-mail addressRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSales IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNo 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 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 Simplicate
All-in-one CRM and project software: CRM, sales, project management, planning, time registration & invoicing.