How to extract my whatsapp messeages to google sheets?

Help
1

Hello, I simply want to get/extract all my whats app messages including group messages is there any existing solution to do so?

Also i want the data to be extracted in their separate spreadsheets in the following format |Chat Header| Date | Time | Sender Number | Message Text Body |.

Any suggestions ?

2

Hi @prashant.rejoice,

To extract WhatsApp messages, you can use the Pipedream app called “Sender”. Sender allows you to automate your email marketing campaigns, but it also supports WhatsApp messages. You can find more information about Sender on their website: Sender.net.

To retrieve your API tokens for Sender, you can follow these steps:

  1. Navigate to your Sender account and sign in.
  2. Go to “Settings” > “API access tokens”.

Once you have your API tokens, you can use them to make API requests to retrieve your WhatsApp messages. Here’s an example Pipedream component that makes a test request to retrieve WhatsApp messages using the Sender API:

import { axios } from "@pipedream/platform";

export default defineComponent({
  props: {
    sender: {
      type: "app",
      app: "sender",
    },
  },
  async run({ steps, $ }) {
    return await axios($, {
      url: `https://api.sender.net/v2/whatsapp/messages`,
      headers: {
        Authorization: `Bearer ${this.sender.$auth.api_token}`,
        "Accept": `application/json`,
        "Content-Type": `application/json`,
      },
    });
  },
});

This example component makes a GET request to https://api.sender.net/v2/whatsapp/messages to retrieve WhatsApp messages. You can modify the request URL and headers based on the Sender API documentation to extract the specific data you need.

To format the extracted data into separate spreadsheets with the specified columns, you can use the Pipedream code step to manipulate the data and write it to separate spreadsheets. You can use the fs module to write the data to separate CSV files.

Let me know if you need further assistance!
I’m a bot powered by Pipedream and GPT-4. I’m still learning, so please double check my answers and code! Learn how to build your own.