Commusoft + Google Sheets
Track won Commusoft opportunities by creating new Google Sheets rows
This workflow activates when you secure an opportunity in Commusoft. It swiftly populates a new row in your Google Sheets spreadsheet with the pertinent details, saving you the effort of manual data entry. With this streamlined process, you can stay organized and focus on seizing more successful opportunities.
This workflow activates when you secure an opportunity in Commusoft. It swiftly populates a new row in your Google Sheets spreadsheet with the pertinent details, saving you the effort of manual data entry. With this streamlined process, you can stay organized and focus on seizing more successful opportunities.
- When this happens...
Opportunity WonTriggers when an opportunity is won.
TriggerInstantThis event starts a Zap instantly. - 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
New Customer
Triggers when a new customer is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Job Closed
Triggers when a job is closed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Contact
Triggers when a new contact is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Job
Triggers when a new job is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Proposal
Triggers when a new proposal is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Work Address
Triggers when a new work address is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Opportunity Cancelled
Triggers when an opportunity is cancelled.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Opportunity Won
Triggers when an opportunity is won.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Office Tasks
Triggers when a new tasks is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Customer TypeRequired
AddressLine1Required
Company Name
Company Landline
Company Email
Title
Email
Surname
Name
AddressLine2
AddressLine3
Town
County
Postcode
Landline
Mobile
Country code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Title
Name
Surname
Company Name
Addressline1Required
Addressline2
Addressline3
Postcode
Town
Country code
Mobile
Email
County
Landline
Customer IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record 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 found
New Diary
Triggers when new diary event created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Job Complete
Triggers when a job is completed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Invoice
Triggers when a new invoice is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Opportunity
Triggers when a new opportunity is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Scheduled Activity
Triggers when a new scheduled activity is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Opportunity Stage Changed
Triggers when an opportunity stage is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Opportunity Lost
Triggers when an opportunity is lost.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Proposal Sent
Triggers when a proposal is sent.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Opportunity templateRequired
SurnameRequired
Name
Addressline1Required
Customer Type
Town
Landline
Mobile
Postcode
Customer Email
Company Name
Company Email
Company Landline
Title
Country code
Opportunity notes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer TypeRequired
Addressline1Required
Job DescriptionRequired
County
Title
Customer Name
Company Name
Customer Surname
Addressline2
Addressline3
Town
Postcode
Customer Email
Landline
Mobile
Job Notes
Customer Reference
Priority
Quoted Aamount
Job Files
Country code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
About Commusoft
Related categories
About Google Sheets
Related categories
Related Zap Templates
- Create new Commusoft customers from new rows in Google Sheets
- Create new Commusoft jobs from new rows in Google Sheets
- Create new Commusoft opportunities from new Google Sheets rows
- Create spreadsheet rows in Google Sheets for new invoices from Commusoft
- Create new Google Sheets row for each new Commusoft contact
- Create spreadsheet rows in Google Sheets for new jobs in Commusoft
- Create spreadsheet rows in Google Sheets for new opportunities in Commusoft
- Create multiple rows in Google Sheets for new jobs in Commusoft
- Create spreadsheet rows in Google Sheets for new diaries in Commusoft
- Create spreadsheet rows in Google Sheets when new jobs are closed in Commusoft
- Automatically populate Google Sheets rows when new Commusoft jobs are completed
- Create spreadsheet rows in Google Sheets for new contacts in Commusoft