How to connect Google Sheets + Gravity Forms + essensys Operate
Zapier lets you send info between Google Sheets and Gravity Forms and essensys Operate automatically—no code required. With 7,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with Google Sheets + Gravity Forms + essensys Operate
With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with Google Sheets, Gravity Forms, and essensys Operate. And don’t forget that you can add more apps and actions to create complex workflows.
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier 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.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
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
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFormRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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 app
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 ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
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
Headers
Overwrite existing worksheets
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
Text Bold
Text Italic
Text Strikethrough
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
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFormRequired
Use Admin Field Labels?
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.FormRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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 app
Top companies trust Zapier to automate work and free up time
Join millions worldwide who automate their work using Zapier
How Google Sheets + Gravity Forms + essensys Operate Integrations Work
- Step 1: Authenticate Google Sheets, Gravity Forms, and essensys Operate.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.
Related categories
Related categories
Related categories
Other Google Sheets + Gravity Forms Integrations
- google-drive
- webhook
- keap-max-classic
- salesforce
- sms
- pipedrive
- google-docs
- leadconnector
- google-calendar
- zoom
- sendinblue
- hubspot
- twilio
- constant-contact
- asana
- zoho-crm
- code
- trello
- google-contacts
- airtable
- excel
- microsoft-outlook
- campaign-monitor
- zendesk
- quickbooks
- klaviyo
- dropbox
- autopilot
- mysql
- clicksend
- mailerlite
- keap
- drip
- smtp
- storage
- simpletexting
- sendgrid
- ontraport
- monday
- intercom
- formstack-documents
- clickup
- streak
- sharpspring
- podio
- marketo
- klick-tipp
- gotowebinar
- google-analytics
- getresponse
- facebook-custom-audiences
- convertkit
- benchmarkone
- xero
- wordpress
- teamleader
- responder
- pardot
- copper
- closeio
- basecamp3
- agile-crm
- actionnetwork
- wrike
- woocommerce
- thinkific
- textmagic
- smoove
- shopify
- shipstation
- sendfox
- recruitee
- realvolve
- rd-station
- pushbullet
- postmark
- odoo
- microsoft-teams
- microsoft-dynamics-crm
- meistertask
- mautic
- marketvolt
- mailgun
- livestorm
- liondesk-crm
- kartra
- kajabi
- ip2location
- insightly
- google-cloud-print
- google-ads
- gist
- flodesk
- emailoctopus
- dotdigital
- dailyai-mortgage
- cloze
- capsulecrm
- activetrail
- act-premium
- todoist
- zoho-creator
- yalla-team
- xzazu
- wodify
- weather
- visma-eaccounting
- vcita
- transloadit
- textp2p
- sql-server
- spark-membership
- solve360
- smsapi
- smartsheet
- skipio
- signrequest
- service-fusion
- sendy
- salestrekker
- salesmate
- salesforceiq
- ryver
- remo-conference
- pushpress
- pushover
- process-street
- philips-hue
- openerp
- onedrive
- on24
- ohmylead
- office-365
- nocrm-io
- nimble
- msg91
- moskit
- moneybird
- mondaycom
- messagebird
- memberpress
- mandrill
- mailjet
- looping
- little-green-light
- learnworlds
- learndash
- leadsquared
- lead-information
- lawmatics
- knack
- kindful
- jobber
- jira
- iterable
- invoice-ninja
- investorfuse
- icontact
- highrise
- help-scout
- gymsales
- google-tasks
- google-groups
- google-chat
- google-bigquery
- glip
- freshdesk
- freedomsoft
- formstack
- follow-up-boss
- fleep
- firebase
- fattura24
- facebook-conversions
- etapestry
- esignaturesio
- emma
- docusign
- cyberimpact
- crmble
- coda
- burst-sms
- bubble
- bonjoro
- bombbombcom
- birdeye
- bexio
- benchmark-email
- aweber
- aloware
- adroll
- adestra
- acumbamail
- act-on
- abacus
- salesmsg
- zipwhip