Google Sheets

• Sees only the files you pick. Rasket asks Google for access to the spreadsheets you choose in Google's file picker, and nothing else in your Drive.
• One tab, one sync. A sync says which column holds the email address, what the other columns become, and the segment the people go into.
• Adds and updates, never removes. New rows become contacts, and changes in the sheet update them. Nobody is removed or unsubscribed by a sync.
• Never changes your rows. With write-back on, Rasket writes only to its own tab in the spreadsheet.

• An admin of the Rasket project. Connecting a Google account and adding a sync are an admin's decisions. Other members can see the syncs but not change them.
• A tab with a header row. Row 1 names the columns. One of them holds one email address per row.
• Their agreement. Only people who agreed to hear from you should arrive subscribed. An opt-in column, such as a checkbox, says who did.
• A verified sending domain, for the campaigns you send afterwards. The domains guide walks through it.

1. In Rasket, open Settings, then Integrations, then Google Sheets, and choose Connect a Google account.
2. Rasket says what it will read. Choose Continue to Google.
3. Sign in to Google and allow Rasket to see the files you pick. Keep that box ticked: without it Rasket can't read any sheet.
4. You are back on Settings, and the account has its own card.

Finish within ten minutes of choosing Continue. After that the connection expires and nothing is read; start again from Settings. A project can connect more than one Google account.

1. On the account's card, choose Add a sync. Google's file picker opens. Pick the spreadsheet.
2. Choose the tab. The form lists the columns named in its first row.
3. Map the columns, as the table below describes.
4. Say who agreed to hear from you, as the consent table describes.
5. Choose Save and sync. The sync runs once straight away, and its page shows what it did.

Only the admin who connected a Google account can open the file picker on it, because it shows their Drive. Another admin connects their own account.

Two columns with the same name, or a column with no name in row 1, can't be mapped. Rename them in the sheet first.

A contact who is not subscribed gets no campaigns, only the transactional email you send them. Rasket keeps the statement you confirmed, who confirmed it and when, on the sync.

A contact who arrived not subscribed is subscribed once their row says yes. Someone who unsubscribed stays unsubscribed, whatever the sheet says.

• It never removes or unsubscribes anybody. A row deleted from the sheet, or no longer opted in, leaves the contact and its segment as they are.
• It never touches people who said no. Unsubscribed contacts, addresses on your suppression list and contacts deleted in Rasket are skipped and left alone. A contact you delete stays deleted.
• It never changes the tab it reads.

Changes in the sheet win over names and properties edited in Rasket. An email address changed in the sheet becomes a new contact; the old one stays. When one address appears in several rows, the last row wins.

Turn on Write email activity back and Rasket keeps a tab called “Rasket activity” in the same spreadsheet, one row per contact the sync added. It is written after each run, and every hour when something changed. It covers campaigns only.

The Google account needs edit access to the spreadsheet. If a tab with that name already exists, rename it so Rasket can create its own. If you delete the tab, Rasket creates it again.

In Campaigns, create a campaign for the sync's segment and send it. With an hourly sync, the segment keeps growing as rows are added. The campaigns reference covers sending one over the API.

• Sync now on the sync's page runs it at once.
• Write back now rewrites the activity tab at once.
• Change this sync edits the mapping, the segment, the topic, the schedule or write-back.
• Runs shows the newest runs and how many rows each added, updated and skipped. Rasket keeps the last 30.
• Delete sync stops it. The contacts it added stay.
• Disconnect on the account's card deletes its syncs and ends Rasket's access. The contacts stay.

• Hourly, not instant. An hourly sync runs about once an hour. Use Sync now when you need a change sooner.
• 20,000 rows a run. A bigger tab is read over several runs, each one continuing where the last stopped.
• Columns A to ZZ. Columns past ZZ are not read.
• Your plan's contact limit applies, as it does to an import. Rows past it are skipped.