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.

I have a zap use case where I need one action that can be done on 50 states regardless of the state, but then send slack message to the specific state channel which right now is requiring that I make 50 zap flows because paths only allows for 3 max. This is killing my total zap allotment each month and becoming costly

Anyone have ideas on how I could create an action that would send to the proper slack channel based on which state the previous action was sent in?

@chrisfinck You could do this a lot more efficiently. Try using an Airtable or Google Sheet with values for each state. It would look like:

→ Get the state from somewhere

→ Lookup the state in Airtable/Sheet

→ Extract the channel from that record

→ Send a message to the extracted channel

 

Hope this helps you. Let me know if I can help you otherwise.
~Bjorn

@chrisfinck You could do this a lot more efficiently. Try using an Airtable or Google Sheet with values for each state. It would look like:

→ Get the state from somewhere

→ Lookup the state in Airtable/Sheet

→ Extract the channel from that record

→ Send a message to the extracted channel

 

Hope this helps you. Let me know if I can help you otherwise.
~Bjorn

Ok I see on the slack send channel message I can use the custom tab to dynamically select the channel, but does that mean I need to create an airtable that has the city/state and specific slack channel ID to send to? 

@chrisfinck You could do this a lot more efficiently. Try using an Airtable or Google Sheet with values for each state. It would look like:

→ Get the state from somewhere

→ Lookup the state in Airtable/Sheet

→ Extract the channel from that record

→ Send a message to the extracted channel

 

Hope this helps you. Let me know if I can help you otherwise.
~Bjorn

Ok I see on the slack send channel message I can use the custom tab to dynamically select the channel, but does that mean I need to create an airtable that has the city/state and specific slack channel ID to send to? 

Figured it out, I made a new column in airtable that did 50 if statements to match against the records city/state and then spit out the specific slack channel ID I needed.

@chrisfinck You could do this a lot more efficiently. Try using an Airtable or Google Sheet with values for each state. It would look like:

→ Get the state from somewhere

→ Lookup the state in Airtable/Sheet

→ Extract the channel from that record

→ Send a message to the extracted channel

 

Hope this helps you. Let me know if I can help you otherwise.
~Bjorn

Ok I see on the slack send channel message I can use the custom tab to dynamically select the channel, but does that mean I need to create an airtable that has the city/state and specific slack channel ID to send to? 

Figured it out, I made a new column in airtable that did 50 if statements to match against the records city/state and then spit out the specific slack channel ID I needed.

Exactly what I meant! Good to see you got it solved ;)

@chrisfinck - another way you could try (which probably would require one less step) is through a Zapier Lookup Table:

Your key would be the states and the value would be the slack channel

 

@laurie - would you know if there is a max amount of keys for a lookup table? 

@chrisfinck - another way you could try (which probably would require one less step) is through a Zapier Lookup Table:

Your key would be the states and the value would be the slack channel

 

@laurie - would you know if there is a max amount of keys for a lookup table? 

I like this method because I would not have to create new airtables, but I cannot find Utilities or Lookup Table as an action, has it been rebranded as Storage?

@chrisfinck, it’s part of the formatter:

 

@MarijnVerdult  There isn’t an official maximum number of keys, but I find that anything over 20 tends to be a little harder to maintain. However, you can fake a lookup table with Google Sheets. If you set column A to be your ‘key’ column and column B to be your ‘value’ column and use a Lookup Spreadsheet Row action instead of a Formatter step, it will work the exact same way. That would also make it a little easier to import large amounts of text so you could go even higher than 50 if needed.

 

@chrisfinck This would let your workflow work a bit better - so your column A in the Google Sheet would be the name of the state coming from your trigger step and column B would be the corresponding channel for that state. The lookup step would match the state name with the state channel, and you’d output that into your Slack step.

@MarijnVerdult  There isn’t an official maximum number of keys, but I find that anything over 20 tends to be a little harder to maintain. However, you can fake a lookup table with Google Sheets. If you set column A to be your ‘key’ column and column B to be your ‘value’ column and use a Lookup Spreadsheet Row action instead of a Formatter step, it will work the exact same way. That would also make it a little easier to import large amounts of text so you could go even higher than 50 if needed.

 

@chrisfinck This would let your workflow work a bit better - so your column A in the Google Sheet would be the name of the state coming from your trigger step and column B would be the corresponding channel for that state. The lookup step would match the state name with the state channel, and you’d output that into your Slack step.

Thanks im already doing that same concept in airtable so i will stick with it as currently works :) 

Terms & Conditions