Google Sheets + Simplicate
Manage new or updated Simplicate projects by creating multiple rows in Google Sheets
Stay updated instantly with your projects in Simplicate as they are updated or added. This automation creates multiple rows in your Google Sheets every time there is a new or updated project in Simplicate. It keeps track of all your projects in one place, making it easier for you to manage and organize your work.
Stay updated instantly with your projects in Simplicate as they are updated or added. This automation creates multiple rows in your Google Sheets every time there is a new or updated project in Simplicate. It keeps track of all your projects in one place, making it easier for you to manage and organize your work.
- When this happens...
New or Updated ProjectsTriggers when projects are created or updated.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Create Multiple Spreadsheet RowsCreate one or more new rows in a specific spreadsheet (with line item support).
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 ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier checks for new data every 15 min on the Free planUpdated Services
Triggers when services or updated.
Try ItTriggerThis is the start of your ZapPollingZapier 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 ZapPollingZapier 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.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
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.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
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
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
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.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
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
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
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
Invoices Sent
Triggers when an invoice is sent.
Try ItTriggerThis is the start of your ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier checks for new data every 15 min on the Free planUpdated Hours
Triggers when hours or updated.
Try ItTriggerThis is the start of your ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
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
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
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 Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
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
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
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 appDrive
SpreadsheetRequired
WorksheetRequired
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
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
Search from last row
Row count
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
Search from last row
Row count
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
Related categories
About Simplicate
Related categories
Related Zap Templates
- Add new Simplicate sales to Google Sheets as rows
- Create new rows in Google Sheets for any new projects in Simplicate
- Create spreadsheet rows in Google Sheets for new sales accepted in Simplicate
- Update Google Sheets with newly updated hours from Simplicate
- Create spreadsheet rows in Google Sheets for new hours tracked in Simplicate
- Create spreadsheet rows in Google Sheets for new or updated sales in Simplicate
- Generate multiple Google Sheets rows for every new hours recorded in Simplicate
- Create Google Sheets rows for new Simplicate invoices sent
- Create spreadsheet rows in Google Sheets for new paid invoices in Simplicate
- Update Google Sheets rows with new or updated Simplicate sales