You shouldn’t buy this!

In 2021, Gravity Wiz contracted me to fork this plugin. Since then, they’ve launched Gravity Perks Google Sheets, and you should buy that instead. It’s way better, and I helped build it. Check out the software I offer now or hire me to build the plugin you need at https://breakfastco.xyz/ I am listed on the Gravity Wiz Recommended Developers page.

Thanks,
Corey Salzano

Installation Instructions

  1. Download the plugin .zip file from the Purchase History page
  2. Upload the plugin one of two ways:
    1. Unzip & upload the plugin folder to the /wp-content/plugins/ directory
    2. Visit the Plugins menu in WordPress. Tap buttons Add New → Upload Plugin → Browse and locate the .zip file
  3. Activate the plugin through the Plugins menu in WordPress
  4. Copy & save your license key in the box at Forms → Settings → Google Sheet
  5. Visit the Google Sheet tab in the Settings of any Gravity Form
  6. Learn how to configure a form below: How to Connect a Gravity Form to a Google Sheet

How to Get a License Key

Licenses are for sale at entriestogooglesheet.com/pricing.

Find Your License Keys

License keys visible on the Checkout page immediately after purchases. Your license keys are always available after logging into this website. Visit the Purchase History page to see your purchases. Tap the View Licenses link near the any invoice to find purchased license keys.

How to Connect a Gravity Form to a Google Sheet

A Google Account is required to use this plugin. During steps 1 through 3, it may be convenient to open WordPress in one tab and Google Cloud Platform in another.

This screenshot shows the credentials page of a project in the Google Cloud Platform. Arrows point at Authorized redirect URI storage and Client credentials.
  1. Obtain a Client ID and Client Secret from Google

    Step 1 overlaps Google’s instructions to create OAuth credentials. Try this first:

    1. Login to Google Cloud Platform
    2. From the projects list, select a project or create a new one. You might land in a sample project called Quickstart. Look for a project menu near the Google Cloud Platform logo text. If you create a project, you may have to wait a few moments before tapping a SELECT PROJECT button to load the new project.
    3. Browse the Library for the Google Drive API and Google Sheets API. Visit and Enable both for the project you created. Make sure the correct project name appears at the top of the library before Enabling APIs.
    4. Return to Google Cloud Platform and find Credentials in the APIs & Services menu on the left.
    5. Click OAuth client ID under the CREATE CREDENTIALS menu near the top.
    6. Choose Application Type Web Application.
    7. Provide a name like “Entries To Google Sheet at example.com”
    8. Back in WordPress,
      1. Visit the Google Sheet tab of a Gravity Form
      2. Click the Add New button to create a new feed
      3. Copy the Authorized Redirect URI to your clipboard
    9. Return to Google Cloud Platform, click the ADD URI button, and paste the Authorized Redirect URI.
    10. Click Create.
    11. Copy and paste the Client ID and Client Secret pair into the corresponding boxes in the Connection section of the feed settings page you opened in step 8.
    12. Click Save Settings to save the credentials in WordPress
  2. Click the Create Sheet Button

    The Create Sheet button will attempt to create a new Sheet at the root of your Google Drive. The first time you click this button, creation will fail, and you will prompted to click a link to give this website access to your Google Drive.

  3. Click the Link in the Failure Message

    An error message will appear at the top of the form settings page. Click the link to visit the Google consent screen. Google will prompt you to choose a Google Account and grant the website access to create files inside that account’s Google Drive. After you grant consent, you will be redirected back to the feed settings.

  4. Click the Create Sheet Button Again

    After authorizing this website to access your Google Drive, click the Create Sheet button again. A success message will confirm that a new Sheet was created at the root directory of Google Drive. Use the Open Sheet and Insert Test Row buttons to confirm WordPress can write to the Sheet.
    FAQ: Can I rename and move the Sheet in my Google Drive after it’s created?

  5. Consider checking the Edit & Delete Rows checkbox to also sync edits. Use the Save Settings button to make feed configuration changes.
  6. Return to the Google Sheet tab of the form and confirm the feed is Active.
  7. Submit the form & celebrate!