Skip to main content
  • Home
  • Get Help
  • How Do I
  • I want to create a Zap that gets channel names from a spreadsheet and creates channels in Slack

1.Get multiple channel names in a spreadsheet.

ex. channel1,channel2,channel3….

 

2.Split text

channel1

channel2

channel3

 

There are multiple channels present in the original data, but since I don’t know the exact number, I considered creating all the channels through a loop process. However, my approach seems to make things very complicated.

Is there an easier way to handle this?

 

The original data is in the state shown in the attachment, and it is possible to add more data.

 

Hi @Kato_vi 

You’ll want to add a column in column B to use as a lookup.

e.g. USED = NO

 

@Kato_vi 

Try these Zap steps:

  1. Trigger: UP TO YOU
    1. Options
      1. Schedule
      2. Webhook - Catch Hook
      3. OTHER
  2. Action; GShees - Lookup Rows
    1. Returns multiple rows as line items
  3. Action: Filter
    1. Check there are rows to process
  4. Action: Looping - Create Loop from Line Items
    1. Map the Row ID from the GSheet step
    2. Map Column A from the GSheet step
  5. Action: Slack - Create Channel
    1. Map the Channel name from the Looping step
  6. Action: GSheets - Update Row
    1. Map the Row ID from the Looping step
    2. Set USED = YES

Hi there @Kato_vi 👋

Just wanted to check in here to find out how you got on with this. Did you manage to get things solved using Troy’s suggestion here?

If you’re still stuck or need help with anything else just let us know and we’ll be happy to help further! 🙂

Terms & Conditions