Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • 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