Gravity Wiz Gravity Wiz

Gravity Connect Google Sheets

Automatically send and sync Gravity Forms data with Google Sheets — and unlock new possibilities for your data.

“Google Sheets” is a registered trademark of Google, Inc. Gravity Wiz and Gravity Connect are not affiliated with, sponsored by, or endorsed by Google, Inc. Using Google Sheets with Gravity Connect requires a Google account.

What does the Google Sheets Connection do?

This plugin integrates Google Sheets directly with Gravity Forms to automatically pass entry values to Google Sheets. This is done without requiring any additional software or monthly fees, and with an emphasis on security and performance.

Additionally, your Google Sheet can be automatically synced with your Gravity Forms entries, keeping your data accurate at all times.

With the Google Sheets Connection you can create:

  • Lead capture forms that instantly sync to Google Sheets for team-wide access
  • Event registration forms that populate Google Sheets for easy attendee tracking
  • Internal request forms that auto-log data to Google Sheets for HR or IT teams
  • Pre-fill form fields based on spreadsheet data*
  • Dynamic dropdowns that pull options directly from Google Sheets*
  • And many more!

*Requires GP Populate Anything.

Features

  • Send Gravity Forms entry data directly to Google Sheets.
    Unlock the vast power of Google Sheets for all of your Gravity Forms entry data.
  • Keep your spreadsheet and entry data perfectly in sync.
    Edits to your entries can automatically sync to your Google Sheets. Rows for trashed or spammed entries are automatically removed.
  • Create new or map to existing spreadsheets.
    Send data to existing spreadsheets or create a completely new spreadsheet specific to your form.
  • Fetch data from Google Sheets and use it in your forms.
    Populate your forms with Google Sheets data when paired with Gravity Forms Populate Anything.
  • Security first.
    Uses Google’s secure authentication method to ensure only you have access to your Google files and data.
  • Money-saving, value packed.
    No monthly fees or transfer limits. Just the unlimited power of Google Sheets.
  • Automatic updates.
    Get updates and the latest features right in your dashboard.
  • Legendary support.
    We’re here to help! And we mean it.

Why Google Sheets?

  1. Easy organization and analysis: Google Sheets allows you to easily organize and analyze your form data. Use various Google Sheets functions and features, like formulas, pivot tables, and charts, to analyze and visualize your data in meaningful ways.
  2. Collaboration: Google Sheets allows multiple users to access and edit the same sheet, making it easy for teams to collaborate on data analysis and decision making.
  3. Accessibility: Google Sheets can be accessed from any device with an internet connection (and has an offline mode too). Teams can access and work on form data from anywhere, using an application they’re already familiar with.
  4. Security: Google Sheets offers industry standard security measures to protect your data, including access controls, activity logging, and data encryption.
  5. Integration with other Google tools: Google Sheets can be quickly integrated with other Google tools, such as Looker Studio (formerly Data Studio) and BigQuery, allowing you to create a seamless workflow for collecting and analyzing data.
Gravity Forms Certified Developer
  • Version 1.4.6
  • Updated February 4, 2026
  • Released August 21, 2024
View Changelog

All Connections

All Perks

Documentation

  1. Terminology
  2. How do I enable this functionality?
  3. Feed Settings
    1. Google Sheets Settings
      1. Select an Existing Sheet
      2. Create New Sheet
      3. After Connection
    2. Column Mapping
      1. Auto-mapping Columns
    3. Additional Options
      1. Update & Delete Rows
        1. Lookup Column
      2. Conditional Logic
      3. Post Payment Actions
    4. Usage Examples
    5. Related Snippets
  4. Manage Google Accounts
    1. Related Snippets
  5. Send Existing Entries to Google Sheets
    1. Bulk Process Feeds
    2. Process Feeds on Import
  6. Entry Detail Meta Box
  7. Required Capabilities
  8. Integrations
    1. GP Populate Anything
    2. GP Nested Forms
    3. GP QR Code
  9. Snippets
    1. Disable Async on Google Sheets Feeds
    2. Remove the settings tab
    3. Custom Query Build Arguments
    4. Process Feed when Partial Entry is Saved.
    5. Process Feed when a New Entry is Created via Gravity Flow Form Connector.
    6. Force field value to be added to the sheet as a string
  10. Developer’s Notes
    1. Google Sheet Security
      1. What can GCGS access?
      2. How does GCGS authentication work?
        1. Legacy Tokens
    2. Developer Metadata
  11. Known Limitations
  12. Error Handling
    1. Error Notifications
    2. Action Scheduler
      1. Accessing Action Scheduler
      2. Failed Actions
      3. Pending Actions
  13. Troubleshooting Issues
    1. The Issues Section
    2. Spreadsheet Selection Issues
    3. Account Disconnection Issues
    4. Troubleshooting Action Scheduler
      1. Confirm Loopback Requests are Supported
      2. Purge Action Scheduler
  14. FAQ
    1. Does the Google Sheets Connection support files in shared drives?
    2. Can I rename or reorder columns?
    3. Can I map a label instead of a value?
    4. How can I allow multiple users to authorize Google Sheets?
    5. Is the Google Sheets Connection asynchronous?
    6. Can the Google Sheets Connection apply colors and formatting to my Google Sheet?
    7. Why can’t I select a spreadsheet when setting up the Google Sheets Connection?
    8. Why doesn’t the date format in my Date field match the date format in Google Sheets?
    9. Do Populate Anything requests count towards Google’s API quotas?
    10. Why does the Google Sheets Connection get disconnected from my Google Account?
    11. How do I migrate from the free “GP Populate Anything – Google Sheets Object Type” plugin to the Google Sheets Connection?
    12. How do I insert the new entry row at the top of the Google Sheets?
    13. How do I preserve the original data format?
    14. How do I send Partial Entries to Google Sheets?
    15. Do name changes affect the connection?
    16. How do I upgrade from the GP Google Sheets to the Google Sheets Connection?
  15. Translations
  16. Hooks
  17. Related Resources

Terminology

Before we get started, let’s clarify a few important words we’ll use throughout this documentation.

  • Google Sheets: Refers to the Google product that allows you to create and manage spreadsheets.
  • Google Sheet / spreadsheet: Refers to a collection of sheets.
  • sheet: Refers to a specific sheet within a spreadsheet.
  • GCGS: An acronym for this plugin, the GC Google Sheets Connection.

How do I enable this functionality?

After installing and activating GC Google Sheets, you can create Google Sheets feeds in any form. Use these feeds to pass data from your forms to Google Sheets. You can connect your Google account directly in the feed settings.

Navigate to your desired form and click the “Google Sheets” item under the “Settings” menu.
Click the “Add New” button to add a new Google Sheets feed.
Connect your Google account by selecting “Authorize New Account” under the Account setting.
Connect your feed to a spreadsheet by adding a new spreadsheet or connecting an existing spreadsheet.
Map your form’s fields to columns in the spreadsheet.

Feed Settings

When configuring feeds for the Google Sheets Connection, you will be presented with the following settings.