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.

Question

I want to create a Zap that gets channel names from a spreadsheet and creates channels in Slack

  • September 6, 2024
  • 3 replies
  • 13 views
K

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.

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • 34032 replies
  • September 6, 2024

Hi @Kato_vi 

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

e.g. USED = NO

 

⚡ Troy Tessalone - AutomationAce.com | Platinum Authorized Zapier Solution Partner | #1 Zapier Community Contributor
Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • 34032 replies
  • September 6, 2024

@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
⚡ Troy Tessalone - AutomationAce.com | Platinum Authorized Zapier Solution Partner | #1 Zapier Community Contributor
SamB
Community Manager
Forum|alt.badge.img+11
  • SamBCommunity Manager
  • Community Manager
  • 9676 replies
  • September 18, 2024

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 & ConditionsAccessibility statement