How to insert multiple Excel rows from a single Slack message using Zapier?

Other Questions Zapier
1

Hey everyone! I’m trying to figure out how to use Zapier to add several rows of data to an Excel file from just one Slack message. Right now, I can only get one row to work.

My Slack message looks like this:

Client: ABC
Platform: IX
Handover Type: Proactive
Project ID: 1234567
Status: FL
RL: N/A
Description: Some text here.
It might have multiple lines.

Client: XYZ
Platform: IX
Handover Type: Reactive
Project ID: 12345678
Status: FL
RL: N/A
Description: More text here.
Also with multiple lines.

I tried using a Python script in Zapier, but it only grabs one row. Can anyone help me out? I’m not a coder, so simple explanations would be great. Thanks!

2

hey runningriver, i had a similar issue. try using zapier’s ‘formatter’ step to split ur message into separate items. then use a ‘create spreadsheet row’ action for each item. might need multiple zaps or loops. good luck!

3

I have dealt with this issue before. In my experience, the solution was to add a code step in Zapier using Python to parse the Slack message. You can split the message by a unique marker like “Client:” to separate the data for each row. Once you have separated the sections, extract the required fields from each part and then group them into a structure that the Excel action can understand. If handling code isn’t your strong suit, you might consider looking into community scripts or working with someone experienced in automating tasks. Testing the setup in a controlled environment is a good practice too.

4

I’ve tackled this problem before, and here’s what worked for me: Use Zapier’s ‘Code’ step with JavaScript. Split your Slack message by ‘Client:’ to get individual entries. Then, parse each entry to extract the data fields. Create an array of objects, each representing a row. Finally, use Zapier’s ‘Create Multiple Spreadsheet Rows’ action to add all rows at once.

This approach is more efficient than creating separate zaps or using loops. It handles multiple entries in one go. You’ll need some basic coding knowledge, but it’s not too complex. If you’re stuck, Zapier’s community forums are a great resource for sample scripts.

Remember to thoroughly test your zap with various message formats to ensure it’s robust. Good luck with your automation!