Create Google Sheet, Notify Slack, and Email

arazzo: 1.0.1
info:
  title: Create Google Sheet, Notify Slack, and Email
  summary: Create a Google Sheet, announce it on Slack, then email the link.
  description: >-
    A productivity and internal-ops workflow that creates a new Google Sheet,
    announces it to a Slack channel, and emails the spreadsheet link to a
    stakeholder through SendGrid. Demonstrates orchestrating a spreadsheet
    provider, a messaging provider, and a communications provider in a single
    Arazzo workflow.
  version: 1.0.0
sourceDescriptions:
  - name: googleSheetsApi
    url: https://raw.githubusercontent.com/api-evangelist/google-sheets/refs/heads/main/openapi/google-sheets-openapi.yml
    type: openapi
  - name: slackChatApi
    url: https://raw.githubusercontent.com/api-evangelist/slack/refs/heads/main/openapi/slack-chat-openapi.yml
    type: openapi
  - name: sendgridApi
    url: https://raw.githubusercontent.com/api-evangelist/sendgrid/refs/heads/main/openapi/tsg_mail_v3.yaml
    type: openapi
workflows:
  - workflowId: sheet-create-share-notify
    summary: Create a Google Sheet, post to Slack, then email the link.
    description: >-
      Creates a new Google Sheet, posts the spreadsheet url to a Slack channel,
      and emails the same link to a stakeholder.
    inputs:
      type: object
      properties:
        sheetTitle:
          type: string
        slackChannel:
          type: string
        recipientEmail:
          type: string
    steps:
      - stepId: create-sheet
        description: Create a new Google Sheet with the given title.
        operationId: $sourceDescriptions.googleSheetsApi.createSpreadsheet
        requestBody:
          contentType: application/json
          payload:
            properties:
              title: $inputs.sheetTitle
        successCriteria:
          - condition: $statusCode == 200
        outputs:
          spreadsheetUrl: $response.body#/spreadsheetUrl
          spreadsheetId: $response.body#/spreadsheetId
      - stepId: announce-slack
        description: Announce the new sheet in Slack.
        operationId: $sourceDescriptions.slackChatApi.postChatPostmessage
        requestBody:
          contentType: application/json
          payload:
            channel: $inputs.slackChannel
            text: $steps.create-sheet.outputs.spreadsheetUrl
        successCriteria:
          - condition: $statusCode == 200
        outputs:
          messageTs: $response.body#/ts
      - stepId: email-link
        description: Email the spreadsheet link to a stakeholder.
        operationId: $sourceDescriptions.sendgridApi.SendMail
        requestBody:
          contentType: application/json
          payload:
            personalizations:
              - to:
                  - email: $inputs.recipientEmail
                subject: A new sheet was created
            from:
              email: [email protected]
            content:
              - type: text/plain
                value: $steps.create-sheet.outputs.spreadsheetUrl
        successCriteria:
          - condition: $statusCode == 202
        outputs:
          emailStatus: $statusCode
    outputs:
      spreadsheetUrl: $steps.create-sheet.outputs.spreadsheetUrl
      messageTs: $steps.announce-slack.outputs.messageTs
      emailStatus: $steps.email-link.outputs.emailStatus