How do I create a Zap to pull a structured Slack message and put it in an Excel document in tabular format

Hi there @RahulN,

Welcome to the Community! 🎉

If the message format is consistent, you can use Formatter by Zapier - Split Text to achieve your workflow. Here’s how:

(view larger)

Hopefully, this helps.

Hey @RahulN , this is a great usecase. 

I would agree with @ken.a if you’re able to use the zapier formatter, you should be able to parse and split the message and use it to populate in a spreadsheet. 

If you’re good with little bit of coding, you may use such a code to split it in an array and potentially use it in the next step to simply populate that in the sheet. Check this out 

Hi @zaki_readylogic, Please ignore the above. 

I have been able to figure out how to run python code in a Zap.

This is the code I am running at the moment.

# Get the message from the input data
message = input_data["Message"]

# Split the message into lines
lines = message.split("\n")

# Initialize an empty dictionary to store the data
data = {}

# Loop through each line in the lines list
for line in lines:
    # Ignore blank lines
    if line.strip() == "":
        continue

    # Split the line into key and value at the first occurrence of ":"
    key, value = line.split(":", 1)
    # Strip any leading or trailing spaces from the key and value
    key = key.strip()
    value = value.strip()

    # Check if the key is "Description"
    if key == "Description":
        # If the key is "Description", check if there is already a value
        if "Description" in data:
            # If there is already a value, append the current line to the existing value
            data["Description"] += "\n" + value
        else:
            # If there is no existing value, set the current line as the value
            data["Description"] = value
    else:
        # Add the key-value pair to the data dictionary
        data[key] = value

# Initialize an empty list to store the output
output = []

# Append the data dictionary to the output list
output.append(data)

However, the issue now I am facing is that the output still gets 1 row instead multiple. If you can help point me in the right direction again.

Thanks for your support till now@ken.a ! I will take a look at the options you suggested.