Skip to main content

Google Sheets Integration for Gravity Forms

How to send Gravity Forms entries to a Google Sheet automatically with the Google Spreadsheet add-on.

You can have form entries flow into a Google Sheet automatically, so volunteers and board members can follow along without logging in to your dashboard. Every Member Splash club has a Google Drive folder set up for this.

Example: your social chair can watch July 4th RSVPs roll in and plan food and treat bags from one shared sheet.

Prefer to watch?


Connect a form to a Google Sheet

  1. Go to Content > Gravity Forms.

  2. Hover over the form name, click Settings, then Google Spreadsheet Add-on.

  3. Click Add New. (A form can send to more than one sheet. Each one is its own feed.)

  4. If you need a new spreadsheet, create it first. The screen reloads afterward.

  5. Give the feed a name only you'll see, like "RSVPs for social chair."

  6. Pick the spreadsheet, then the sheet (tab) inside it. The page refreshes to show field mapping.

  7. Match each form field to a column. Pick an existing header, or choose Add Custom Key from Select a Field to make a new column, then click Add Field.

  8. Optional: turn on conditional sync to send only some entries. Not every field type can be used as a condition.

  9. Click Update Settings.

From now on, every new entry is added to the sheet.


Send entries you already have

If the form already has entries, click Sync Entries once.

💡 Only sync once. Clicking Sync Entries again adds every entry a second time. And entries you delete from the form stay in the sheet, so remove those by hand.


Share the sheet

The feed screen shows who can open the sheet. Sharing from there gives full edit access. For view-only access, open the sheet in Google and use its Share button.


Fix numbers that start with a quote mark

Numbers sometimes show up with a ' in front:

Format those cells as plain text in Google Sheets, then sync again.

Collecting payments on this form? It also needs a payment feed. See How to Add a Payment Feed to Your Form.

Did this answer your question?