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.
- When this happens...

New LeadTriggers when new lead is created.TriggerInstant - automatically do this!

Create Multiple Spreadsheet RowsCreate one or more new rows in a specific spreadsheet (with line item support).ActionWrite
- Free forever for core features
- 14 day trial for premium features & apps
More things you can do with essensys Operate and Google Sheets
Discover other triggers and actions you can use with essensys Operate and Google Sheets
New AccountTriggers when a new account is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New Calendar EventTriggers when a new calendar event is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New Charge SheetTriggers when a new charge sheet is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Update Charge SheetTriggers when a new charge sheet is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Deleted ContactTriggers when a contact is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New LeadTriggers when new lead is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New LicenceTriggers when a new licence is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New ProductTriggers 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 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 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
- 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 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
- 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 AccountTriggers when an account is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Deleted Calendar EventTriggers when a Calendar Event is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Delete Charge SheetTriggers when a new charge sheet is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New ContactTriggers when a new contact is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated ContactTriggers when a contact is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated LeadTriggers when new lead is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New OpportunityTriggers 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 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 plan- 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
- Row count
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
- 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





