Way to automate sending Excel screenshot to WhatsApp groups

Hi everyone,

I have a repetitive workflow at my job and I'm trying to find a way to automate or simplify it.

Here’s the situation:

Every day I create a fleet dispatch plan in Excel. The spreadsheet contains several rows with dispatches for different fleets. Each fleet has its own WhatsApp group (whatsapp web), and I need to send the information relevant to that fleet to its group.

My current manual process is:

1. Filter the Excel table by a specific fleet name.
2. This shows only the rows related to that fleet.
3. I take a screenshot (ctrl+c) of those rows.
4. I paste the screenshot into the corresponding WhatsApp group.
5. Then I type "Segue D1" (basically “Here is the D1 plan”).
6. After that, I copy 3 columns with dispatch codes from the filtered rows and paste them as text in the chat (even though the same data is already visible in the screenshot).

So essentially every time I need to:

• filter the table
• capture the filtered rows as an image
• extract some columns as text
• send both to a WhatsApp group

I do this multiple times per day for different fleets.

What I’m looking for:

Ideally I’d like a way to automate part or all of this, for example:

• automatically generating the text list of codes from the filtered rows
• exporting the filtered table as an image
• making the workflow faster so I don’t have to manually repeat these steps

Exemple