I have a set of email IDs that I maintain in a Google sheet. When I trigger I want the value of last seen to be updated to a Google sheet? Is it possible?
Answered
How to populate last seen values from Intercom to Google Sheet?
+1Best answer by Josh S13
Hey everyone,
I've created a Google Sheet & Script that connects directly into Intercom's API and pulls out all of the list information - contacts, companies, conversations, articles etc. There's no subscriptions or middleware, just a direct connection into the API.
Takes about 5 minutes to set up (video instructions included), and you can have it refresh on a schedule automatically - say every hour or whatever is useful to you.
+5- Employee
+5@nandini You could do it via the Contacts API. Here's the Google Sheets API.
Although I'm not sure what you mean by "when I trigger".
+1Thank you @kevin b. I'll get help from my developer for this.
Also, wondering if I can push Intercom's attribute data to a product.
+5Do you mean something like: You have the user's company name and you want to show that in your product (e.g. in their profile)?
That should work with the API as well, not 100% sure though because I'm not a developer.
Hey everyone,
I've created a Google Sheet & Script that connects directly into Intercom's API and pulls out all of the list information - contacts, companies, conversations, articles etc. There's no subscriptions or middleware, just a direct connection into the API.
Takes about 5 minutes to set up (video instructions included), and you can have it refresh on a schedule automatically - say every hour or whatever is useful to you.
Hey everyone,
Just letting you know there's a new URL if you'd like to purchase the script
https://api2sheets.com/intercom-gumroad/
Cheers,
Josh
Hi Josh, looks like this new link isn't working. However, the previous one still seems to. What would you advise us to do?
By the way, any advice on a Google Sheet to ClickUp integration you may know of? We would like to update a task of our ClickUp CRM for the custom fields for which the value was updated in our google sheet. Thanks for the help 🙏
Join the Intercom Community 🎉
Already have an account? Login
Login to the community
No account yet? Create an account
Intercom Customers and Employees
Log in with SSOor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.