Keep your team’s spreadsheet up to date.

The people who run the market work in a spreadsheet, not the WordPress admin. Every registration lands there as a row, and a correction made to the entry changes that same row.

Market registrations Live sync

One entry. One current row.

Oakley Rune oakley@example.com
Saved
Petal Page petal@example.com
Synced
Entry updated → Row updated

Illustrative experience

  • Entries arrive as rows
  • An edit fixes the row
  • Past entries can follow

The finished experience

Nobody exports anything.

The sheet the team already has open is the live record, so the weekly export and the reconciling that follows it stop being someone’s job.

A good fit for
Teams who run the day out of a spreadsheet while a form fills it.

  1. 1

    Map the form to the columns

    Point the feed at a sheet you already keep, or let it make one, then line each field up with a column. On a long form the mapping can be filled in for you and checked.

    GC Google Sheets

  2. 2

    Let a correction reach the row

    Let the sheet follow the entry: a correction rewrites that row, trashing or spamming the entry removes it, and restoring the entry puts it back at the bottom.

    GC Google Sheets

  3. 3

    Optionally bring the entries you already have

    Add Feed Forge to process entries collected before the feed existed. Review the lookup mapping and test a small batch first; already-processed entries are skipped.

    Feed Forge

What you’ll need.

Start with Gravity Forms. Add the capabilities this solution needs, then make the experience your own.

Taking it further

Add these optional plugins when your project calls for more.

Before you start

  • A Google account. Sheet-powered fields also need GP Populate Anything.
  • Row updates need a unique lookup column mapped to a stable value. Automatic Entry Hash is not retroactive; historical entries need an existing mapped unique value or a reviewed backfill.

Get this built.

A plan covers how many of our plugins you run at once, and on how many sites. Here is what this one needs.

Required

  • GC Google SheetsConnect

Optional

Gravity Connect Basic $59 /year

Covers this on one site. More sites need Advanced or Pro.

Gravity Perks Advanced $169 /year

Only if you add GP Populate Anything and GP QR Code.

See plans for this solution

Every plan renews at the same price, and you can upgrade any time for the difference.

Make it fit
your project.

What happens to the row when we fix an entry?

With updates enabled and a matching lookup value, an entry edit rewrites its row. Trashing or spamming the entry deletes the row; restoring adds it back at the end. Automatic Entry Hash is not added to historical entries retroactively, but a mapped existing unique column can also identify rows.

Can the sheet feed the form as well?

Yes, with Populate Anything reading it the other way: a column becomes the choices in a field, so the list the team maintains in the spreadsheet is the list the form offers. The staff price lookup is that arrangement at full size.

Can registrations become scannable check-ins?

Optionally add GP QR Code to generate codes and collect scans. Use a separate check-in form with an authorized entry lookup and explicit attendance updates. The spreadsheet feed itself only sends and synchronizes rows.

  • Clay, CTO
  • Dan, Content Sorcerer
  • Dani, Product Manager
  • David, Founder & CEO
  • Matt, Senior Support Wizard
  • Roxy, Support Wizard

Not quite your build?

Tell us what you are making and we will work out which pieces it takes — or tell you straight if this is not something we can do.

Ask the wizards