Microsoft Outlook and Smartsheet

Microsoft Outlook

Triggers

• New emailRuns when a new email arrives in a folder of an Outlook mailbox - the inbox unless you choose another - optionally only from one sender or domain. Runs once for each email, with its text.
• New eventRuns when an event is added to an Outlook calendar, whether someone creates it or accepts an invitation, with its subject, times, location, organizer and guests. Events already there when the workflow is turned on don't start it. How often it checks follows your workspace plan.
• Event updatedRuns when an event on an Outlook calendar changes: its time, subject, place, notes or guests, a guest's answer, or the organizer cancelling it (is_cancelled tells you). Events as they were when the workflow is turned on don't start it. How often it checks follows your workspace plan.
• Event starting soonRuns a set number of minutes before each event on an Outlook calendar starts, once for each meeting of a repeating series, with its subject, times, place and guests. Times are in UTC. It checks as often as your workspace plan allows, so it can run a little later than the minutes you set, and up to half an hour after the start if a check comes late. Cancelled events, and events already that close when the workflow is turned on, don't start it.
• New contactRuns when a contact is added to an Outlook mailbox's Contacts, with their name, email, phone numbers and company. Contacts already there when the workflow is turned on don't start it. How often it checks follows your workspace plan.
• Contact updatedRuns when a contact in an Outlook mailbox's Contacts is changed, with their name, email, phone numbers and company as they are now. Contacts as they were when the workflow is turned on don't start it. How often it checks follows your workspace plan.

Actions

• Send emailSend an email from a mailbox in your organization. Sent means Outlook accepted it; a bounce arrives later in the sender's inbox.
• List emailsList the emails in a mailbox, newest first. You can narrow it to one folder, to unread emails, or to a search.
• Get emailRead one email, including its full body.
• Create draftSave a draft email without sending it, to send later with Send draft. Set 'Reply to email' to draft a reply in that email's conversation, with the original quoted below.
• Send draftSend a draft email created earlier. Once sent, it moves to Sent Items and the draft's ID stops working.
• Reply to emailReply to the sender of an email. The reply is saved in Sent Items.

Smartsheet

Triggers

• New rowRuns when a row is added to a Smartsheet sheet.
• Row changedRuns when a row in a Smartsheet sheet is changed, once for each change.
• New commentRuns for each new comment on a Smartsheet sheet or one of its rows, with who wrote it and the row it's on. Comments already there when the workflow is turned on don't start it. How often it checks follows your workspace plan.
• New attachmentRuns for each new file or link attached to a Smartsheet sheet, one of its rows or a comment. Attachments already there when the workflow is turned on don't start it. How often it checks follows your workspace plan.

Actions

• Get my accountGet the Smartsheet account this connection uses: name, email address, time zone and organization.
• List workspacesList the workspaces you can open, with your access to each.
• SearchSearch everything you can open in Smartsheet (sheets, rows, reports, comments and attachments) for some words. Smartsheet may take a few minutes to find something just added.
• List sheetsList the sheets you can open, alphabetically, optionally only those changed since a date and time.
• Get sheetGet a sheet with its columns and rows, each row's cells by column name. Large sheets come a page at a time.
• Create sheetCreate a sheet in a workspace or one of its folders, with the columns you name. Add typed columns (dates, dropdowns) with 'Add column'.