CRM in Cloud + Google Sheets
Create or update CRM in Cloud companies from new or updated Google Sheets rows
Keep your CRM in Cloud data up to date with this practical, time-saving workflow. As soon as there’s a new or updated row in your Google Sheets, the corresponding company information in CRM in Cloud is created or updated swiftly. This automation ensures that every essential detail in your spreadsheets directly and immediately reflects in your CRM, keeping your records not just organized but also timely and error-free. Stay on top of business by streamlining your data management with this seamless integrated solution.
Keep your CRM in Cloud data up to date with this practical, time-saving workflow. As soon as there’s a new or updated row in your Google Sheets, the corresponding company information in CRM in Cloud is created or updated swiftly. This automation ensures that every essential detail in your spreadsheets directly and immediately reflects in your CRM, keeping your records not just organized but also timely and error-free. Stay on top of business by streamlining your data management with this seamless integrated solution.
- When this happens...
New or Updated Spreadsheet RowTriggers when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create or Update CompanyCreates a new Company, or update an exising one specifying its ID field value.
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 foundThe unique id of the Activity
Subject
Company
Contact
Lead
Accompanied by
All day
Classification
Close Date
Commercial agent
Control Type
Description
Document Path
Done/To do/Cancelled (Enum property)
Elapsed time
End date
External Reference
Fixed Charge
Have Cost
If TRUE adds the current CrossId to a new list on the current campaign
If TRUE sets the linked opporunity's campaign id to the current campaign id
Incoming
Internal note
Is Auto Change Ticket Status On First Activity
Job Price
Km
Lock slots
Opportunity
Order
Order Date
Others
Owner Id
Owner Id Friendly Name
Owner Id User Account
Previous activity
Price Km
Priority (Enum property)
Protocol
Quote
Recall End Hour
Source (Enum property)
Start date
Status (Enum property)
Subject code
tags (CSV list with ";" separator)
Technical
To invoice
Travel Price
Trip
Type under activities
Types (Enum property)
Update Appointment
Various Price
Visible in Portal
Work
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company Unique Id
Company name
Natural person
Surname
Name
Address
Anagraphic Company Type Id
Anagraphic Company Type Id Description
Anagraphic Industry Id
Anagraphic Industry Id Description
Area
Area
Bank
Carrier
Categories (CSV list with ";" separator)
City
Code
Code
Commercial agent (CSV list with ";" separator)
Company description
Country
Currency
Customer discount
Customer from
Default pricelist
Default pricelist
Do not contact
Email Certified Others
Email Certified Primary
Email Group Others
Email Group Primary
Email Invoice Others
Email Invoice Primary
Email Mailing List Others
Email Mailing List Primary
Email Others
Email Primary
Email Ticket Others
Email Ticket Primary
Employees
External Reference
From Lead
IBAN
Indicate if Anagraphic is soft deleted
Language
Last Activity
Last contact date
Mailing list consent
Next contact date
Owner Id
Owner Id Friendly Name
Owner Id User Account
Payment condition
Phone Assistant Others
Phone Assistant Primary
Phone Fax Others
Phone Fax Primary
Phone Mobile Phone 2 Others
Phone Mobile Phone 2 Primary
Phone Mobile Phone Others
Phone Mobile Phone Primary
Phone Others
Phone Phone 2 Others
Phone Phone 2 Primary
Phone Primary
Rating
Region
Revenue class
Score
Skip Create Sub Address
Source
Source Description
State/Province
Sync Properties
tags (CSV list with ";" separator)
Tax code
the object lock reason
The paymentCode for the company
the photo of the contact
Transport (Enum property)
VAT number
Website
Withholding tax
Zip code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.The Unique id
Name
Surname
Company
Address
Anagraphic Industry Id Description
Area
Area
Birthdate
Birthplace
Brought to attention by
Business roles (CSV list with ";" separator)
Campaign
Categories (CSV list with ";" separator)
City
Closing date
Code
Commercial agent (CSV list with ";" separator)
Conversion Date
Country
Currency
Customer from
Do not contact
Email Certified Others
Email Certified Primary
Email Group Others
Email Group Primary
Email Invoice Others
Email Invoice Primary
Email Mailing List Others
Email Mailing List Primary
Email Others
Email Primary
Email Ticket Others
Email Ticket Primary
Expected revenue
External Reference
Indicate if Anagraphic is soft deleted
Job title
Language
Last Activity
Last contact date
Mailing list consent
Next contact date
Notes
Owner Id
Owner Id Friendly Name
Owner Id User Account
Phase expiration date
Phone Assistant Others
Phone Assistant Primary
Phone Fax Others
Phone Fax Primary
Phone Mobile Phone 2 Others
Phone Mobile Phone 2 Primary
Phone Mobile Phone Others
Phone Mobile Phone Primary
Phone Others
Phone Phone 2 Others
Phone Phone 2 Primary
Phone Primary
Priority
Priority Description
Product Interest
Product Interest Description
Rating
Rating Description
Region
Related company
Related contact
Source
Source Description
State/Province
Status
Status Description
Sync Mobile
Sync Properties
tags (CSV list with ";" separator)
Tax code
the object lock reason
the photo of the contact
Title
VAT number
Website
Zip code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.The unique id of the Quote
Quote subject
Date
Quote number
Requested by
Amount (currency)
Approval User Note
Area manager
Billing address
Brought to attention by
Carrier
Collection charges (currency)
Collection charges (including VAT)
Commercial agent
Cross Name
Currency
Customer Changed
Customer reference
Date of last stage change
Delivery
Delivery date
Document Guid
Driver
Exchange rate
Exclude Approval Validation
Expedition VAT (type)
External Reference
Freight
if include pdf documents in the quote print
Invoice type (Enum property)
Is Copy
Language
Notes
only Company, Contact, or Lead (Enum property)
Opportunity
Our reference
Owner Id
Owner Id Friendly Name
Owner Id User Account
Package appearance
Payment
Payment amount (currency)
Payment amount (currency)
Payment method
Pricelist
Protocol number
Quote status (Enum property)
Referee person
Revision by:
Revision of quote number
Shipping address
Shipping charges (currency)
Shipping charges (including VAT)
Shipping TAX (value)
SplitPayment
Supporting bank
tags (CSV list with ";" separator)
Taxable amount
Taxable amount (currency)
the document name
The External PDF Document
the Partner
the reduction of the quote
the simble of the currency
the type of the quote
the type of the rows (all must be same) (Enum property)
Total
Total payment discount
Total payment discount
Unconditional discount
Use Progressive
Validity date
VAT amount
VAT amount (currency)
Vat Code for Document quotes
VAT collection costs (type)
VAT collection expenses (value)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.List IDRequired
Anagraphic TypeRequired
Anagraphic ID
Email type
Anagraphic email
Anagraphic name
ActionThis is an event a Zap performs.SearchFind existing data in your appFieldRequired
OperatorRequired
Filter valueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appFieldRequired
OperatorRequired
Filter valueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appFieldRequired
OperatorRequired
Filter valueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appFieldRequired
OperatorRequired
Filter valueRequired
The unique id of the Catalog
Product code
Product name
Active product
Availability
Barcode
Category
Cost
Customs code
Description
Editable price quote (Enum property)
Exclude List
External Reference
HTML Description
Maximum discount
Owner Id
Owner Id Friendly Name
Owner Id User Account
Print long description in quotes
Quantity
Quantity per box
Source place
Supplier
Supplier code
tags (CSV list with ";" separator)
the photo of the contact
The Volume of the product
Unit of measure
Unit price
Validity date
VAT
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFieldRequired
OperatorRequired
Filter valueRequired
The Unique id of the Contact
Name
Surname
Address
Area
Area
Assistant
Assistant phone
Birthdate
Birthplace
Business roles (CSV list with ";" separator)
Categories (CSV list with ";" separator)
City
Code
Commercial agent (CSV list with ";" separator)
Company
Contact Commercial Zone
Country
Customer from
Do not contact
Email Certified Others
Email Certified Primary
Email Group Others
Email Group Primary
Email Invoice Others
Email Invoice Primary
Email Mailing List Others
Email Mailing List Primary
Email Others
Email Primary
Email Ticket Others
Email Ticket Primary
External Reference
Gender (Enum property)
Global Or Personal
Indicate if Anagraphic is soft deleted
Job title
Language
Last contact date
Lead
Mailing list consent
Mobile phone 2
Next contact date
Notes
Owner Id
Owner Id Friendly Name
Owner Id User Account
Phone 2
Phone Assistant Others
Phone Assistant Primary
Phone Fax Others
Phone Fax Primary
Phone Mobile Phone 2 Others
Phone Mobile Phone 2 Primary
Phone Mobile Phone Others
Phone Mobile Phone Primary
Phone Others
Phone Phone 2 Others
Phone Phone 2 Primary
Phone Primary
Region
Skype
Source
Source Description
State/Province
Sync Mobile
Sync Properties
tags (CSV list with ";" separator)
Tax code
the object lock reason
the photo of the contact
Title
VAT number
Website
Zip code
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFieldRequired
OperatorRequired
Filter valueRequired
The unique id of the Opportunity
Name
Amount
Approval User Note
Category
Closing date
Code
Commercial agent (CSV list with ";" separator)
crossName
Customer
Description
External Reference
Goal
Has Default Data Loaded
If TRUE sets the linked activities campaign id to the current campaign id
If TRUE adds the current CrossId to a new list on the current campaign
Owner Id
Owner Id Friendly Name
Owner Id User Account
Phase
Phase expiration date
Probability (%)
Reason for closure
Status (Enum property)
tags (CSV list with ";" separator)
The type of anagraphic on the opportunity (Enum property)
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 foundList IDRequired
Anagraphic TypeRequired
Email typeRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planThe unique id of the Catalog
Product code
Product name
Active product
Availability
Barcode
Category
Cost
Customs code
Description
Editable price quote (Enum property)
Exclude List
External Reference
HTML Description
Maximum discount
Owner Id
Owner Id Friendly Name
Owner Id User Account
Print long description in quotes
Quantity
Quantity per box
Source place
Supplier
Supplier code
tags (CSV list with ";" separator)
the photo of the contact
The Volume of the product
Unit of measure
Unit price
Validity date
VAT
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.The Unique id of the Contact
Name
Surname
Address
Area
Area
Assistant
Assistant phone
Birthdate
Birthplace
Business roles (CSV list with ";" separator)
Categories (CSV list with ";" separator)
City
Code
Commercial agent (CSV list with ";" separator)
Company
Contact Commercial Zone
Country
Customer from
Do not contact
Email Certified Others
Email Certified Primary
Email Group Others
Email Group Primary
Email Invoice Others
Email Invoice Primary
Email Mailing List Others
Email Mailing List Primary
Email Others
Email Primary
Email Ticket Others
Email Ticket Primary
External Reference
Gender (Enum property)
Global Or Personal
Indicate if Anagraphic is soft deleted
Job title
Language
Last contact date
Lead
Mailing list consent
Mobile phone 2
Next contact date
Notes
Owner Id
Owner Id Friendly Name
Owner Id User Account
Phone 2
Phone Assistant Others
Phone Assistant Primary
Phone Fax Others
Phone Fax Primary
Phone Mobile Phone 2 Others
Phone Mobile Phone 2 Primary
Phone Mobile Phone Others
Phone Mobile Phone Primary
Phone Others
Phone Phone 2 Others
Phone Phone 2 Primary
Phone Primary
Region
Skype
Source
Source Description
State/Province
Sync Mobile
Sync Properties
tags (CSV list with ";" separator)
Tax code
the object lock reason
the photo of the contact
Title
VAT number
Website
Zip code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.The unique id of the Opportunity
Name
Amount
Approval User Note
Category
Closing date
Code
Commercial agent (CSV list with ";" separator)
crossName
Customer
Description
External Reference
Goal
Has Default Data Loaded
If TRUE sets the linked activities campaign id to the current campaign id
If TRUE adds the current CrossId to a new list on the current campaign
Owner Id
Owner Id Friendly Name
Owner Id User Account
Phase
Phase expiration date
Probability (%)
Reason for closure
Status (Enum property)
tags (CSV list with ";" separator)
The type of anagraphic on the opportunity (Enum property)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FieldRequired
OperatorRequired
Filter valueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appFieldRequired
OperatorRequired
Filter valueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appFieldRequired
OperatorRequired
Filter valueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appFieldRequired
OperatorRequired
Filter valueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appFieldRequired
OperatorRequired
Filter valueRequired
The unique id of the Activity
Subject
Company
Contact
Lead
Accompanied by
All day
Classification
Close Date
Commercial agent
Control Type
Description
Document Path
Done/To do/Cancelled (Enum property)
Elapsed time
End date
External Reference
Fixed Charge
Have Cost
If TRUE adds the current CrossId to a new list on the current campaign
If TRUE sets the linked opporunity's campaign id to the current campaign id
Incoming
Internal note
Is Auto Change Ticket Status On First Activity
Job Price
Km
Lock slots
Opportunity
Order
Order Date
Others
Owner Id
Owner Id Friendly Name
Owner Id User Account
Previous activity
Price Km
Priority (Enum property)
Protocol
Quote
Recall End Hour
Source (Enum property)
Start date
Status (Enum property)
Subject code
tags (CSV list with ";" separator)
Technical
To invoice
Travel Price
Trip
Type under activities
Types (Enum property)
Update Appointment
Various Price
Visible in Portal
Work
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFieldRequired
OperatorRequired
Filter valueRequired
Company Unique Id
Company name
Natural person
Surname
Name
Address
Anagraphic Company Type Id
Anagraphic Company Type Id Description
Anagraphic Industry Id
Anagraphic Industry Id Description
Area
Area
Bank
Carrier
Categories (CSV list with ";" separator)
City
Code
Code
Commercial agent (CSV list with ";" separator)
Company description
Country
Currency
Customer discount
Customer from
Default pricelist
Default pricelist
Do not contact
Email Certified Others
Email Certified Primary
Email Group Others
Email Group Primary
Email Invoice Others
Email Invoice Primary
Email Mailing List Others
Email Mailing List Primary
Email Others
Email Primary
Email Ticket Others
Email Ticket Primary
Employees
External Reference
From Lead
IBAN
Indicate if Anagraphic is soft deleted
Language
Last Activity
Last contact date
Mailing list consent
Next contact date
Owner Id
Owner Id Friendly Name
Owner Id User Account
Payment condition
Phone Assistant Others
Phone Assistant Primary
Phone Fax Others
Phone Fax Primary
Phone Mobile Phone 2 Others
Phone Mobile Phone 2 Primary
Phone Mobile Phone Others
Phone Mobile Phone Primary
Phone Others
Phone Phone 2 Others
Phone Phone 2 Primary
Phone Primary
Rating
Region
Revenue class
Score
Skip Create Sub Address
Source
Source Description
State/Province
Sync Properties
tags (CSV list with ";" separator)
Tax code
the object lock reason
The paymentCode for the company
the photo of the contact
Transport (Enum property)
VAT number
Website
Withholding tax
Zip code
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFieldRequired
OperatorRequired
Filter valueRequired
The Unique id
Name
Surname
Company
Address
Anagraphic Industry Id Description
Area
Area
Birthdate
Birthplace
Brought to attention by
Business roles (CSV list with ";" separator)
Campaign
Categories (CSV list with ";" separator)
City
Closing date
Code
Commercial agent (CSV list with ";" separator)
Conversion Date
Country
Currency
Customer from
Do not contact
Email Certified Others
Email Certified Primary
Email Group Others
Email Group Primary
Email Invoice Others
Email Invoice Primary
Email Mailing List Others
Email Mailing List Primary
Email Others
Email Primary
Email Ticket Others
Email Ticket Primary
Expected revenue
External Reference
Indicate if Anagraphic is soft deleted
Job title
Language
Last Activity
Last contact date
Mailing list consent
Next contact date
Notes
Owner Id
Owner Id Friendly Name
Owner Id User Account
Phase expiration date
Phone Assistant Others
Phone Assistant Primary
Phone Fax Others
Phone Fax Primary
Phone Mobile Phone 2 Others
Phone Mobile Phone 2 Primary
Phone Mobile Phone Others
Phone Mobile Phone Primary
Phone Others
Phone Phone 2 Others
Phone Phone 2 Primary
Phone Primary
Priority
Priority Description
Product Interest
Product Interest Description
Rating
Rating Description
Region
Related company
Related contact
Source
Source Description
State/Province
Status
Status Description
Sync Mobile
Sync Properties
tags (CSV list with ";" separator)
Tax code
the object lock reason
the photo of the contact
Title
VAT number
Website
Zip code
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFieldRequired
OperatorRequired
Filter valueRequired
The unique id of the Quote
Quote subject
Date
Quote number
Requested by
Amount (currency)
Approval User Note
Area manager
Billing address
Brought to attention by
Carrier
Collection charges (currency)
Collection charges (including VAT)
Commercial agent
Cross Name
Currency
Customer Changed
Customer reference
Date of last stage change
Delivery
Delivery date
Document Guid
Driver
Exchange rate
Exclude Approval Validation
Expedition VAT (type)
External Reference
Freight
if include pdf documents in the quote print
Invoice type (Enum property)
Is Copy
Language
Notes
only Company, Contact, or Lead (Enum property)
Opportunity
Our reference
Owner Id
Owner Id Friendly Name
Owner Id User Account
Package appearance
Payment
Payment amount (currency)
Payment amount (currency)
Payment method
Pricelist
Protocol number
Quote status (Enum property)
Referee person
Revision by:
Revision of quote number
Shipping address
Shipping charges (currency)
Shipping charges (including VAT)
Shipping TAX (value)
SplitPayment
Supporting bank
tags (CSV list with ";" separator)
Taxable amount
Taxable amount (currency)
the document name
The External PDF Document
the Partner
the reduction of the quote
the simble of the currency
the type of the quote
the type of the rows (all must be same) (Enum property)
Total
Total payment discount
Total payment discount
Unconditional discount
Use Progressive
Validity date
VAT amount
VAT amount (currency)
Vat Code for Document quotes
VAT collection costs (type)
VAT collection expenses (value)
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 CRM in Cloud
Related categories
About Google Sheets
Related categories
Related Zap Templates
- Create or update CRM in Cloud leads from new Google Sheets rows
- Create or update CRM in Cloud leads from new or updated Google Sheets rows
- Create or update CRM in Cloud leads from new or updated Google Sheets spreadsheet rows
- Create or update CRM in Cloud quotes from new Google Sheets rows
- Create new rows in Google Sheets for newly updated companies in CRM in Cloud