Track your DMs in Google Sheets
Juncts writes one row per contact to a "Chats" tab (and a "Contacts" tab) in a spreadsheet you choose, with the latest message columns and, on manual sync, the chat history.
What lands in the sheet
| What | Where in the sheet |
|---|---|
| One row per contact | "Chats" tab; people without a chat go to the "Contacts" tab |
| Columns | Name, Platform, Latest message columns and the contact fields you enable. Column headers are renameable |
| Chat history | A "Chat history" cell, only on manual chat sync |
Set up
- In Juncts open Settings > Integrations, choose Google Sheets (Pro) and sign in with Google. The access requested is the Sheets scope.
- Paste the spreadsheet URL or ID.
- Pick the mode: Streaming (rows update as chats change, with Auto-sync) or Manual (rows change only when you sync).
How syncing works in Juncts
- You choose what syncs. Per destination, pick a sync mode: Auto-sync labeled (only chats with a label sync), Auto-sync all, or Manual only. A chat you mark Private never syncs, whatever the mode. Group chats are skipped unless you turn them on.
- A chat is matched to a contact by profile URL. If no contact matches, Juncts creates one unless you turn off "Create contacts if not found". With that off, an unmatched contact is not created and nothing is updated.
- Messages and fields are separate switches. "Sync messages" can be turned off so only contact fields sync.
- Sync is incremental. Juncts remembers what it delivered per conversation, so a retry or a lost browser cache does not create duplicates.
- Where the data goes. Your browser builds the conversation, and the Juncts server passes it on to your CRM with the credentials you connected. See the privacy policy for details.
Limits to know
- CRM sync is a Pro feature ($19.99/month), with unlimited destinations. Starter ($7.99/month, 14-day free trial, no card required) does not include CRM sync.
- Automatic syncs write the latest message only; manual sync writes the history.
Try Juncts free
Starter is $7.99/month, 14-day free trial, no card required. Pro is $19.99/month: up to five connected inboxes, unlimited AI agent actions, in-app AI summaries and drafts, saved inboxes, split views, export, CRM sync.
Try Juncts freeWritten by the team that makes Juncts. Juncts is independent. It is not affiliated with, sponsored by or endorsed by Google LLC. Product names are trademarks of their owners, used here only to say what Juncts works with.