Monday paste-over
A new export broke the formulas.
BoldBellowsIntercom Google Sheets automation for teams that live in spreadsheets
Intercom to Google Sheets integration that keeps one updating row per conversation, with contacts, tags and segments in readable columns
Intercom lets you export conversations and contacts, but an export is a snapshot, and the sheet it fills goes stale as soon as a conversation is reassigned or closed. BoldBellows binds the contact, the conversation and the assigned teammate into one identity, treats a closed conversation as finished work, not as a request to act on, then finds the row for that conversation ID, creates it if it is new and updates it in place when the owner, state or tags change. The sheet becomes a living list: export Intercom leads to spreadsheet tabs, group tags and segments, and give a manager totals that already agree with the inbox.
View Pricing
From $415, billed once.
- Intercom to Google Sheets, kept current
- Leads, tags and segments in columns
- Intercom users Google Sheets sync, no duplicates
What we check before Google Sheets hears from Intercom
- Key in a columnthe conversation ID is stored and checked on every write
- Updated in placea reassign or close changes one row
- Tags readableseveral tags become a clear list, not a mess
- Quota-awarewrites are batched inside the Sheets request limits
- Replay safeRunning the same event again changes nothing
- Price by complexitystarting at $415, rising only when you choose more branching or checks
01the stale-export problem
A spreadsheet fed by exports is wrong by the time it is opened
Someone downloads the conversation list on Monday, pastes it over last week's tab and breaks every formula that pointed at the old layout. A conversation that closed on Tuesday still shows as open. Wire it to a basic trigger instead and each state change appends a new row, so one chat becomes four lines and the totals no longer match anything.
Closed chats shown as open
The sheet was a snapshot.
One chat, four rows
Each change appended a line.
The same Intercom conversations, in a sheet that stays true
Before: Google Sheets fills with repeats
- Nothing tells a repeat from a new change
- The sheet is rebuilt from an export
- State changes append extra rows
After: exceptions have an owner
- The same event always lands on the same row, using the Intercom conversation ID in a locked column plus the sheet and row it maps to
- Each conversation owns one row that updates
- Columns are checked before every write
02how it works
How an Intercom change becomes an update to the right row
First decide, then find, then act: that is the whole route in one line.
- Understand the change. The Intercom record is read to see what really changed, and the result is compared with your rule.
- Verify, fetch, find. The signature is checked, the conversation is fetched for its owner, state and tags, and the row is found through the stored conversation ID.
- Write, batch, confirm. The row is created or updated in the mapped columns, writes are batched inside the quota and the row number is stored for next time.
Intercom and Google Sheets facts the design relies on
- The same notification can arrive twice. Intercom retries a notification it cannot deliver, so every delivery is treated as a possible repeat, and the route answers quickly and does the real work afterwards.
- Ten million cells. A Google spreadsheet holds at most ten million cells across all its tabs, and the API enforces per-minute quotas for each project and each user, so wide sheets are avoided and writes are batched.
- Checks after errors. After an error the route asks Google Sheets what it holds for the Intercom conversation ID in a locked column plus the sheet and row it maps to and compares it with what was sent.
03What you receive
A tour of the Google Sheets build, part by part
First Mile handles who and whether, Full Route handles what and where, Long Watch handles how it stays true.
First MileFull RouteLong Watch
Trigger validator First Mile
Confirms that the trigger really fired for this record before the route moves on.
Stable identity ledger First Mile
Preserves the module, ID and time of each Intercom change against the Google Sheets reference it created.
Context packager First Mile
Bundles the source ID, time and link with each value so every Intercom row can be traced back.
Row writer Full Route
Creates or updates the conversation row in the columns you mapped, with tags and segments joined into a readable list.
Conversation-ID row finder Full Route
Finds the row by the conversation ID column before every write, so a change updates and never appends.
Tab routing matrix Full Route
Sends leads, users and conversations to their own tabs and decides which changes touch which.
Sheet register Long Watch
Watches for Intercom rows that stop matching and puts each one in front of an owner.
Header drift monitor Long Watch
Catches a moved, renamed or deleted column before a write lands in the wrong place.
Resolution log Long Watch
Closes each case with what was changed, by whom and when.
Intercom users Google Sheets sync is the focus; intercom to Google Sheets consultant and intercom leads Google Sheets without Zapier come with it. Related searches include intercom tags data sheets, Google Sheets intercom contacts export, intercom to Google Sheets Zapier, sync intercom conversations to Google Sheets, intercom to Google Sheets duplicate prevention, export intercom leads to spreadsheet, intercom to Google Sheets service, intercom segments Google Sheets, connect intercom to Google Sheets, intercom webhook Google Sheets, intercom Google Sheets integration, intercom to Google Sheets sync, intercom conversation log in Google Sheets, auto update Google sheet from intercom, intercom Google Sheets automation, intercom contacts data Google Sheets, intercom to Google Sheets implementation, intercom to Google Sheets, intercom segments to spreadsheet, intercom to Google Sheets historical migration and intercom to Google Sheets error handling.
04Who it's for
For the revenue-operations teams reporting on Intercom activity that want to export leads, tags and conversation volume to a spreadsheet that updates itself and never doubles a row
Intercom is where the conversation happens; the spreadsheet is where everyone else wants to see it.
Support manager
"I need totals I can trust."
Counts agree with Intercom because one conversation is one row.
Marketing lead
"Which leads came through chat?"
Lead and user roles are separate tabs with their tags attached.
Founder
"I just want a live list."
The sheet updates as conversations open, snooze and close.
Analyst
"Keep my formulas safe."
Headers are verified before every write, and nothing is inserted mid-sheet.
Agency owner
"Each client gets a sheet."
Every client's workspace writes to its own spreadsheet.
Customer-success lead
"Segments in a column, please."
Segment and tag names are written as clear lists for filtering.
05Compare
If a scheduled CSV import and zaps are not enough: a keyed conversation sheet
Each can fill a sheet. Only one keeps a single row per conversation that updates in place.
| What triggers a write | a scheduled CSV import | A simple webhook-to-Google Sheets flow | The Intercom-to-Sheets route, by BoldBellows |
|---|---|---|---|
| What starts the work | A person reading notifications | Whatever Intercom sends | YesA conversation change verified as current and in scope |
| How identity is decided | Memory and search | No key, only a search | YesA conversation ID column plus the sheet, tab and row it maps to |
| What reaches Google Sheets | What the person had time for | Whatever the trigger returned | YesOne updating row per conversation, with tags and segments in columns |
| After an uncertain result | Someone re-enters the record | Gives a failed-run notice only | YesConfirms state, then corrects or closes |
Two updates, wrong order
When updates cross in transit, the later one wins and the earlier one is kept in the log, not written over it.
Two teammates change the same conversation at nearly the same moment
Notifications are applied in order against the stored row, the later state wins and both changes are logged in the register. It looks up the Intercom conversation ID in a locked column plus the sheet and row it maps to, compares like with like and records which of the four outcomes applies. Unclear matches are held for review instead of guessed at.
With the Intercom conversation ID in a locked column plus the sheet and row it maps to in place, a duplicate, a late event and a lost reply all have a safe answer.
PricingExpect the price to track tabs, columns and rows
Tailor the Intercom to Google Sheets build and read the total
Start with the First Mile package at $415 and stop adding when it fits.
One setup fee · Range shown first · PDF handover included
View Pricing
Pricing
Build your Intercom to Google Sheets price
Pick a package, answer three short questions about how Intercom data should reach Google Sheets, and your price and turnaround move as you choose.
06The process
Six steps from an export to a sheet that updates itself
Work moves through six steps, and you approve the important ones.
Choose the columns
We list which conversation, contact, tag and segment fields become columns, and which topics create, update or are ignored.
Approve access
For Intercom to Google Sheets, we connect the two systems carefully, keeping access to what the agreed route requires.
Agree tabs and headers
Tab layout, header names, column types and the key column are agreed in writing, then locked before the build.
Rehearse before launch
With Intercom to Google Sheets in place, the route is exercised end to end in a test Google Sheets, including the failures, before it touches real data.
Launch with notes
The route is enabled from a fixed point in time and the PDF records every setting we chose.
Review and adjust
Real traffic often shows edge cases; this step folds them into the rules and the notes.
07Turnaround
When each package goes live
Estimates run from approved access to handover, on the Intercom to Google Sheets route.
First Mile
4 to 7 business days
Full Route
7 to 11 business days
Long Watch
11 to 17 business days
08Before we start
Your part in the first week
Scoped Intercom access, approved by whoever administers it
Edit access to one Google Sheets spreadsheet, plus an Intercom admin who can approve our developer app
Intercom API details for the account we will connect to
Any conversation changes that must never reach Google Sheets
Approval to review a small set of recent Intercom records
Preferred language and tone for any messages the route sends
09Security and ownership
You keep control of Intercom and Google Sheets, we keep to the map
With Intercom to Google Sheets in place, we ask for the smallest access that makes the route work and record exactly what that is.
Standard access, standard behavior
We rely on the regular access each platform offers, never on a change to how Intercom or Google Sheets work internally.
Scoped, revocable access
Keys stay in your accounts, and their scope is listed for your auditors.
Sensitive values held back
Anything sensitive in Intercom is either excluded or transformed before it can reach Google Sheets.
Recovery without duplicates
Failed or unclear writes are recovered by matching on the Intercom conversation ID in a locked column plus the sheet and row it maps to, never by generating a new row.
Minimal logging
You can inspect exactly what is logged, and it contains no customer text.
Full handover
Your administrators receive a document they can follow without a briefing.
10In their words
What BoldBellows clients say
Verified reviews from operations and finance teams who trust BoldBellows to keep their data moving correctly.
AI Workflow Automation for Agencies
Running a digital agency with many clients was overwhelming. BoldBellows built one automation dashboard that tracks tasks, sends updates and creates client reports automatically.
Clients love the transparency and we love the time we get back. Productivity is up, and project delays have dropped to almost zero.
AI Data Entry & Reporting Automation
We used to spend hours collecting data and building weekly reports by hand. BoldBellows automated all of it.
The reports are clean, visual and easy to read, and our managers rely on them for quick decisions. Human error is gone and our numbers are more accurate across the board.
AI Lead Qualification & Sales Automation
Our sales team wasted hours chasing cold leads. BoldBellows built an AI lead-scoring system that reads behavior, email engagement and buying signals.
It filters out weak leads and sends personalized follow-ups automatically, so our team only talks to people who are ready to buy. Conversions rose 40% in the first month. It paid for itself straight away.
AI Video & Voice Automation
We publish product videos every week, and BoldBellows introduced us to AI video automation. The system writes the script, voices it and produces the finished video in minutes.
The quality is remarkable: professional voiceovers, clean visuals and smooth editing. Production time went from three days to under 30 minutes, and we scaled our video marketing without adding cost.
AI Email & Smart Inbox Management
Our inbox used to be chaos. BoldBellows built an AI email system that sorts messages, drafts replies and flags anything urgent.
It learns how we write and gets better every week. We reply faster and no longer miss important messages. It feels like having a personal assistant working around the clock.
AI Booking & Scheduling Automation
Our coaching business needed a better way to schedule. BoldBellows automated all of it: bookings, reminders, cancellations and follow-ups.
No-shows fell by 60% and clients enjoy how smooth it is. It feels personal, not robotic. One of the best upgrades we’ve made.
AI Translation & Localisation
When we expanded abroad we needed fast, accurate translations. BoldBellows built an AI translation system that turns our content into several languages instantly.
The translations read naturally and suit each culture. We now serve customers in five new countries without hiring translators. BoldBellows helped us go global.
AI HR & Recruitment Automation
Our HR team was drowning in applications. BoldBellows automated screening, skills-based filtering and interview scheduling.
It saves us hours every week and means we only interview qualified people. Hiring is now faster, better organized and more professional.
AI Accounting & Invoice Automation
BoldBellows automated our whole invoicing process: creating invoices, sending reminders and tracking payments.
Late payments dropped sharply, and our accounting team finally has time for strategy instead of repetitive admin. Worth every penny.
AI Chatbot & Customer Support
BoldBellows built an AI support chatbot for our online boutique, and it has changed how we run the business. We used to have two full-time staff answering the same questions all day. Now the AI handles order tracking, product recommendations and even refund requests on its own.
What surprised me most is how natural it sounds. Customers compliment the ‘agent’ without realizing it’s AI. Our support workload dropped by 75% and customer satisfaction went up dramatically.
AI Content & Social Media Automation
Our marketing agency couldn’t keep up with content. BoldBellows set up an AI content engine that writes blog posts and captions and even designs our social media creatives.
It spots trends and suggests topics for us, so we stay ahead of competitors. We now produce three times the content with the same team, and engagement has soared. They didn’t just automate our workflow, they lifted our whole brand.
AI E-commerce Listings Automation
BoldBellows automated our product listings. The AI writes descriptions, organizes photos and publishes listings across several marketplaces.
It even answers customer questions instantly. Our store looks more professional and sales have noticeably increased.
AI Customer Journey Automation
We wanted a smoother path from first contact to purchase. BoldBellows built an AI system that guides each customer there automatically.
It sends personalized messages, recommends products and follows up at just the right moment. Customer retention has improved dramatically.
AI Document & Contract Automation
Onboarding was slow because we wrote every contract by hand. BoldBellows automated the lot: contracts, welcome emails and client setup.
What took 48 hours now takes under 10 minutes, and clients regularly tell us how professional it feels.
AI Social Comment & DM Automation
We get thousands of comments and messages every week. BoldBellows built an AI system that replies instantly, filters spam and surfaces the important ones.
Engagement is up and our page looks active around the clock. It’s like having a full social media team that never stops.
AI CRM Automation
Our CRM was barely used because updating it by hand was tedious. BoldBellows automated data entry, tagging, segmentation and follow-ups.
Now the CRM is always up to date and our campaigns are far more accurate. It improved our whole sales pipeline.
AI Voice Assistant
BoldBellows built a custom AI voice assistant for our customer hotline. It answers questions, books appointments and handles simple requests.
Customers love how fast it is, and our call-centre workload dropped dramatically. One of the smartest upgrades we’ve made.
AI Automation Partner
BoldBellows is hands-down the best AI automation partner we’ve worked with. Their systems are fast, reliable and built around how our business actually works.
Every automation they’ve delivered, from customer service to content, runs flawlessly. We’ve saved time, cut costs and grown faster than we expected.
11FAQ
Intercom, Google Sheets and live lists: questions from managers and analysts
Quick answers, no sales language, and a route to ask more.
Is an Intercom to Google Sheets Zapier zap enough?
Where a row for every new conversation is enough, stay with a zap. The difference shows when you must update the same row when a conversation changes, keep tags and segments in readable columns and never write a duplicate. The connector carries the event; the build carries the decisions.
Can I sync Intercom conversations to Google Sheets without exports?
Each conversation event updates one row keyed on the conversation ID, so the sheet follows state, owner and tag changes without an export.
Can I export Intercom leads to a spreadsheet?
Yes. Leads and users go to separate tabs with their role, company and tags, and a lead who becomes a user is updated, not duplicated.
What about Intercom tags and segments?
Tags and segments are written as readable, comma-separated lists or as separate columns, whichever your filters need.
How do I connect Intercom to Google Sheets without a Zap?
You do not need one. The route listens to Intercom webhooks and writes only the mapped columns. A protected key column and a header check stop a stray edit from causing a duplicate or a misplaced write.
Will heavy traffic hit Sheets limits?
Writes are batched and paced inside the per-minute quotas, and a refused request is retried after the delay the API asks for.
Can history be loaded into the sheet?
Yes. Earlier conversations are pulled in resumable batches with Intercom's search endpoint, then matched by conversation ID, so nothing doubles.
Do I approve the Intercom mapping before you build?
Yes, in writing. The Intercom Google Sheets field mapping service yields a reviewed table of fields, formats and rules that you approve before launch.
Can you automate Intercom data to Google Sheets as a custom workflow?
Yes. Conditions such as region, product or threshold become a custom Intercom workflow for Google Sheets. We advise as an Intercom Google Sheets integration consultant would, from $415.
What if Google Sheets changes its rules in the Intercom to Google Sheets route?
Work after the review window is scoped afresh.
Next stepPut your Intercom conversations in a sheet that stays true
Give your team a spreadsheet that follows the inbox
That is enough to scope how we automate Intercom data to Google Sheets, priced from $415.
- From $415, paid once
- One row each
- Tags in columns
- No monthly fee from us
Edge cases beyond these packages are estimated separately, in writing.