Once you've set up Google Sheets (see Connect Your Swaps to Google Sheets), here's what you'll find in your sheet, how to keep it working, and how to make changes.
What's in your sheet
Your signups are added to a tab called Grouped, one row per signup. Each row has these columns:
Swap: the Swap the fan signed up through
Swap type: Contacts, Poll, Purchase, or Pre-save
Name, Email, and Phone
Opted in: when the fan signed up, in UTC
Zip
Poll answer
Poll answer ID
Source: where the fan came from, like Instagram or a campaign name
Participation ID
Swap ID
ā¹ļø Note:
Only fans who give an email address are added to your sheet.
If a fan joins more than one of your Swaps, they'll have a row for each one.
Rows aren't changed after they're added.
Poll answer ID, Participation ID, and Swap ID are permanent IDs for connecting your sheet to other tools like Zapier. You don't need to do anything with them.
Keep your sheet working
Grouped uses the headings in the top row of the Grouped tab to know where each signup goes.
ā ļø Heads up: Don't rename, delete, or reorder the headings, or add columns in between them. If a heading changes, new signups pause until it's fixed. Nothing is lost: your signups are saved and added once the heading is back.
You can safely change formatting (like colors, bold, or column widths), add your own columns to the right of Swap ID, or add your own tabs to the spreadsheet.
Where to make changes
All Google Sheets settings live in a Swap's Connections section:
From your dashboard, click Swaps under Growth Tools.
Find the Swap and click Manage.
Scroll to the bottom and click Connections to open it.
ā¹ļø Note: Changes you make from the āÆ menu next to your sheet name save right away. Turning the Google Sheets toggle on or off is saved when you click Update.
Use a different sheet for one Swap
By default, all your Swaps send fans to the same sheet. To keep one Swap's fans in their own sheet:
Open the Swap's Connections.
Click the āÆ menu next to your sheet name, then click Use a different sheet for this Swap.
Choose Create a new sheet, or Connect an existing sheet and pick one from your Drive.
Nothing switches until you finish. Changed your mind? Click Keep account sheet.
To send that Swap back to your main sheet later, click the āÆ menu and select Use account sheet. To swap in a different sheet for it, select Replace sheet.
Rename a Swap's tag
A Swap's tag is what shows in the Swap column. It's the Swap's title by default.
Open the Swap's Connections.
Click the āÆ menu next to your sheet name, then click Rename tag.
Enter a new tag (up to 120 characters) and click Save.
Only new signups use the new tag. Rows already in your sheet keep the tag they were saved with, and the Swap ID column stays the same either way.
š” Tip: To go back to the Swap's title, click Rename tag, then Reset to auto.
Change your Google account
In any Swap's Connections, click Replace next to your Google account email and choose a different account. Then pick or create a sheet on the new account.
ā ļø Heads up: This moves all your Swaps to a new sheet on the new account, not just the one you're editing. Your current account keeps syncing until the new one is ready, and anything connected to your old sheet keeps watching the old one.
Turn off Google Sheets for a Swap
Open the Swap's Connections.
Click the toggle next to Google Sheets to turn it off.
Click Update at the bottom of the page to save.
New signups from that Swap won't be added to your sheet, but they're still saved in Grouped. If you turn it back on later, they'll be added.
ā¹ļø Note: There isn't a way to disconnect your Google account from Grouped right now. You can remove Grouped's access in your Google account settings.
If fans stop showing up in your sheet
If something goes wrong, the Google Sheets card in your Swap's Connections shows a message and a button to fix it. Here's what each one means:
Grouped's access to your Google account was removed. Click Reconnect and sign in to Google again. This affects every Swap using that Google account.
The sheet fans were flowing into no longer exists. The sheet was deleted. Click Use another sheet to pick or create a new one.
Grouped can no longer edit this sheet. Someone changed the sheet's sharing settings. Click Restore access to open the sheet and fix the permissions, or click Use another sheet. Once it's fixed, fans start arriving again within the hour.
The Grouped tab is gone from this sheet. Click Recreate the tab.
A heading is missing or has moved. Click Open sheet and put the headings in the top row back the way they were. Syncing picks up where it left off.
This sheet has reached the maximum size Google allows. Click Start a new sheet. Your fans are saved and will be added to the new sheet.
Google is responding slowly. New fans will take longer to show up. Grouped keeps retrying on its own, so there's nothing you need to do.
ā¹ļø Note: In every case, your signups are still saved in Grouped, so nothing is lost while you fix it. If you see Sync stopped and none of the above applies, contact us at support@grouped.com.