Google Sheets + Productive.io
Make projects in Productive.io from new Google Sheets spreadsheets
Manage your projects without ever having to leave your spreadsheet. All you have to do is activate this integration, which will then automatically generate a new project in Productive.io as soon as a new spreadsheet is created in Google Sheets.
Manage your projects without ever having to leave your spreadsheet. All you have to do is activate this integration, which will then automatically generate a new project in Productive.io as soon as a new spreadsheet is created in Google Sheets.
- When this happens...
New SpreadsheetTriggers when a new spreadsheet is created.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Create ProjectCreate new project.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDont Change Sheet Structure
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.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.Drive
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
Booking Deleted
Triggers when Booking is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Budget Deleted
Triggers when Budget is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Contact Update
Triggers when Contact is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Deal Update
Triggers when Deal is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Expense Update
Triggers when Expense is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Booking
New booking created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Contact
New contact created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Expense
Triggers when Expense is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Project
New project created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Project Update
Triggers when project is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Task Update
Triggers when Task is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.NameRequired
Due Days
Default Currency
Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
CompanyRequired
CurrencyRequired
ResponsibleRequired
ProbabilityRequired
Contact
Document Type
Deal StatusRequired
Sales Status
Number
Deal Members
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
ProjectRequired
Task ListRequired
Assignee
Due Date
Due Time
Body
Tags
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 appEmailRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
Dont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Dont Change Sheet Structure
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 foundBooking Update
Triggers when Booking is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Budget Update
Triggers when budget is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Deal Deleted
Triggers when Deal is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Expense Deleted
Triggers when Expense is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Invoice Update
Triggers when Invoice is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Budget
Triggers when new Budget is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Deal
New deal created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Invoice
New invoice created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Task
New task created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Task Deleted
Triggers when Task is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.PersonRequired
TypeRequired
Start DateRequired
End DateRequired
TimeRequired
Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First NameRequired
Last Name
EmailRequired
Job Title
Company
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
CompanyRequired
Project ManagerRequired
WorkflowRequired
AccessRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
ProjectRequired
Board
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCompany NameRequired
NameRequired
Due Days
Default Currency
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 found
About Google Sheets
Related categories
About Productive.io
Related categories
Related Zap Templates
- Create Productive.io tasks for new spreadsheets on Google Sheets
- Create spreadsheet rows in Google Sheets for new contacts in Productive.io
- Update Google Sheets rows whenever Productive.io budgets are updated
- Create spreadsheet rows in Google Sheets for new deals in Productive.io
- Create Google Sheets rows for new Productive.io budgets