Hi there 
I was wondering if there was a way to export all the received and sent whatsapp texts to a Google Sheets. I openned a ticket with the Hubspot team and they shared this link with me: Conversations inbox and messages APIs (BETA) (hubspot.com) but I couldn’t run it in Postman and don’t really have enough skills to create a API request on my own.
We need to export all the texts from a specific inbox and a specific channel within this inbox.
Thanks in advance!
@VLeccioli - I have not worked with Whatsapp inbox messages, but have had quite a few opportunities to wrestle with Conversations workflows and custom coded steps that pick apart the inbound messages for various purposes.
In this case - if you don’t mind setting up the code to extract the contents of a message body, it should be possible to feed it to the (very basic, but free) Google Sheets integration to be found in the Marketplace. That integration provides a workflow step that creates a new spreadsheet row for each invocation.
What I would caution is that, per my work, the structure of conversations data can only be determined by trial and error so it’s a bit of an iterative process.
Good luck!
Steve
Hi @VLeccioli , I recently put together a proof of concept to export Inbox conversations to CSV. You’re welcome to try it out and see if it solves your needs. It’s free and just saves the data to CSV.
I’m trying to gather feedback on if it’s useful or how it could be improved. Feel free to reach out if you have any.
Cheers,
Ken Fischer