Google Sheets + ProLine
Create or update ProLine projects from new Google Sheets rows
Streamline your project management process with this efficient workflow. When a new row is added to your Google Sheets, the associated details will instantly be used to create or update a project in ProLine. This way, your project information remains up-to-date without the need for manual data entry, saving you time and increasing productivity.
Streamline your project management process with this efficient workflow. When a new row is added to your Google Sheets, the associated details will instantly be used to create or update a project in ProLine. This way, your project information remains up-to-date without the need for manual data entry, saving you time and increasing productivity.
- When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create or Update ProjectCreates or updates a 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
Drive
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
Chargeback Complete
Triggers when a chargeback reaches its final status. Final status can be either Won or Lost.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Trigger on...Required
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Trigger on...Required
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Trigger on...Required
Stage [Filter]
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Refund Complete
Triggers when a refund reaches its final status. Final status can be either Complete or Failed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Contact ID
Project ID
Notification (Main)Required
Notification (Extended)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact IDRequired
User
Call TypeRequired
Call Duration
Recording
Voicemail
External ID
Call Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact ID
First Name
Last Name
Organization
Phone
Email
Contact Type
Lead Source
Contact Tags
Notes
Address Line 1
Address Line 2
City
State
Zip Code
Campaign
Assignee
External ID
Custom Field 1
Custom Field 2
Custom Field 3
Custom Date 1
Custom Date 2
Custom Date 3
Time Zone
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project | Edit by Project ID
Project | Edit by External ID
Project | Edit by Contact
Project | Name
Project | Location
Project | Area
Project | Main Assignee
Project | Inside Sales Assignee
Project | Production Assignee
Project | Accounting Assignee
Project | Move to Stage
Project | Start Campaign
Project | Address Line 1
Project | Address Line 2
Project | City
Project | State
Project | Zip
Project | Category
Project | Type
Project | Services
Project | Tags
Project | Custom Field 1
Project | Custom Field 2
Project | Custom Field 3
Project | Custom Field 4
Project | Custom Field 5
Project | Custom Field 6
Project | Custom Field 7
Project | Notes
Project | New External ID
Contact | Contact ID
Contact | First Name
Contact | Last Name
Contact | Full Name
Contact | Phone
Contact | Email
Contact | Type
Contact | Lead Source
Contact | Tags
Event | Edit by External ID
Event | New External ID
Event | Start Date
Event | Event Type
Event | Time Zone
Event | External Reschedule Link
Event | Exclude From Integration
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IDRequired
File URLRequired
File Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact ID
Phone
Email
Address Line 1
Address Line2
City
State
Zip Code
ActionThis is an event a Zap performs.SearchFind existing data in your appProline ID
Organization External ID
Primary Contact ID
[FILTER] Organization Stage
Organization Name
Organization Address
ActionThis is an event a Zap performs.SearchFind existing data in your appProLine Number
User Email
Display Name
ActionThis is an event a Zap performs.SearchFind existing data in your appProline ID
Organization External ID
Primary Contact ID
[FILTER] Organization Stage
Organization Name
Organization Address
Organization ID
Organization External ID
Organization NameRequired
Organization TypeRequired
Organization StageRequired
Assignee
Primary Contact | Contact ID
Primary Contact | First Name
Primary Contact | Last Name
Primary Contact | Phone Number
Primary Contact | Email
Primary Contact | Type
Primary Contact | Lead Source
Primary Contact | Tags
Other Contacts | List of Contact IDs
Address 1
Address 2
City
State
Zip
Notes
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
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 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 foundTrigger on...Required
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Trigger on...Required
Organization Stage [Filter]
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Trigger on...Required
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Payment Complete
Triggers when a payment reaches its final status. Final status can be either Complete or Failed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Trigger on...Required
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Zapier Trigger StepRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Event IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact IDRequired
User
Message TypeRequired
Message BodyRequired
Message Note
External ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Organization ID
Organization External ID
Organization NameRequired
Organization TypeRequired
Organization StageRequired
Assignee
Primary Contact | Contact ID
Primary Contact | First Name
Primary Contact | Last Name
Primary Contact | Phone Number
Primary Contact | Email
Primary Contact | Type
Primary Contact | Lead Source
Primary Contact | Tags
Other Contacts | List of Contact IDs
Address 1
Address 2
City
State
Zip
Notes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event ID
Project ID
Start DateRequired
Event Type
Assignee
Contact Time Zone
External ID
External Reschedule Link
Exclude From Integration
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Team Member IDRequired
Start DateRequired
End DateRequired
Event TypeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appEvent ID
External ID
Project ID
Start Date
[FILTER] Event Type
[FILTER] Assignee
ActionThis is an event a Zap performs.SearchFind existing data in your appProject ID
Project External ID
Main Contact ID
Address Line 1
Address Line 2
City
State
Zip Code
[FILTER] Project Stage
[FILTER] Project Status
ActionThis is an event a Zap performs.SearchFind existing data in your appContact ID
Phone
Email
Address Line 1
Address Line 2
City
State
Zip Code
First Name
Last Name
Organization
Contact Type
Lead Source
Contact Tags
Notes
Campaign
Assignee
External ID
Custom Field 1
Custom Field 2
Custom Field 3
Custom Date 1
Custom Date 2
Custom Date 3
Time Zone
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundProject | Edit by Project ID
Project External ID
Contact | Contact ID
Project | Address Line 1
Project | Address Line 2
Project | City
Project | State
Project | Zip
Project | Move to Stage
[FILTER] Project Status
Project | Edit by External ID
Project | Edit by Contact
Project | Name
Project | Location
Project | Area
Project | Main Assignee
Project | Inside Sales Assignee
Project | Production Assignee
Project | Accounting Assignee
Project | Start Campaign
Project | Category
Project | Type
Project | Services
Project | Tags
Project | Custom Field 1
Project | Custom Field 2
Project | Custom Field 3
Project | Custom Field 4
Project | Custom Field 5
Project | Custom Field 6
Project | Custom Field 7
Project | Notes
Project | New External ID
Contact | First Name
Contact | Last Name
Contact | Full Name
Contact | Phone
Contact | Email
Contact | Type
Contact | Lead Source
Contact | Tags
Event | Edit by External ID
Event | New External ID
Event | Start Date
Event | Event Type
Event | Time Zone
Event | External Reschedule Link
Event | Exclude From Integration
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
Related categories
Related Zap Templates
- Manage new or updated rows in Google Sheets to create or update projects in ProLine
- Create spreadsheet rows in Google Sheets for new trigger steps in ProLine
- Manage new and updated ProLine events by creating rows in Google Sheets
- Update Google Sheets rows with newly created or updated contacts from ProLine
- Create and update rows in Google Sheets when new or updated contacts are added in ProLine
- Create spreadsheet rows in Google Sheets for every completed payment in ProLine
- Create new Google Sheets rows for each ProLine trigger step occurrence
- "track ProLine trigger steps with new rows in Google Sheets"
- Create Google Sheets rows for newly approved or sent quotes in ProLine
- Create or update projects in ProLine and add corresponding rows in Google Sheets
Related Zap Templates
- Manage new or updated rows in Google Sheets to create or update projects in ProLine
- Update Google Sheets rows with newly created or updated contacts from ProLine
- Create new Google Sheets rows for each ProLine trigger step occurrence
- Create or update projects in ProLine and add corresponding rows in Google Sheets