Looping by Zapier + Slack + PostgreSQL Integrations

Zapier lets you send info between Looping by Zapier and Slack and PostgreSQL automatically—no code required. With 5,000+ supported apps, the possibilities are endless.

Choose a Trigger

Start here arrow pointing down

Choose an Action

Get Started for Free

Free forever for core features
14 day trial for premium features & apps

Do even more with Looping by Zapier + Slack + PostgreSQL

With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with Looping by Zapier, Slack, and PostgreSQL. And don’t forget that you can add more apps and actions to create complex workflows.

Supported triggers and actions

What does this mean?

- Help Warning
  WARNING: Looping by Zapier is an advanced feature currently in Beta. Learn how to create loops here and understand limitations here.
- Values to LoopRequired
  Type loop value name(s) in the field(s) on the left. Map Line Item value(s) to loop through on the right.
- Trim Whitespace
  Remove whitespace surrounding each individual value? Defaults to 'True'.
- Loop iteration counter start
  A counter value called 'loop_iteration' will be added to each iteration of the loop. Does not affect the data to loop through. Defaults to '1'.
- Maximum number of Loop iterations
  Set this value to limit the number of loops performed. Data in iterations past the limit will be ignored. A number higher than 500 will be reduced to 500. A number less than 1 will halt this step.
Action
Write
- Help Warning
  WARNING: Looping by Zapier is an advanced feature currently in Beta. Learn how to create loops here and understand limitations here.
- Values to LoopRequired
  Type loop value name(s) in the field(s) on the left. Map and/or type values separated by a delimiter (ex: ',') on the right.
- Text Delimiter
  Supports Special Characters. Defaults to ','
- Trim Whitespace
  Remove whitespace surrounding each individual value? Defaults to 'True'.
- Loop iteration counter start
  A counter value called 'loop_iteration' will be added to each iteration of the loop. Does not affect the data to loop through. Defaults to '1'.
- Maximum number of Loop iterations
  Set this value to limit the number of loops performed. Data in iterations past the limit will be ignored. A number higher than 500 will be reduced to 500. A number less than 1 will halt this step.
Action
Write
New Channel
Triggers whenever a new #channel is created.
Trigger
Instant
Try It
- Include Alias
  Choose yes to trigger when someone creates a new name for an existing emoji.
Trigger
Instant
Try It
- User Name
  Linked mentions of this user will trigger the zap. Make sure to specify a value for one or both of username or a highlight word. Specifying both a username and a highlight word means that both the linked username and word need to be included in a message to trigger the zap.
- Highlight Word
  Mentions of this word will trigger the zap. Case insensitive. Make sure to specify a value for one or both of username or a highlight word. Specifying both a username and a highlight word means that both the linked username and word need to be included in a message to trigger the zap.
- Trigger for Bot Messages?
  If no, only messages sent by users will trigger the Zap. If yes, messages sent by users and slackbots will trigger the Zap.
  Warning: Slackbots don't have profiles. If yes, don't depend on user profile information being present. Also, avoid Zap loops where Zaps trigger and post slackbot messages to the same channel!
Trigger
Instant
Try It

New Pushed Message
Triggers when you click the "Push to Zapier" button from a message in Slack.
Trigger
Instant
Try It
New Saved Message
Triggers when you save a message.
Trigger
Instant
Try It

- TextRequired
  The actual reminder text that should be sent to yourself or a user. To include URLs, Slack uses this syntax.
- Remind when?Required
  Slack parses natural language like "in 15 minutes" or "every Thursday". Times are relative to when the Zap actually runs.
- Remind who?
  Pick a user to remind. If you pick no one, you will be reminded.
Action
Write
- ChannelRequired
  Only channels you are a member of will appear in this list. If you can't find your channel, click the Load More button or switch to the Custom tab and enter the channel's ID. Once live, the trigger will work even if you are not a member of the channel.
- Message TextRequired
  Specify text of the message to send. Check out the formatting help doc for advanced options.
- Send as a bot?
  If you choose no, this message will appear to come from you. Direct messages are always sent by bots.
- Bot Name
  Specify the bot name which appears as a bold username above the message inside Slack. Defaults to Zapier. When using Schedule At, this field will be ignored by slack.
- Bot Icon
  Either an image url or an emoji available to your team (surrounded by :). For example, https://site.com/icon_256.png or :robot_face:. When using Schedule At, this field will be ignored by slack.
- Include a link to this Zap?
  If you choose yes, a link to this Zap will be added to the end of the message, making it easy for you and your team to edit the Zap with one click.
- Attach Image by URL
  If specified, this will upload the given image URL to Slack and attach it to the message separately.
- Auto-Expand Links?
  Should Slack try to automatically expand links in this message? For example: turn a YouTube link into a playable widget.
- Link Usernames and Channel Names?
  If no, any usernames and channels mentioned won't be linked (or mentioned). Also affects @channel and @group. Unfortunately, @here notifications cannot be sent by Zapier.
- Schedule At
  Schedule the message to be posted later. Cannot be more than 120 days in the future. If you do schedule a message, rather than post it immediately, this Zap step will not return a ts or permalink field. This option does not support Bot Name and Bot Icon customization and will default to Zapier as bot name and icon.
- File
  Include a file to send along with your message. NOTE: Bot names/icons cannot be customized when sending a File.
- Thread
  If you want this to be part of a thread, you'll need the timestamp (Ts) of the parent message. For example: 1345232312616.1231232.
  If you get the message from a trigger, select "use a custom value" from the dropdown and connect accordingly by selecting the Ts field.
  Otherwise, add a search step and fetch the message you want.
- Broadcast To Channel?
  If true, posts in the thread and channel. See here for more info. Ignored unless the message is part of a thread.
Action
Write
- Channel NameRequired
  Name for the channel to be created. Channel names are normalized by converting to lowercase, replacing any non-allowed characters with hyphens or underscore, and truncating to 80 characters.
Action
Write
- ChannelRequired
- TopicRequired
  Slack will auto-link @names and #channels where applicable.
Action
Write
- Status Text
  Leave empty to clear.
- Status Emoji
  Use any emoji that's available in your Slack team, with leading and trailing :.
  If emoji is blank when text isn't, :speech_balloon: is used by default. If both text and emoji are empty, your status will be cleared.
- Expiration Time
  Provide a specific date & time for this status to expire. Statuses will not expire by default.
  You can also specify a duration for this status by entering in a value like in 60 minutes, for example. Check out other ways you can use this field here.
Action
Write
- Search QueryRequired
  Search query to use for finding matching messages. See the Slack Search Documentation for more information on constructing a query.
- Sort By
  Sort messages by their match strength or by their date. Default is score.
- Sort Direction
  Sort matching messages in ascending or descending order. Default is descending.
Action
Search
- IDRequired
  Search is case-insensitive
- Return Raw Results?
  For most responses, we prettify the result we get from Slack. If we're missing a field you're expecting, set this to true
Action
Search
- UsernameRequired
  The leading @ is optional
- Return Raw Results?
  For most responses, we prettify the result we get from Slack. If we're missing a field you're expecting, set this to true
Action
Search
- Table/ViewRequired
  We expect at least one unique (and usually autoincrement) primary key column so we can deduplicate records properly! Otherwise we will make a best guess on a random column to use to deduplicate.
- Order By
  Highly recommended! Usually you want the results to be most recent first so we can skim off only new results, so choose something like date_created or your autoincrement id. Column names that contain a space must be enclosed within brackets [ ].
- Dedupe Key
  We default to what the primary key is on the table as the unique key to deduplicate on. If you prefer another field, select it here.
Trigger
Scheduled
Try It
New Table
Triggered when you add a new table.
Trigger
Scheduled
Try It
- TableRequired
Action
Write
- TableRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search

- Help Warning
  WARNING: Looping by Zapier is an advanced feature currently in Beta. Learn how to create loops here and understand limitations here.
- Loop iteration counter start
  A counter value called 'loop_iteration' will be added to each iteration of the loop. Does not affect the data to loop through. Defaults to '1'.
- Loop iteration counter end
  Set the iteration number to end the loop at here. Defaults to '1'. Cannot be less than Loop iteration counter start.
- Loop iteration counter increment amount
  Set the amount to increment the counter for each iteration of the loop. Defaults to '1'. Cannot be '0' or negative. Must be an whole number.
- Maximum number of Loop iterations
  Set this value to limit the number of loops performed. Data in iterations past the limit will be ignored. A number higher than 500 will be reduced to 500. A number less than 1 will halt this step.
Action
Write
- Trigger for Bot Messages?
  If no, only messages sent by users will trigger the Zap. If yes, messages sent by users and slackbots will trigger the Zap.
  Warning: Slackbots don't have profiles. If yes, don't depend on user profile information being present. Also, avoid Zap loops where Zaps trigger and post slackbot messages to the same channel!
Trigger
Instant
Try It
- ChannelRequired
  Only channels you are a member of will appear in this list. If you can't find your channel, click the Load More button or switch to the Custom tab and enter the channel's ID. Once live, the trigger will work even if you are not a member of the channel. Note: This trigger only supports attachment information for messages generated by bots. If you need to retrieve attachment information from non-bots, see this help document.
- Trigger for Bot Messages?
  If no, only messages sent by users will trigger the Zap. If yes, messages sent by users and slackbots will trigger the Zap.
  Warning: Slackbots don't have profiles. If yes, don't depend on user profile information being present. Also, avoid Zap loops where Zaps trigger and post slackbot messages to the same channel!
Trigger
Instant
Try It
- Channel
  Only channels you are a member of will appear in this list. If you can't find your channel, click the Load More button or switch to the Custom tab and enter the channel's ID. Once live, the trigger will work even if you are not a member of the channel.
- User Name
  Trigger on files created by a single user.
- Shared
  Trigger when files are shared with you. Please note that this will trigger on created files as well.
Trigger
Instant
Try It
- ChannelRequired
  Only channels you are a member of will appear in this list. If you can't find your channel, click the Load More button or switch to the Custom tab and enter the channel's ID. Once live, the trigger will work even if you are not a member of the channel.
- Trigger for Bot Messages?
  If no, only messages sent by users will trigger the Zap. If yes, messages sent by users and slackbots will trigger the Zap.
  Warning: Slackbots don't have profiles. If yes, don't depend on user profile information being present. Also, avoid Zap loops where Zaps trigger and post slackbot messages to the same channel!
Trigger
Instant
Try It
- Reaction
  Only triggers when this reaction is added to a message. Use the dropdown to select one of your team's custom emoji or select Use a Custom Value and enter the name of a standard emoji. Use this cheat sheet for reference and be sure not to include the colons. Note that you cannot use an emoji's alias in this field.
- Channel
  Only triggers on reactions added on messages in this public channel. Only channels you are a member of will appear in this list. If you can't find your channel, click the Load More button or switch to the Custom tab and enter the channel's ID. Once live, the trigger will work even if you are not a member of the channel.
- User
  Only triggers on reactions added by this user.
Trigger
Instant
Try It
New User
Triggers when a new Slack user is created / first joins your org.
Trigger
Instant
Try It
- ChannelRequired
- UsersRequired
Action
Write
- Send Multi Message
  Toggle to send to multiple users.
- Message TextRequired
  Specify text of the message to send. Check out the formatting help doc for advanced options.
- Send as a bot?
  If you choose no, this message will appear to come from you. Direct messages are always sent by bots.
- Bot Name
  Specify the bot name which appears as a bold username above the message inside Slack. Defaults to Zapier. When using Schedule At, this field will be ignored by slack.
- Bot Icon
  Either an image url or an emoji available to your team (surrounded by :). For example, https://site.com/icon_256.png or :robot_face:. When using Schedule At, this field will be ignored by slack.
- Include a link to this Zap?
  If you choose yes, a link to this Zap will be added to the end of the message, making it easy for you and your team to edit the Zap with one click.
- Attach Image by URL
  If specified, this will upload the given image URL to Slack and attach it to the message separately.
- Auto-Expand Links?
  Should Slack try to automatically expand links in this message? For example: turn a YouTube link into a playable widget.
- Link Usernames and Channel Names?
  If no, any usernames and channels mentioned won't be linked (or mentioned). Also affects @channel and @group. Unfortunately, @here notifications cannot be sent by Zapier.
- Schedule At
  Schedule the message to be posted later. Cannot be more than 120 days in the future. If you do schedule a message, rather than post it immediately, this Zap step will not return a ts or permalink field. This option does not support Bot Name and Bot Icon customization and will default to Zapier as bot name and icon.
Action
Write
- ChannelRequired
  Only channels you are a member of will appear in this list. If you can't find your channel, click the Load More button or switch to the Custom tab and enter the channel's ID. Once live, the trigger will work even if you are not a member of the channel.
- Message TextRequired
  Specify text of the message to send. Check out the formatting help doc for advanced options.
- Send as a bot?
  If you choose no, this message will appear to come from you. Direct messages are always sent by bots.
- Bot Name
  Specify the bot name which appears as a bold username above the message inside Slack. Defaults to Zapier. When using Schedule At, this field will be ignored by slack.
- Bot Icon
  Either an image url or an emoji available to your team (surrounded by :). For example, https://site.com/icon_256.png or :robot_face:. When using Schedule At, this field will be ignored by slack.
- Include a link to this Zap?
  If you choose yes, a link to this Zap will be added to the end of the message, making it easy for you and your team to edit the Zap with one click.
- Attach Image by URL
  If specified, this will upload the given image URL to Slack and attach it to the message separately.
- Auto-Expand Links?
  Should Slack try to automatically expand links in this message? For example: turn a YouTube link into a playable widget.
- Link Usernames and Channel Names?
  If no, any usernames and channels mentioned won't be linked (or mentioned). Also affects @channel and @group. Unfortunately, @here notifications cannot be sent by Zapier.
- Schedule At
  Schedule the message to be posted later. Cannot be more than 120 days in the future. If you do schedule a message, rather than post it immediately, this Zap step will not return a ts or permalink field. This option does not support Bot Name and Bot Icon customization and will default to Zapier as bot name and icon.
- File
  Include a file to send along with your message. NOTE: Bot names/icons cannot be customized when sending a File.
- Thread
  If you want this to be part of a thread, you'll need the timestamp (Ts) of the parent message. For example: 1345232312616.1231232.
  If you get the message from a trigger, select "use a custom value" from the dropdown and connect accordingly by selecting the Ts field.
  Otherwise, add a search step and fetch the message you want.
- Broadcast To Channel?
  If true, posts in the thread and channel. See here for more info. Ignored unless the message is part of a thread.
Action
Write
- First Name
  Fields left blank will be ignored.
- Last Name
  Fields left blank will be ignored.
- Title
  Fields left blank will be ignored.
- Email
  Changing a user's email address will send an email to both the old and new addresses, and also post a slackbot to the user informing them of the change.
- User
  Update selected values on this user's profile. This argument may only be specified by team admins on paid teams. Defaults to your status, when blank.
Action
Write
- Raw Request User Info
  Note: Zapier's Slack app supports a limited set of OAuth scopes/permissions, thus many of Slack's API endpoints aren't currently feasible.
- Api Docs Info
  API docs for Slack are located here https://api.slack.com/methods
- HTTP MethodRequired
- URLRequired
  Requests can only be made to domains associated by this application.
- Query String Parameters
  These params will be URL-encoded and appended to the URL when making the request.
- Headers
  Authentication headers are included automatically
- Additional Request Headers
  Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
- Body
  Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example, {"foo": "bar"} is perfectly valid.
Action
Write
- EmailRequired
  Search is case-insensitive
- Return Raw Results?
  For most responses, we prettify the result we get from Slack. If we're missing a field you're expecting, set this to true
Action
Search
- Full NameRequired
  We search the normalized name, so don't worry about accents
- Return Raw Results?
  For most responses, we prettify the result we get from Slack. If we're missing a field you're expecting, set this to true
Action
Search
- Table/ViewRequired
Trigger
Scheduled
Try It
- QueryRequired
  Query results must have a unique id field so we can deduplicate records properly! Otherwise we will make a best guess. You must also include desired ordering and limiting in the query.
  Note: This query must run in less than 30 seconds and it is recommended that you return no more than 5,000 rows
Trigger
Scheduled
Try It
- Table/ViewRequired
- Primary KeyRequired
  Usually something auto-incremented like id. Must be unique. Column names that contain a space must be enclosed within brackets [ ].
- Order ByRequired
  Usually something like date_updated or last_modified. This should ideally be a datetime column that is set to the current datetime whenever a row is updated.
- Trigger Column
  Trigger on changes to cells in this column only. Leave blank if you want to trigger on changes to cells in all columns.
Trigger
Scheduled
Try It
- TableRequired
- ID ColumnRequired
Action
Write
- QueryRequired
  You should include desired ordering and limiting (usually to 1 record) in the query.
  This query must run in less than ~30 seconds.
Action
Search

Top companies trust Zapier to automate work and free up time

Connect your apps and automate workflows

Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.

By signing up, you agree to Zapier's terms of service and privacy policy.

How to connect Looping by Zapier + Slack + PostgreSQL

Step 1: Authenticate Looping by Zapier, Slack, and PostgreSQL.
30 seconds
Step 2: Pick one of the apps as a trigger, which will kick off your automation.
15 seconds
Step 3: Choose a resulting action from the other app.
15 seconds
Step 4: Select the data you want to send from one app to the other.
2 minutes
That’s it! More time to work on other things.

Connect apps

Connect Looping by Zapier + Slack + PostgreSQL

About Looping by Zapier

Looping by Zapier is a helper app to repeat Action(s) in you Zaps a variable number of times for sets of values.

Learn more

Related categories

About Slack

Slack is a platform for team communication: everything in one place, instantly searchable, available wherever you go. Offering instant messaging, document sharing and knowledge search for modern teams.

Learn more

Related categories

Team Chat

Similar apps

Flowdock

Team Chat

Chatwork

Team Chat

Microsoft Teams

Microsoft, Team Chat

About PostgreSQL

PostgreSQL is a powerful, open-source database engine with a uniquely advanced query optimizer and dozens of built in features, making it an easy choice for production databases.

Learn more

Related categories

Databases

Similar apps

MySQL

Databases

SQL Server

Databases

Amazon Relational Database Services (RDS)

Amazon, Databases

Get started for free

You can't add more hours to the day. Zapier is the next best thing.

By signing up, you agree to Zapier's terms of service and privacy policy.

Looping by Zapier + Slack + PostgreSQL Integrations

Looping by Zapier + Slack + PostgreSQL Integrations

Do even more with Looping by Zapier + Slack + PostgreSQL

Create Loop From Line Items

Help Warning

Trim Whitespace

Loop iteration counter start

Maximum number of Loop iterations

Create Loop From Text

Help Warning

Values to LoopRequired

Text Delimiter

Trim Whitespace

Loop iteration counter start

Maximum number of Loop iterations

New Channel

New Team Custom Emoji

Include Alias

New Mention

User Name

Highlight Word

Trigger for Bot Messages?

New Pushed Message

New Saved Message

Add Reminder

TextRequired

Remind when?Required

Remind who?

Send Channel Message

ChannelRequired

Message TextRequired

Send as a bot?

Bot Name

Bot Icon

Include a link to this Zap?

Attach Image by URL

Auto-Expand Links?

Link Usernames and Channel Names?

Schedule At

File

Thread

Broadcast To Channel?

Create Channel

Channel NameRequired

Set Channel Topic

ChannelRequired

TopicRequired

Set Status

Status Text

Status Emoji

Expiration Time

Find Message

Search QueryRequired

Sort By

Sort Direction

Find User by ID

IDRequired

Return Raw Results?

Find User by Username

UsernameRequired

Return Raw Results?

New Row

Table/ViewRequired

Order By

Dedupe Key

New Table

New Row

TableRequired

Find Row

TableRequired

Lookup ColumnRequired

Lookup ValueRequired

Create Loop From Numbers

Help Warning

Loop iteration counter start

Loop iteration counter end

Loop iteration counter increment amount

Maximum number of Loop iterations

New Public Message Posted Anywhere

Trigger for Bot Messages?