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.