Form Record to Notion Doc to Email

arazzo: 1.0.1
info:
  title: Form Record to Notion Doc to Email
  summary: Capture a form submission in Airtable, document it in Notion, then email.
  description: >-
    A productivity and internal-ops workflow that records an intake-form
    submission as an Airtable record, creates a Notion page documenting the
    request, and emails a confirmation through SendGrid. Demonstrates chaining a
    database provider, a knowledge-base provider, and a communications provider
    in a single Arazzo workflow.
  version: 1.0.0
sourceDescriptions:
  - name: airtableApi
    url: https://raw.githubusercontent.com/api-evangelist/airtable/refs/heads/main/openapi/airtable-records-api-openapi.yml
    type: openapi
  - name: notionApi
    url: https://raw.githubusercontent.com/api-evangelist/notion/refs/heads/main/openapi/notion-pages-api-openapi.yml
    type: openapi
  - name: sendgridApi
    url: https://raw.githubusercontent.com/api-evangelist/sendgrid/refs/heads/main/openapi/sendgrid-mail-send-api-openapi.yml
    type: openapi
workflows:
  - workflowId: form-to-doc-to-email
    summary: Store a form record, document it in Notion, then send a confirmation.
    description: >-
      Creates an Airtable record from a form submission, creates a Notion page
      documenting the request, and emails a confirmation to the submitter.
    inputs:
      type: object
      properties:
        baseId:
          type: string
        tableIdOrName:
          type: string
        requestTitle:
          type: string
        submitterEmail:
          type: string
        parentDatabaseId:
          type: string
    steps:
      - stepId: store-record
        description: Store the form submission as an Airtable record.
        operationId: $sourceDescriptions.airtableApi.createRecords
        parameters:
          - name: baseId
            in: path
            value: $inputs.baseId
          - name: tableIdOrName
            in: path
            value: $inputs.tableIdOrName
        requestBody:
          contentType: application/json
          payload:
            records:
              - fields:
                  Name: $inputs.requestTitle
                  Email: $inputs.submitterEmail
        successCriteria:
          - condition: $statusCode == 200
        outputs:
          recordId: $response.body#/records/0/id
      - stepId: document-page
        description: Create a Notion page documenting the request.
        operationId: $sourceDescriptions.notionApi.createPage
        requestBody:
          contentType: application/json
          payload:
            parent:
              database_id: $inputs.parentDatabaseId
            properties:
              title:
                title:
                  - text:
                      content: $inputs.requestTitle
        successCriteria:
          - condition: $statusCode == 200
        outputs:
          pageUrl: $response.body#/url
      - stepId: email-confirmation
        description: Email a confirmation to the submitter via SendGrid.
        operationId: $sourceDescriptions.sendgridApi.SendMail
        requestBody:
          contentType: application/json
          payload:
            personalizations:
              - to:
                  - email: $inputs.submitterEmail
                subject: We received your request
            from:
              email: ops@example.com
            content:
              - type: text/plain
                value: $steps.document-page.outputs.pageUrl
        successCriteria:
          - condition: $statusCode == 202
        outputs:
          emailStatus: $statusCode
    outputs:
      recordId: $steps.store-record.outputs.recordId
      pageUrl: $steps.document-page.outputs.pageUrl
      emailStatus: $steps.email-confirmation.outputs.emailStatus