How to connect Google Sheets + Gravity Forms + Keap
Zapier lets you send info between Google Sheets and Gravity Forms and Keap automatically—no code required. With 8,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 + Keap
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 Keap. And don’t forget that you can add more apps and actions to create complex workflows.
- 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 
 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
- FormRequired 
- 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.
 - New Affiliate- For Ulimate users, triggers when a new affiliate is added. Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
- Company events this trigger will listen to:Required 
 Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
- Invoice events this trigger will listen to:Required 
 Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
- Opportunity events this trigger will listen to:Required 
- RandomRequired 
 Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
- Subscription events this trigger will listen to:Required 
 Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
- Tag events this trigger will listen to:Required 
- Tag (for use with "Tag Applied to Contact" event only) 
 Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
 - New Credit Card Charge - Merchant Only- Triggers when a new credit card charge is made. (Merchant Only). Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
 - New Manual Payment – (Cash, Check)- Triggers when a New Manual Payment is added. (Cash or Check). Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
- Contact Tag Sync Interval 
- Tag 
 Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
 - New Refund- Triggers when a new refund is created. Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
 - Opportunity Stage Moved- Triggers when an opportunity stage is moved. Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
- Company NameRequired 
- Country Code (e.g., "USA") 
- Address Line 1 
- Address Line 2 
- Locality 
- Region (e.g., "US-CA") 
- Zip Code 
- Zip Four 
- Phone Number 
- Phone Ext 
- Notes 
- Email Address 
- Fax Number 
- Website 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Contact IdRequired 
- BodyRequired 
- Title 
- Type 
- User Id 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Invoice IDRequired 
- Product 
- Product QuanityRequired 
- Price Override 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- UserRequired 
- ContactsRequired 
- SubjectRequired 
- HTML Content 
- Plain Text Content 
- Email Address Field 
- Attachments 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Company IDRequired 
- Company Name 
- Email Address 
- Website 
- Notes 
- Opt-In 
- Address Country Code 
- Address Street (Line 1) 
- Address Street (Line 2) 
- Address City 
- Address State 
- Address Zip Code 
- Address Zip Four 
- Phone Number 
- Phone Extension 
- Phone Type 
- Phone Number 
- Phone Extension 
- Phone Type 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- FieldRequired 
- ValueRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Invoice IDRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Company NameRequired 
- Country Code (e.g., "USA") 
- Address Line 1 
- Address Line 2 
- Locality 
- Region (e.g., "US-CA") 
- Zip Code 
- Zip Four 
- Phone Number 
- Phone Ext 
- Notes 
- Email Address 
- Fax Number 
- Website 
 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
- 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
- FormRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
 - New Action Sequence- Triggers when a new Action Sequence is added. Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
- Appointment Trigger Requirement 
- Appointment events this trigger will listen to:Required 
 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.
- Note events this trigger will listen to:Required 
 Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
- Product events this trigger will listen to:Required 
 Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
 - New Subscription Plan- Triggers when a new Subscription Plan is added. Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
- Task events this trigger will listen to:Required 
 Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
 - New Invoice- Triggers when a new invoice is created. This will trigger the moment the invoice is created, before any details are added. Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
 - New Payment (All Payment Type)- Triggers when any payment is made regardless of the payment type. Credit Card Payments, Cash Payments, and Check Payments. Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
 - New Assigned Task- Triggers when a new task is created. Please note: only tasks assigned to the authenticated user may be retrieved through this trigger. Use the New Task Event trigger to retrieve all tasks. Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
 - Updated Contact- Triggers when an existing contact is updated. Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
- Product NameRequired 
- Active 
- Product Description 
- Product Price 
- Product Short Description 
- SKU 
- Subscription Only 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Contact IDRequired 
- Lead Affiliate Id 
- Order DateRequired 
- Product IdRequired 
- Product QuantityRequired 
- Price Override 
- Order TitleRequired 
- Order TypeRequired 
- Promo Codes 
- Sales Affiliate Id 
- Company 
- Country Code (e.g., USA) 
- First Name 
- Is Invoice to Company 
- Last Name 
- Address Line 1 
- Address Line 2 
- Locality 
- Middle Name 
- Phone 
- Region (e.g., US-CA) 
- Zip Code 
- Zip Four 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Contact Id 
- Due DateRequired 
- TitleRequired 
- User Id 
- Description 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- ContactRequired 
- TagsRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- ContactRequired 
- TagsRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Email or Phone Required 
- Check for Duplicates UsingRequired 
- Email Address 1 
- Opt In 
- Last Name 
- First Name 
- Tag IDs 
- Anniversary Date (format: YYYY-MM-DD) 
- Birth Date (format: YYYY-MM-DD) 
- Company Name 
- Company ID 
- Contact Type 
- Job Title 
- Lead Source ID 
- Middle Name 
- Origin IP Address 
- Owner ID 
- Preferred Locale 
- Preferred Name 
- Prefix 
- Source Type 
- Spouse Name 
- Suffix 
- Time Zone 
- Website 
- Keap Source ID 
- UTM Campaign 
- UTM Content 
- UTM Medium 
- UTM Source 
- UTM Term 
- Billing Address Fields Required 
- Billing Address Country Code (e.g., USA) 
- Billing Address Line 1 
- Billing Address Line 2 
- Billing Address City 
- Billing Address Postal Code 
- Billing Address Region (e.g., US-CA) 
- Billing Address Zip Code 
- Billing Address Zip Four 
- Shipping Address Fields Required 
- Shipping Address Country Code (e.g., USA) 
- Shipping Address Line 1 
- Shipping Address Line 2 
- Shipping Address City 
- Shipping Address Postal Code 
- Shipping Address Region (e.g., US-CA) 
- Shipping Address Zip Code 
- Shipping Address Zip Four 
- Other Address Fields Required 
- Other Address Country Code (e.g., USA) 
- Other Address Line 1 
- Other Address Line 2 
- Other Address City 
- Other Address Postal Code 
- Other Address Region (e.g., US-CA) 
- Other Address Zip Code 
- Other Address Zip Four 
- Email Address 2 
- Email Address 3 
- Phone 1 Number 
- Phone 1 Type 
- Phone 1 Extension 
- Phone 2 Number 
- Phone 2 Type 
- Phone 2 Extension 
- Phone 3 Number 
- Phone 3 Type 
- Phone 3 Extension 
- Phone 4 Number 
- Phone 4 Type 
- Phone 4 Extension 
- Phone 5 Number 
- Phone 5 Type 
- Phone 5 Extension 
- Fax 1 Number 
- Fax 1 Type 
- Fax 2 Number 
- Fax 2 Type 
- Facebook Account 
- LinkedIn Account 
- Twitter Account 
- Instagram Account 
- Snapchat Account 
- YouTube Account 
- Pinterest Account 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Company NameRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- FieldRequired 
- ValueRequired 
- Email or Phone Required 
- Check for Duplicates UsingRequired 
- Email Address 1 
- Opt In 
- Last Name 
- First Name 
- Tag IDs 
- Anniversary Date (format: YYYY-MM-DD) 
- Birth Date (format: YYYY-MM-DD) 
- Company Name 
- Company ID 
- Contact Type 
- Job Title 
- Lead Source ID 
- Middle Name 
- Origin IP Address 
- Owner ID 
- Preferred Locale 
- Preferred Name 
- Prefix 
- Source Type 
- Spouse Name 
- Suffix 
- Time Zone 
- Website 
- Keap Source ID 
- UTM Campaign 
- UTM Content 
- UTM Medium 
- UTM Source 
- UTM Term 
- Billing Address Fields Required 
- Billing Address Country Code (e.g., USA) 
- Billing Address Line 1 
- Billing Address Line 2 
- Billing Address City 
- Billing Address Postal Code 
- Billing Address Region (e.g., US-CA) 
- Billing Address Zip Code 
- Billing Address Zip Four 
- Shipping Address Fields Required 
- Shipping Address Country Code (e.g., USA) 
- Shipping Address Line 1 
- Shipping Address Line 2 
- Shipping Address City 
- Shipping Address Postal Code 
- Shipping Address Region (e.g., US-CA) 
- Shipping Address Zip Code 
- Shipping Address Zip Four 
- Other Address Fields Required 
- Other Address Country Code (e.g., USA) 
- Other Address Line 1 
- Other Address Line 2 
- Other Address City 
- Other Address Postal Code 
- Other Address Region (e.g., US-CA) 
- Other Address Zip Code 
- Other Address Zip Four 
- Email Address 2 
- Email Address 3 
- Phone 1 Number 
- Phone 1 Type 
- Phone 1 Extension 
- Phone 2 Number 
- Phone 2 Type 
- Phone 2 Extension 
- Phone 3 Number 
- Phone 3 Type 
- Phone 3 Extension 
- Phone 4 Number 
- Phone 4 Type 
- Phone 4 Extension 
- Phone 5 Number 
- Phone 5 Type 
- Phone 5 Extension 
- Fax 1 Number 
- Fax 1 Type 
- Fax 2 Number 
- Fax 2 Type 
- Facebook Account 
- LinkedIn Account 
- Twitter Account 
- Instagram Account 
- Snapchat Account 
- YouTube Account 
- Pinterest Account 
 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
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 + Keap Integrations Work
- Step 1: Authenticate Google Sheets, Gravity Forms, and Keap.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.






















