- Connect a Google account
- Match your columns
- Preview before you sync
01
Before you start
Check these things first.
- Your DripTell plan includes integrations. Starter, Business and Scale do. Lite and Forever Free do not.
- You can change settings in DripTell. To send leads or contacts, you also need access to all of them, not only your own.
- You have a Google Sheet with column headings in one row, such as Name, Phone and Email.
- The sheet has a column named DripTell ID. DripTell fills it in and uses it to update the same row next time.
02
How the sync works
The sync goes one way, from DripTell to your sheet. Changes you make in the sheet do not come back to DripTell.
- It sends records created or changed after you first save the connection, not your full history.
- DripTell checks for changes about every 30 seconds.
- Empty values in DripTell do not erase cells. Columns you do not match stay untouched.
- Rows already in your sheet are never deleted, even when you pause or a record leaves the stage or group.
03
Connect your Google account
This is step 1 of 5. Sign in with the Google account that owns the spreadsheet or can edit it.
- 1
Open the Google Sheets page
In DripTell, go to Settings, then Integrations, then Google Sheets. Select New sheet connection.
- 2
Select Sign in with Google
Choose your account and approve access. If an account is already connected, pick it under Use a connected account.
- 3
Select Continue
You move on to choosing your records.
04
Choose what goes into the sheet
This is step 2. Pick one type of record for each connection. Make a separate connection for each list you want, for example enquiries and invited guests.
| Option | What it sends | How to narrow it down |
|---|---|---|
| Leads & enquiries | New leads and their progress | Under Which lead stage? pick one stage, or All stages |
| Contacts & guests | People and their custom contact details | Under Which contact group? pick one group, or All workspace contacts |
05
Choose your spreadsheet
This is step 3. Use an existing Google Sheet that already has column headings.
- 1
Select Choose from Google Drive
Pick the spreadsheet in the Google file chooser. A file chosen before is also listed under Or use a previously selected spreadsheet.
- 2
Pick the tab
Choose the tab under Tab inside this spreadsheet.
- 3
Set the heading row if you need to
If your headings are not on the first row, open Headings are not on the first row?, enter the Heading row and select Reload headings.
06
Match the columns
This is step 4. DripTell suggests clear matches. Check each one, and set any column you do not want changed to Leave untouched.
- 1
Name this connection
Use a name your team will recognise, such as Qualified enquiries.
- 2
Choose the DripTell ID column
Under DripTell reference column, pick your DripTell ID column. Do not pick a column with your own booking or guest IDs.
- 3
Match the other columns
For each Google Sheets column, pick a DripTell field. Use Find a DripTell field to search.
- 4
Open the preview
Select Preview & review.
07
What DripTell can write
Lead connections can use lead and contact fields. Contact connections use contact fields only.
| Group | Fields |
|---|---|
| Contact | Contact ID, Full name, First name, Last name, Phone number, Email address and Created at |
| Lead | Lead ID, Lead title, Stage, Status, Source, Value, Currency, Priority, Created at and Updated at |
| Your own fields | The custom contact fields and custom lead fields you added in DripTell |
08
Preview, save and start the sync
This is step 5. Nothing is written to your sheet until you select Start sync.
- 1
Check the preview
Check before you connect shows the latest matching record and the value for each column. No row has been sent yet.
- 2
Select Save as draft
The connection appears under Your sheet connections.
- 3
Select Start sync
Read the message that opens, then select Start sync again. This writes real data to your sheet.
- 4
Send one test record if you want
Select Send one test record. It sends the latest matching record only, not your whole list.
09
Pause, change or disconnect
You can pause at any time. Rows already in your sheet are not removed.
- To stop sending, select Pause sync.
- To change the fields, pause first, then select Edit fields. You cannot edit while rows are waiting or need review.
- To disconnect a Google account, open Connected Google accounts, select Disconnect, then Disconnect account. Syncs that use it pause. Nothing is deleted from Google Sheets.
10
Fix common problems
DripTell shows each problem in plain words. These are the common ones.
- DripTell asks you to choose the column for the DripTell reference. Add a DripTell ID column to your sheet, then select Refresh headings.
- A mapped column moved or was renamed. Pause the sync, select Edit fields and check the matches again. No values were written.
- A tab is over the 10,000 row limit. Point the connection at a smaller tab.
- A record type says Workspace-wide access is required. Ask the workspace owner for access to all leads or all contacts.
- A Google account says Reconnect needed. Select Connect Google account and sign in with the same account again.
11
Get help
Email support@driptell.com. Tell us your workspace name, the connection name, what you did and what you see.
