SQL Server + Asana + Schedule by Zapier Integrations

How to connect SQL Server + Asana + Schedule by Zapier

Zapier lets you send info between SQL Server and Asana and Schedule by Zapier automatically—no code required. With 5,000+ supported apps, the possibilities are endless.

Choose a Trigger

Start here arrow pointing down

Choose an Action

Connect Apps

Connect My Apps

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

Do even more with SQL Server + Asana + Schedule by Zapier

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 SQL Server, Asana, and Schedule by Zapier. And don’t forget that you can add more apps and actions to create complex workflows.

Supported triggers and actions

What does this mean?

- 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

- Workspace / Organization
  Specify which workspace/organization.
Trigger
Scheduled
Try It
- ProjectRequired
- Workspace
  You may have to select a workspace if you get errors when loading Projects.
Trigger
Scheduled
Try It

- WorkspaceRequired
- ProjectRequired
Trigger
Instant
Try It
- Workspace
  You may have to select a workspace if you get errors when loading Tags below.
- TagRequired
Trigger
Scheduled
Try It
- WorkspaceRequired
- ProjectRequired
Trigger
Instant
Try It
New Workspace/Organization
Triggered when you add a new workspace/organization.
Trigger
Scheduled
Try It
- Helptext
  Please specify a project, tag, or workspace of the task that you are duplicating.
- Workspace
- Project
- Tag
- NameRequired
  The name of the new task.
- Task Fields
  One or more fields to be included in the duplicated task
Action
Write
- Workspace / OrganizationRequired
- ProjectRequired
- Section NameRequired
- Section to Insert After
  An existing section in the project after which the new section should be inserted. This field cannot be used in combination with "Section to Insert Before." Please use one or the other.
- Section to Insert Before
  An existing section in the project before which the new section should be inserted. This field cannot be used in combination with "Section to Insert After." Please use one or the other.
Action
Write
- WorkspaceRequired
- Team
  If you choose an Organization, you must specify a team. A team is used to group related projects and people together.
- NameRequired
- NotesRequired
Action
Write
- Workspace / OrganizationRequired
- Project
- Section
  Add the task to this Section within the Project. This can only be used when one Project is selected above.
- Name
- Description
  You can format the description using markdown syntax: # Heading 1 ## Heading 2 **bold text** *italicized text* ~~strikethrough~~ > blockquote Ordered List 1. First item 2. Second item 3. Third item Unordered List - First item - Second item - Third item Code: `code` Link: [title](https://www.example.com) Note: Only the above syntax items will generate rich text in a task description.
- Send as Plain Text
  Default false. If you have issues with XML errors, set this to true to resolve those.
- Due On
  You can use human readable dates like: "tomorrow" or "next week Tuesday". Cannot be used with Due At. Ignores time.
- Due At
  You can use human readable dates like: "tomorrow" or "next week Tuesday". Cannot be used with Due On. Considers time.
- Assignee
- Assignee Status
  Can only be set if the Assignee is also set.
- Followers
- Hearted
- Tag
Action
Write
- TaskRequired
  Either search for an existing task, or "Use a Custom Value" and select the "Task ID" if the task was created by a previous step in this Zap.
- Task Completed?
- Name
- Notes
- Due On
  Cannot be used if Due At field is filled in.
- Due At
  Cannot be used if Due On field is filled in.
- Assignee
- Assignee Status
  Can only be set if the Assignee is also set.
- Followers
- Hearted
- Tag
Action
Write
- Api Docs Info
  API docs for Asana are located here https://asana.com/developers/api-reference/
- 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
- WorkspaceRequired
- ProjectRequired
  The existing project that contains the task to be found.
- Section NameRequired
  The name of the section to find (exact match first, fuzzy match second).
Action
Search
- Task IDRequired
  This is the last, long number in the address bar when you view a Task or in the Task Link you can copy.
Action
Search
- NameRequired
  The name of the project to find (exact match first, fuzzy match second).
- WorkspaceRequired
- Team
  If you choose an Organization, you must specify a team. A team is used to group related projects and people together.
- NotesRequired
Action
Search or write
- Workspace / OrganizationRequired
- ProjectRequired
  Specify one or more projects to search for an existing task.
- NameRequired
  The name of the task to find (exact match first, fuzzy match second).
- Section
  Add the task to this Section within the Project. This can only be used when one Project is selected above.
- Description
  You can format the description using markdown syntax: # Heading 1 ## Heading 2 **bold text** *italicized text* ~~strikethrough~~ > blockquote Ordered List 1. First item 2. Second item 3. Third item Unordered List - First item - Second item - Third item Code: `code` Link: [title](https://www.example.com) Note: Only the above syntax items will generate rich text in a task description.
- Send as Plain Text
  Default false. If you have issues with XML errors, set this to true to resolve those.
- Due On
  You can use human readable dates like: "tomorrow" or "next week Tuesday". Cannot be used with Due At. Ignores time.
- Due At
  You can use human readable dates like: "tomorrow" or "next week Tuesday". Cannot be used with Due On. Considers time.
- Assignee
- Assignee Status
  Can only be set if the Assignee is also set.
- Followers
- Hearted
- Tag
Action
Search or write
- Trigger on weekends?
  Should this Zap trigger on Saturday and Sunday?
- Time of DayRequired
  Triggers relative to your timezone settings and defaults to UTC (GMT+00:00) if no preference is set. Note: You can also specify a time with a Custom Value in the formats "hh:mm aa", "hh:mm", or "hhhh" (e.g. "2:30pm", "14:30", or "1430").
Trigger
Instant
Try It
- Day of the MonthRequired
  Day of month this schedule should trigger on.
- Time of DayRequired
  Triggers relative to your timezone settings and defaults to UTC (GMT+00:00) if no preference is set. Note: You can also specify a time with a Custom Value in the formats "hh:mm aa", "hh:mm", or "hhhh" (e.g. "2:30pm", "14:30", or "1430").
Trigger
Instant
Try It

- 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
- Workspace
  Required if no project is selected below. May be needed to avoid errors when selecting a Project below.
- Project
  Required if on the Asana Free plan.
Trigger
Scheduled
Try It
- ProjectRequired
  Specify which project to watch for new stories.
- Task
  Specify which task. If blank, defaults to stories on the project itself only, but NOT all stories on all tasks.
- Workspace
Trigger
Scheduled
Try It
New Tag Created
Triggered when you create a new tag.
Trigger
Scheduled
Try It
- WorkspaceRequired
- ProjectRequired
Trigger
Instant
Try It
- Workspace / OrganizationRequired
  Specify which workspace/organization.
Trigger
Scheduled
Try It
- Workspace / Organization
  Specify which workspace/organization.
Trigger
Scheduled
Try It
- ProjectRequired
- TaskRequired
  You need to choose a project before you can choose a task.
- FileRequired
Action
Write
- Workspace or Organization
- Project TemplateRequired
  You must have a custom template saved in a Workspace or Team. https://asana.com/guide/help/premium/custom-templates
- Project NameRequired
- Make Public?Required
Action
Write
- Parent TaskRequired
  Either search for an existing task, or "Use a Custom Value" and select the "Task ID" if the task was created by a previous step in this Zap.
- Name
- Notes
- Due On
  You can use human readable dates like: "tomorrow" or "next week Tuesday". Cannot be used with Due At. Ignores time.
- Due At
  You can use human readable dates like: "tomorrow" or "next week Tuesday". Cannot be used with Due On. Considers time.
- Assignee
- Assignee Status
- Followers
- Hearted
- Tag
Action
Write
- WorkspaceRequired
- ProjectRequired
  Specify which project.
- TaskRequired
  Specify which task.
- TextRequired
  Specify your text.
Action
Write
- Workspace
  Workspace must be specified to get dropdown selections in the Task, Project and Section list below. Not required if you will be using custom values to set the fields below.
- TaskRequired
  Task to be moved to a project's section. The dropdown here will only include tasks that are assigned to you, but you can use this action with any task in the workspace selected above by specifying a "Custom Value" for this task field..
- ProjectRequired
  Project to which to move the task. Tasks can only be moved to projects in the same workspace..
- Section
  Section to which to move the task. Task will be moved to the bottom of the section. If section is not specified for a list-type project, the task will be moved to the no section area of the project. If the section is not specified for a board-type project, the task will be added to the first column of the board.
Action
Write
- Owner
  Determines which App Extensions will appear in the dropdown below.
- App ExtensionRequired
Action
Write
- NameRequired
  The name of the project to find (exact match first, fuzzy match second).
Action
Search
- WorkspaceRequired
- ProjectRequired
  Specify one or more projects to search for an existing task.
- Task NameRequired
  The name of the task to find (exact match first, fuzzy match second).
Action
Search
- Workspace
  Paginated results are only available if workspace is selected.
- Email Address or IDRequired
Action
Search
- ProjectRequired
  The existing project that contains the task to be found.
- NameRequired
  The name of the task to find (exact match first, fuzzy match second).
- Workspace / OrganizationRequired
- Section
  Add the task to this Section within the Project. This can only be used when one Project is selected above.
- Description
  You can format the description using markdown syntax: # Heading 1 ## Heading 2 **bold text** *italicized text* ~~strikethrough~~ > blockquote Ordered List 1. First item 2. Second item 3. Third item Unordered List - First item - Second item - Third item Code: `code` Link: [title](https://www.example.com) Note: Only the above syntax items will generate rich text in a task description.
- Send as Plain Text
  Default false. If you have issues with XML errors, set this to true to resolve those.
- Due On
  You can use human readable dates like: "tomorrow" or "next week Tuesday". Cannot be used with Due At. Ignores time.
- Due At
  You can use human readable dates like: "tomorrow" or "next week Tuesday". Cannot be used with Due On. Considers time.
- Assignee
- Assignee Status
  Can only be set if the Assignee is also set.
- Followers
- Hearted
- Tag
Action
Search or write
- Task IDRequired
  This is the last, long number in the address bar when you view a Task or in the Task Link you can copy.
- Workspace / OrganizationRequired
- Project
- Section
  Add the task to this Section within the Project. This can only be used when one Project is selected above.
- Name
- Description
  You can format the description using markdown syntax: # Heading 1 ## Heading 2 **bold text** *italicized text* ~~strikethrough~~ > blockquote Ordered List 1. First item 2. Second item 3. Third item Unordered List - First item - Second item - Third item Code: `code` Link: [title](https://www.example.com) Note: Only the above syntax items will generate rich text in a task description.
- Send as Plain Text
  Default false. If you have issues with XML errors, set this to true to resolve those.
- Due On
  You can use human readable dates like: "tomorrow" or "next week Tuesday". Cannot be used with Due At. Ignores time.
- Due At
  You can use human readable dates like: "tomorrow" or "next week Tuesday". Cannot be used with Due On. Considers time.
- Assignee
- Assignee Status
  Can only be set if the Assignee is also set.
- Followers
- Hearted
- Tag
Action
Search or write
- Trigger on weekends?
  Should this Zap trigger on Saturday and Sunday?
Trigger
Instant
Try It
- Day of the WeekRequired
- Time of DayRequired
  Triggers relative to your timezone settings and defaults to UTC (GMT+00:00) if no preference is set. Note: You can also specify a time with a Custom Value in the formats "hh:mm aa", "hh:mm", or "hhhh" (e.g. "2:30pm", "14:30", or "1430").
Trigger
Instant
Try It

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 SQL Server + Asana + Schedule by Zapier Integrations Work

Step 1: Authenticate SQL Server, Asana, and Schedule by Zapier.
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 SQL Server + Asana + Schedule by Zapier

About SQL Server

SQL server (or MS SQL) is a top of the line database geared for the cloud

Related categories

Databases

Similar apps

MySQL

Databases

PostgreSQL

Databases

Firebase / Firestore

Databases

About Asana

Asana is a leading work management platform that helps teams orchestrate their work, from daily tasks to strategic initiatives. With Asana, organizations have a living system of clarity where everyone can see, discuss, and execute their team’s priorities.

Learn more

Related categories

Project Management

Similar apps

Google Tasks

Google, Task Management

Todoist

Task Management

Toodledo

Task Management

About Schedule by Zapier

Schedule is a native Zapier app you can use for recurring tasks. Trigger an action every day of the month, every day of the week or every single day. You can also select the hour of the day. If you're a developer, this is similar to a crontab, cronjob or cron.

Related categories

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.

SQL Server + Asana + Schedule by Zapier Integrations

How to connect SQL Server + Asana + Schedule by Zapier

Do even more with SQL Server + Asana + Schedule by Zapier

New Column

New Row (Custom Query)

QueryRequired

New or Updated Row

Table/ViewRequired

Primary KeyRequired

Order ByRequired

Trigger Column

Update Row

TableRequired

ID ColumnRequired

Find Row via Custom Query

QueryRequired

New Project

Workspace / Organization

New Subtask

ProjectRequired

Workspace

New Attachment Added to Task

WorkspaceRequired

ProjectRequired

Tag Added to Task

Workspace

TagRequired

Updated Task in Project

WorkspaceRequired

ProjectRequired

New Workspace/Organization

Create Duplicate Task

Helptext

Workspace

Project

Tag

NameRequired

Task Fields

Create Section

Workspace / OrganizationRequired

ProjectRequired

Section NameRequired

Section to Insert After

Section to Insert Before

Create Project

WorkspaceRequired

Team

NameRequired

NotesRequired

Create Task

Workspace / OrganizationRequired

Project

Section

Name

Description

Send as Plain Text

Due On

Due At

Assignee

Assignee Status

Followers

Hearted

Tag

Update Task

TaskRequired

Task Completed?

Name

Notes

Due On

Due At

Assignee

Assignee Status

Followers

Hearted

Tag

API Request (Beta)

Api Docs Info

HTTP MethodRequired

URLRequired

Query String Parameters