Add Google Sheets rows for new ConstructionOnline leads
Keep a spreadsheet record of incoming leads without entering the same information twice. Whenever a new lead is created in ConstructionOnline, this integration automatically adds a row to your selected Google Sheets worksheet using the lead’s information.
- When this happens...

Lead CreatedTriggers when a new lead is created.TriggerInstant - automatically do this!

Create Spreadsheet RowCreate a new row in a specific spreadsheet.ActionWrite
- Free forever for core features
- 14 day trial for premium features & apps
More things you can do with ConstructionOnline and Google Sheets
Discover other triggers and actions you can use with ConstructionOnline and Google Sheets
- Time Before
- Time Before (Unit)
- Which Events to Include
- Event Type
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Contact Assigned to Key RoleTriggers when a contact is assigned to a key role on a project.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Contact UpdatedTriggers when a contact is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Daily Log UpdatedTriggers when a daily log is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Lead UpdatedTriggers when a lead is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Opportunity CreatedTriggers when a new opportunity is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Project CreatedTriggers when a new project is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
To-Do CompletedTriggers when a to-do is completed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Include To-Do Subtasks?
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- SubjectRequired
- Calendar TypeRequired
- Start DateRequired
- End DateRequired
- All Day Event
- Event Type
- Trade
- Cost Impact TBD
- Notes
- Assigned Resources
- Related Resources
- Is Private?
- Is Complete?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- TypeRequired
- First NameRequired
- Last NameRequired
- Display NameRequired
- Company
- EmailRequired
- Contact Group
- Trade
- Contact Category
- Office
- Division
- Region
- Quality
- Phone
- Mobile
- Mobile Provider
- Fax
- Website
- Address
- City
- State / Province
- ZIP / Postal Code
- CountryRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- ProjectRequired
- Entry DateRequired
- Log TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Opportunity NameRequired
- Project Number
- Project Type
- Project Group
- Project Stage
- Project Category
- Project Office
- Project Division
- Project Region
- Project Tags
- Color
- Primary Client
- Address
- City
- State / Province
- ZIP / Postal Code
- CountryRequired
- Latitude
- Longitude
- Currency
- Use Currency Code
- Related Leads
- Opportunity Status
- Opportunity Stage
- Opportunity Type
- Opportunity Source
- Opportunity Sales Representative
- Opportunity Estimator
- Opportunity Referrer
- Opportunity Value
- Opportunity Probability
- Opportunity Quality
- Opportunity Opened Date
- Opportunity Bid Due Date
- Opportunity Bid Submitted Date
- Opportunity Last Contact Date
- Opportunity Next Callback Date
- Opportunity Closed Date
- Opportunity Number
- Project Notes
- Scope of Work
- Cost Code Set
- Key Role
- Key Role Contact
- Key Role: Show in ClientLink
- Key Role: Show in TeamLink
- Project Status
- Traffic Light Color
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Start TimeRequired
- End TimeRequired
- Project
- Employee Note
- Admin Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Employee Note
- Fail If Not Clocked In
- Resume Shift First If On Break or Lunch
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Fail If Not Clocked In
- Resume Shift First If On Break or Lunch
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Project
- Employee Note
- Admin Note
- Fail If Already Clocked In
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Email
- Phone
ActionThis is an event a Zap performs.SearchFind existing data in your app- Email
ActionThis is an event a Zap performs.SearchFind existing data in your app- Subject
- Subject Exact Match
- Project
- Starts On Or After
- Starts Before
ActionThis is an event a Zap performs.SearchFind existing data in your app- Subject
- Subject Exact Match
- Project
- Custom Calendar
- Calendar Type
- Event Type
- All Day Events Only
- Starts On Or After
- Starts Before
- Ends On Or After
- Ends Before
- SubjectRequired
- Calendar TypeRequired
- Start DateRequired
- End DateRequired
- All Day Event
- Event Type
- Trade
- Cost Impact TBD
- Notes
- Assigned Resources
- Related Resources
- Is Private?
- Is Complete?
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- Subject Contains
- Project
- Recipient
- Is Unread
- Is Archived
- Is Draft
- SubjectRequired
- MessageRequired
- Append Signature
- ToRequired
- CC
- BCC
- Project
- Save as Draft
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- Subject
- Subject Exact Match
- Project
- Assigned Resource
- Parent To-Do
- Company To-Dos Only
- Completed
- Due On Or After
- Due Before
- SubjectRequired
- Description
- Project
- Due Date
- Priority
- Assigned Resources
- Related Resources
- Trade
- Type
- Category
- Stage
- Tags
- Traffic Light
- Cost Impact
- Percent Complete
- Completed Date
- Is Private?
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- 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 plan- Dont_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
- Overwrite All Columns
- 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.- Api_docs_info
- 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
- Spreadsheet NameRequired
- Search Type
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row IDRequired
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
- Row count
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- 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
- Time Before
- Time Before (Unit)
- Which Events to Include
- Event Type
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Comment CreatedTriggers when a new comment is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Contact CreatedTriggers when a new contact is created in your company.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Daily Log CreatedTriggers when a new daily log is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Lead CreatedTriggers when a new lead is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Opportunity UpdatedTriggers when an opportunity is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Project UpdatedTriggers when a project is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Include To-Do Subtasks?
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Item TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Object TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- SubjectRequired
- MessageRequired
- Append Signature
- ToRequired
- CC
- BCC
- Project
- Save as Draft
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- First NameRequired
- Middle Name
- Last NameRequired
- Company
- EmailRequired
- Contact Group
- Contact Category
- Office
- Division
- Region
- Phone
- Mobile Phone
- Mobile Provider
- Fax
- Website
- Address
- City
- State / Province
- Zip / Postal Code
- CountryRequired
- Lead StatusRequired
- Lead Stage
- Lead Source
- Lead Type
- Lead Sales Representative
- Lead ProbabilityRequired
- Lead Value
- Lead Opened Date
- Lead Closed Date
- Lead Quality
- Lead Tags
- Lead Details
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- ConversationRequired
- MessageRequired
- Append Signature
- Save as Draft
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- SubjectRequired
- Description
- Project
- Due Date
- Priority
- Assigned Resources
- Related Resources
- Trade
- Type
- Category
- Stage
- Tags
- Traffic Light
- Cost Impact
- Percent Complete
- Completed Date
- Is Private?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Fail If Not On Break or Lunch
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Fail If Not Clocked In
- Resume Shift First If On Break or Lunch
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Subject
- Subject Exact Match
- Project
- Custom Calendar
- Calendar Type
- Event Type
- All Day Events Only
- Starts On Or After
- Starts Before
- Ends On Or After
- Ends Before
ActionThis is an event a Zap performs.SearchFind existing data in your app- Subject Contains
- Project
- Recipient
- Is Unread
- Is Archived
- Is Draft
ActionThis is an event a Zap performs.SearchFind existing data in your app- Name
- Name Exact Match
- Number
- Number Exact Match
- Include Archived
ActionThis is an event a Zap performs.SearchFind existing data in your app- Subject
- Subject Exact Match
- Project
- Assigned Resource
- Parent To-Do
- Company To-Dos Only
- Completed
- Due On Or After
- Due Before
ActionThis is an event a Zap performs.SearchFind existing data in your app- Email
- Phone
- TypeRequired
- First NameRequired
- Last NameRequired
- Display NameRequired
- Company
- EmailRequired
- Contact Group
- Trade
- Contact Category
- Office
- Division
- Region
- Quality
- Phone
- Mobile
- Mobile Provider
- Fax
- Website
- Address
- City
- State / Province
- ZIP / Postal Code
- CountryRequired
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- Email
- First NameRequired
- Middle Name
- Last NameRequired
- Company
- EmailRequired
- Contact Group
- Contact Category
- Office
- Division
- Region
- Phone
- Mobile Phone
- Mobile Provider
- Fax
- Website
- Address
- City
- State / Province
- Zip / Postal Code
- CountryRequired
- Lead StatusRequired
- Lead Stage
- Lead Source
- Lead Type
- Lead Sales Representative
- Lead ProbabilityRequired
- Lead Value
- Lead Opened Date
- Lead Closed Date
- Lead Quality
- Lead Tags
- Lead Details
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- 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 plan- Dont_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
- 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
- First row
- Row count
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
ActionThis is an event a Zap performs.SearchFind existing data in your app- Spreadsheet IDRequired
- Include Grid Data
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- Spreadsheet NameRequired
- Search Type
- Spreadsheet to Copy
- 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- 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.Search or writeFind existing data in your app, or create a new record if no data is found




