essensys Operate + Google Sheets
Create multiple rows in Google Sheets for each new lead in essensys Operate
Seamlessly transition new leads details from essensys Operate to Google Sheets. With this workflow, each new lead in essensys Operate results in the creation of multiple rows in your chosen Google Sheets document. This ensures efficient record-keeping, streamlines your marketing and sales processes, and eliminates the unnecessary hassle of manual data entry.
Seamlessly transition new leads details from essensys Operate to Google Sheets. With this workflow, each new lead in essensys Operate results in the creation of multiple rows in your chosen Google Sheets document. This ensures efficient record-keeping, streamlines your marketing and sales processes, and eliminates the unnecessary hassle of manual data entry.
- When this happens...
New LeadTriggers when new lead is created.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create Multiple Spreadsheet RowsCreate one or more new rows in a specific spreadsheet (with line item support).
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 Account
Triggers when a new account is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Calendar Event
Triggers when a new calendar event is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Charge Sheet
Triggers when a new charge sheet is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Update Charge Sheet
Triggers when a new charge sheet is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Deleted Contact
Triggers when a contact is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Lead
Triggers when new lead is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Licence
Triggers when a new licence is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Product
Triggers when a new product is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.TaxRequired
ProductRequired
Account NameRequired
Date FromRequired
QuantityRequired
Date ToRequired
Unit PriceRequired
Reference Text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Lead NameRequired
web Channel
Primary Source
Secondary Source (New)
Secondary Source
Lead Channel
EmailRequired
Location
Broker
Broker Contact
User
Region
Lead Type
Lead Source
Industry
Dead Reason
Client Type
Broker Updated
Check to Receive Marketing Up
Lead Converted
Multi Day Booking
LeadDADI Lead
Tour Arranged
Tour Reminder Sent
Tour Requested
Web to Lead
Lead Converted Date
Dead Date
Enquiry Date
Event End Date
Event Start Date
Second Event End Date
Second Event Start Date
Agent Email
Agent Reference
Lead Status
Budget
County
Event Name
Fax No
Floor
I Am Interested In
Lead Status Id
Location Required
Mobile No
No of Attendees
Number of People
2 of Your Favourite Pastimes
Postcode
Quality of Space
Registered Address Country
Registered Address County
Registered Address Line 1
Registered Address Line 2
Registered Address Line 3
Registered Address Postcode
Registered Address Town
Size
Space Type
Phone No
Term
Test Lead WF
Time Line
Timing
Town
Website
Win Chance
Comments
Start Date
Last Name
First Name
Country
Address Line 1
Address Line 2
Campaign
Address Line 3
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LocationRequired
TaxRequired
Product GroupRequired
Product NameRequired
Unit PriceRequired
Available AtRequired
Start DateRequired
Cost TypeRequired
Location Name
Catering
Created By
Actual Workstations
Creation Date
Currency Occupier
Current Price
Facility
Markup Type
Office and Occupier
Product Group Name
Show in Calendar
Tax Rate
Update Date
Updated By
Frequency
Retainer Tax
Retainer Product
Record Type
Office Type
Office Status
Meeting Room Type
Allow Zero Invoice
Mandatory Square Foot Calculated
Allow Zero Price on Invoices
Can Book on Website
Mandatory to Virtual Clients
Clearance Time
Cost Centre
Department Number
Description
Desk
Discontinued
Hide From Invoices
End Date
Extract Cost From Call Logger
Floor
Revacc No
Discrevacc No
Defacc No
Gove Code
Hide From Point of Sale
Dedube Imported Products
Include Reservation Discounts
Included in Commissions
Item ID
Published
Mandatory Charge
Markup
Meeting Room
Metered Charge
Minimum Price
Number of People
Notes
Time Based Plan Hours
Office
Office Size
Online Alias
Mandatory Charge Percent of All
Mandatory Percent of Rent
Ports
Pricing Day Ext
Pricing Day Highest Qualifier
Pricing Day Int
Pricing Day Lowest Qualifier
Pricing Day Mins
Pricing Half Day Ext
Pricing Half Day Highest Qual
Pricing Half Day Int
Pricing Half Day Lowest Qual
Pricing Half Day Mins
Pricing Hourly Ext
Pricing Hourly Highest Qualifier
Pricing Hourly Int
Pricing Hourly Lowest Qual
Pricing Hourly Mins
Can Be Bundled
Product Cannot Be Discounted
Product Cost
Quality of Space
Service
Reference Text
Retainer
Service Charge Item
SMS Item
Time Based Plan
Can Edit Mandatory Charge
Virtual Service
Withholding Tax
Workstations
Complimentary Items
Mandatory Charge Type
Related Space
Styles
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
Optout
First Name
Last Name
Mobile Phone
Owner
Account
Date of Birth
Would Most Like
Community Status
Portal Access Level
Community Profile Active
News Letter
Company Profile Active
Receive Shout Out Emails
Receive Status Update Emails
Assistants Name
Car Reg No
Company Logo
Department
Dis Likes Tags
Expertise Tags
Ext
Facebook Account
Fax No
Flickr Account
Private Phone No
Contact Image
Important Note
Instagram Account
Interesting Facts
Job Function
Likes Tags
Linkedin Account
Managers Name
Pinterest Account
Salutation
Social Tags
Phone No
Twitter Account
Social Websites
What Do I Do
What I Care About
Contact Type
Email
Title
Lead Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
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
Updated Account
Triggers when an account is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Deleted Calendar Event
Triggers when a Calendar Event is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Delete Charge Sheet
Triggers when a new charge sheet is deleted.
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.Updated Contact
Triggers when a contact is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Lead
Triggers when new lead is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Opportunity
Triggers when new opportunity is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Account NameRequired
Account TypeRequired
End Date
Start DateRequired
web Channel
Primary Source
Secondary Source
Client TypeRequired
Broker
Broker Contact
User
Payment Type
Rental Payment Type
Standard Payment Term
Rental Payment Term
Meeting Package
Location
Lead Source
Industry
Group Account
Campaign
Agent Type
Addressline1
Addressline2
Addressline3
Country
County
Email
Postcode
Mobile No
Sic Code
City
Website
VAT No
Phone No
Charge VAT
Email Invoice
Include BFWD
Show Call Details
Include Itemised Bill
Include Statement
LeadDADI Agent
On Account
Online Bill
Print Invoice
Account Alias
Accounts Code
Bank Account Name
Bank Account Number
Bank Code
Bill Day
Agent Email
Agent Reference
Call Logger Code
Company No
Contact
Copier Code
Credit Limit
DD Reference
Ddi
Department Number
Door Number
Fax Number
First Name
Forward Address Country
Forward Address County
Forward Address Fax
Forward Address First Name
Forward Address Last Name
Forward Address Line 1
Forward Address Line 2
Forward Address Line 3
Forward Address Post Code
Forward Address Telephone
Forward Address Town
Free Text
Invoice BCC Address
Invoice Cc Address
Invoice Email Address
Last Name
Bank Name
Shopper Reference
Override Discount (%)
Payment Token
Registered Address Country
Registered Address County
Registered Address Line 1
Registered Address Line 2
Registered Address Line 3
Registered Address Post Code
Registered Telephone
Registered Address Town
Registered Fax
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First NameRequired
Last NameRequired
Mobile PhoneRequired
Owner
Account
Optout
Date of Birth
Would Most Like
Community Status
Portal Access Level
Community Profile Active
News Letter
Company Profile Active
Receive Shout Out Emails
Receive Status Update Emails
Assistants Name
Car Reg No
Company Logo
Department
Dis Likes Tags
Expertise Tags
Ext
Facebook Account
Fax No
Flickr Account
Private Phone No
Contact Image
Important Note
Instagram Account
Interesting Facts
Job Function
Likes Tags
Linkedin Account
Managers Name
Pinterest Account
Salutation
Social Tags
Phone No
Twitter Account
Social Websites
What Do I Do
What I Care About
Contact Type
Email
Title
Lead Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
HubSpot Deal ID
Lead SourceRequired
Close DateRequired
LocationRequired
AccountRequired
Contact NameRequired
StageRequired
Salesperson
Client Type
Broker
Broker Contact
Overturned Broker
Overturned Broker Contact
User
Region
Lost Reason
Opportunity Type
Lead Type
Campaign
Contract Type
Agreement Signed
Broker Updated
Forecast
LeadDADI Lead
Tour Arranged
Viewed
Web to Lead
Won
Won Notification Sent
Check in Date
Lost Date
Dead Date
End Date
Enquiry Date
Start Date
Amount
Agent Fee
Agent Email
Agent Reference
Broker Status
Budget
Term Months
Expansion Value
Favorite Food
Location Required
Other Needs
Overturned Agent Email
Overturned Agent Reference
Parking Spaces
Rate
Size
Term Days
Test Opp Wf
Timing
Workstations
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.StatusRequired
PriorityRequired
SubjectRequired
Account NameRequired
LocationRequired
ContactRequired
Start Date/TimeRequired
TypeRequired
Assigned To
Record Type
Opportunity Name
Lead Name
Comments
Created By
Creation Date
Due Date/Time
Email Address
End Date
End Date Time
End Time
Is Lead
Mobile/Cell
Related To
Reminder
Reminder Minutes
Send Confirmation
Send to Outlook
Start Date
Start Time
Uid
Update Date
Updated By
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
Name
Lead Source
Close Date
Location
Account
Contact Name
Stage
Salesperson
Client Type
Broker
Broker Contact
Overturned Broker
Overturned Broker Contact
User
Region
Lost Reason
Opportunity Type
Lead Type
Campaign
Contract Type
Agreement Signed
Broker Updated
Forecast
LeadDADI Lead
Tour Arranged
Viewed
Web to Lead
Won
Won Notification Sent
Check in Date
Lost Date
Dead Date
End Date
Enquiry Date
Start Date
Amount
Agent Fee
Agent Email
Agent Reference
Broker Status
Budget
Term Months
Expansion Value
Favorite Food
Location Required
Other Needs
Overturned Agent Email
Overturned Agent Reference
Parking Spaces
Rate
Size
Term Days
Test Opp Wf
Timing
Workstations
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email
Opportunity ID
ActionThis is an event a Zap performs.SearchFind existing data in your appNo 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 found
About essensys Operate
Related categories
