Google Sheets

The Gravity Forms Google Sheets Add-On connects your Gravity Forms submissions directly to Google Sheets, turning every form entry into a structured spreadsheet row automatically.

Overview

Built for teams that live in spreadsheets—support, operations, marketing, and reporting—this integration makes it easy to route form data into a sheet you can filter, share, and analyze. Once configured, each submission can be added to a new row, or even update an existing row when you need a living, always-current dataset.

Key Features

  • 🔁 Automatic Spreadsheet Updates: Send each form submission to a Google Sheet automatically—no copying and pasting.
  • 🧠 Smart Field Mapping: Map Gravity Forms fields to spreadsheet columns so your data lands exactly where you want it.
  • 🆕 Create New or Use Existing Sheets: Start fresh or connect to an existing spreadsheet, depending on your workflow.
  • 🧾 Update Existing Rows (Optional): Configure an “update row” behavior to update matching records instead of always appending.
  • 🚀 Seamless Setup: Authenticate with Google and configure everything inside familiar Gravity Forms settings and feed screens.
  • 🔐 Powered by Google OAuth + Sheets API: Uses Google’s OAuth flow and the Sheets API for secure, reliable connectivity.

How It Works

  1. Install and activate the add-on.
  2. Connect your Google account from Forms → Settings → Google Sheets.
  3. Create a feed within Gravity Forms and map your form fields to Google Sheets columns.
  4. Choose a spreadsheet (via Google’s file picker) or paste a spreadsheet ID.
  5. (Optional) Configure update behavior to match and update existing rows.
  6. Let automation handle the rest—each submission flows into your sheet automatically.
Discuss in forums
Documentation

Provide feedback here

Requirements

  • WordPress 5.0+
  • PHP 7.4+
  • Gravity Forms 2.7+

Changelog

0.1.1-alpha.2

2026-10-27

  • Added a copy button for the redirect URI on the Google Sheets settings screen.
  • Added Google Cloud setup steps to the settings screen, with links to enable the Sheets, Drive, and Picker APIs.
  • Added a Google icon to the form settings and plugin settings menus.
  • View more

0.1.1-alpha.1

2026-05-28

  • Initial release

Changelog — gravityforms/gravityformsgooglesheets

0.1.1-alpha.2

2026-10-27

  • Added a copy button for the redirect URI on the Google Sheets settings screen.
  • Added Google Cloud setup steps to the settings screen, with links to enable the Sheets, Drive, and Picker APIs.
  • Added a Google icon to the form settings and plugin settings menus.
  • Added a Refresh fields control so an existing spreadsheet feed can reload column names without disconnecting Google.
  • Added the Gravity Labs notice to the plugin settings page and the form feed screens.
  • Added worksheet selection so an existing spreadsheet feed can send entries to a specific tab.
  • Fixed column mapping so Name inputs, Entry Date, and other non-numeric choices write the submitted value.
  • Fixed feed saves so a pasted spreadsheet URL is stored as its ID and the selected worksheet's name is saved with the feed.
  • Updated the feed screen so Refresh fields sits with the spreadsheet settings, and the Google Sheet picker stays in view.

0.1.1-alpha.1

2026-05-28

  • Initial release

Documentation

Google Sheets Add-On Documentation

A WordPress plugin that sends Gravity Forms entries to Google Sheets.

Key Features

  • Sends Gravity Forms submissions to a Google Spreadsheet (create new or use an existing spreadsheet).
  • Feed-based configuration (per-form) to map Gravity Forms fields to Google Sheets columns.
  • Optional “update row” behavior when a configured column matches (update existing row instead of always appending).
  • OAuth-based Google connection for secure access.
  • Google Picker integration to select a spreadsheet, or manually paste a spreadsheet ID.
  • Uses the Google Sheets v4 REST API (via WordPress HTTP API).
  • Built-in caching and basic rate limiting in the API layer to reduce repeated calls.

Requirements

  • WordPress 5.0+
  • PHP 7.4+
  • Gravity Forms 2.7+

Installation

  1. Upload the plugin folder to /wp-content/plugins/ (or install via Plugins → Add New → Upload Plugin).
  2. Activate Gravity Forms Google Sheets Add-On.
  3. In WordPress admin, go to Forms → Settings → Google Sheets and configure the Google API credentials.
  4. On each form you want to connect:
    • Go to Forms → (select your form) → Settings → Google Sheets
    • Create a feed, then map fields and choose a spreadsheet.

Connecting Google Cloud + OAuth

This add-on requires Google Cloud credentials for:

  • OAuth (to connect to Google and access Sheets/Drive)
  • Google Picker API key (to browse/select spreadsheets from the UI)

Step 1: Create or select a Google Cloud project

  1. Open Google Cloud Console.
  2. Click the project picker at the top of the page (next to “Google Cloud”).
  3. Click New Project.
  4. Enter a project name (for example, Gravity Forms Sheets).
  5. Click Create.
  6. Wait for the project to be created, then select it from the project picker.

Step 2: Enable required APIs

  1. In the left menu, go to APIs & Services → Library.
  2. Search for Google Sheets API and click it.
  3. Click Enable.
  4. Go back to Library.
  5. Search for Google Drive API and click it.
  6. Click Enable.
  7. Go back to Library.
  8. Search for Google Picker API and click it.
  9. Click Enable.

All three APIs are required:

  • Google Sheets API — read and write spreadsheet data when entries are submitted.
  • Google Drive API — access files the user selects or the plugin creates.
  • Google Picker API — powers the Choose Google Sheet browser UI in feed settings. You must enable this API before you can restrict your Browser API key to it in Step 5.

Step 3: Configure the OAuth consent screen

*Note: you only need to complete this step if you are setting up a new project.

  1. Go to APIs & Services → OAuth consent screen.
  2. Click Get Started
  3. Fill in the required fields:
    • App name — e.g. My Site Google Sheets
    • User support email — your email address
    • Developer contact email — your email address
  4. Choose a User type:
    • Internal — only users in your Google Workspace organization can connect. Use this if everyone connecting has an account on your company’s Google Workspace domain.
    • External — any Google account can connect. Use this for most WordPress sites where the site owner connects their personal or business Google account.
  5. Click Save and Continue.

Step 4: Create an OAuth 2.0 Client ID

  1. In WordPress, go to Forms → Settings → Google Sheets.
  2. Copy the Authorized redirect URI shown on that page. It looks like: https://yourdomain.com/wp-admin/admin.php?page=gf_settings&subview=gravityformsgooglesheets
  3. In Google Cloud Console, go to APIs & Services → Credentials.
  4. Click Create Credentials → OAuth client ID.
  5. Set Application type to Web application.
  6. Enter a Name (e.g. Gravity Forms Google Sheets).
  7. Under Authorized redirect URIs, click Add URI and paste the URI you copied from WordPress.
  8. Click Create.
  9. Copy the Client ID and Client Secret—you will paste these into Forms → Settings → Google Sheets

Step 5: Create a Browser API key (Google Picker)

This key lets administrators browse Google Sheets when configuring a feed. It is embedded in the WordPress admin JavaScript but is safe when restricted by HTTP referrer.

  1. Go to APIs & Services → Credentials.
  2. Click Create Credentials → API key.
  3. Under Select API restrictions, search and select Google Picker API.
  4. Under Application restrictions, select Websites.
  5. Click Add and enter your WordPress admin. Examples: https://yourdomain.com/wp-admin/* https://*.yourdomain.com/wp-admin/*
  6. Click Done.
  7. Click Create
  8. Copy & Paste this key into the Google Picker API field in Forms → Settings → Google Sheets.

Step 6: Connect with Google

  1. Go to Forms → Settings → Google Sheets.
  2. Make sure all API keys have been entered and click Update Settings
  3. Click Connect with Google
  4. Complete the onscreen authentication steps
  5. When redirected back to the settings page, you should see: Successfully connected to Google Sheets.
    Account: [email protected]

Configuring Feeds (Form → Google Sheets)

Configuration is feed-based (standard Gravity Forms Feed Add-On pattern):

  1. Open the form you want to connect: Forms → [Your Form] → Settings → Google Sheets.
  2. Click Add New to create a feed.
  3. Enter a Feed Name (e.g. Contact Form Sheet).
  4. Choose a Sheet Mode:
    • Create New Sheet — the plugin creates a spreadsheet on the first submission. Good for getting started quickly.
    • Use Existing Sheet — connect to a spreadsheet you already have. Requires Google Picker or a pasted spreadsheet ID.
  5. Map at least one column in Column mapping (Sheet column → form field or merge tag).
  6. Click Save Settings (or Update Settings).

Using the Add-On: Sending Entries to Sheets

Once connected and a feed is configured:

  • Each form submission will be sent to the configured spreadsheet.
  • Field values are written into the mapped columns.
  • If “update row” is configured, the plugin will attempt to locate an existing row by the configured match column/value and update that row instead of appending.

Admin UI Locations

  • Global settings (API credentials + connect/disconnect):
    • Forms → Settings → Google Sheets
  • Per-form feed settings:
    • Forms → [Form] → Settings → Google Sheets

Troubleshooting

Redirect URI mismatch

If Google returns redirect_uri_mismatch:

  • Copy the redirect URI shown in the plugin settings exactly into Google Cloud OAuth client settings.
  • Ensure your WordPress admin URL scheme matches your site (HTTPS vs HTTP). The plugin attempts to force HTTPS when it detects SSL, but proxy/TLS setups can still cause mismatches.

Picker doesn’t open or can’t browse files

  • Confirm the Picker API key is set.
  • Confirm referrer restrictions allow your WP admin domain.
  • Confirm Google Drive API is enabled in Google Cloud.

Entries are not appearing in Sheets

  • Confirm the form has an active Google Sheets feed.
  • Confirm the connected Google account has access to the spreadsheet.
  • Confirm the sheet ID is correct (if manually pasted).
  • Check for caching/security plugins blocking outgoing requests or the WordPress admin AJAX/UI scripts.