Sync your guest list with Google Sheets

If more than one person is touching the guest list, Google Sheets can be the easiest “shared scratchpad.” Connect once, then run a sync whenever you want those updates reflected in Knotty—especially before you send invites or export counts.

Understand permissions

Only event admins can connect, reconnect, sync, or disconnect Google Sheets for an event. If you don’t see the buttons, ask an event admin to either run the connection for you or update your role in Permissions.

First-time setup

  1. Open your event.
  2. Go to Guests → Google Sheets.
  3. Select Connect your Google account.
  4. In the pop-up, sign in to Google and click Allow.
  5. Return to the event and confirm connected status.

Day-to-day tips

  • Use Sync now before big moments (invite send, vendor counts, seating work).
  • If someone changes Google permissions or switches accounts, you may need to reconnect.
  • It’s simplest if one admin account “owns” the connection.
  • Disconnect only if you’re done using Sheets for this event.

Troubleshooting

  • If you see Could not connect Google Sheets → allow popups, try again, and make sure you finish the Google permission screens.
  • If you see Connection details were missing → start the connection again from Guests → Google Sheets (this usually clears a stale login flow).
  • If Sync now says you’re not connected → reconnect first, then run sync again.

Quick checklist

  • Confirm you’re an admin.
  • Keep popups enabled during the connection step.
  • Run Sync now before deadlines.
  • If you need help, copy the exact error message (word-for-word).

Still have questions?

If anything's unclear or you run into a snag, get in touch through our contact page.