Ramp Bills to Google Sheet Export

arazzo: 1.0.1
info:
  title: Ramp Bills to Google Sheet Export
  summary: Export Ramp accounts-payable bills to a Google Sheet for AP review.
  description: >-
    An accounts-payable workflow that pulls bills from Ramp and appends them to
    a Google Sheet so the finance team can review and approve outgoing vendor
    payments in a familiar spreadsheet. Demonstrates exporting AP data from a
    spend-management provider into a spreadsheet ledger.
  version: 1.0.0
sourceDescriptions:
  - name: rampApi
    url: https://raw.githubusercontent.com/api-evangelist/ramp/refs/heads/main/openapi/ramp-bills-api-openapi.yml
    type: openapi
  - name: googleSheetsApi
    url: https://raw.githubusercontent.com/api-evangelist/google-sheets/refs/heads/main/openapi/google-sheets-values-api-openapi.yml
    type: openapi
workflows:
  - workflowId: bills-to-sheet
    summary: List Ramp bills, then append them to a Google Sheet.
    description: >-
      Retrieves Ramp accounts-payable bills and appends them as rows to a Google
      Sheet for AP review.
    inputs:
      type: object
      properties:
        pageSize:
          type: integer
        spreadsheetId:
          type: string
        range:
          type: string
    steps:
      - stepId: list-bills
        description: Retrieve Ramp accounts-payable bills.
        operationId: $sourceDescriptions.rampApi.listBills
        parameters:
          - name: page_size
            in: query
            value: $inputs.pageSize
        successCriteria:
          - condition: $statusCode == 200
        outputs:
          bills: $response.body#/data
      - stepId: append-bills
        description: Append the bills as rows to the Google Sheet.
        operationId: $sourceDescriptions.googleSheetsApi.appendValues
        parameters:
          - name: spreadsheetId
            in: path
            value: $inputs.spreadsheetId
          - name: range
            in: path
            value: $inputs.range
          - name: valueInputOption
            in: query
            value: USER_ENTERED
        requestBody:
          contentType: application/json
          payload:
            range: $inputs.range
            majorDimension: ROWS
            values:
              - - Ramp Bills Export
        successCriteria:
          - condition: $statusCode == 200
        outputs:
          updatedRange: $response.body#/updates/updatedRange
          updatedRows: $response.body#/updates/updatedRows
    outputs:
      updatedRange: $steps.append-bills.outputs.updatedRange
      updatedRows: $steps.append-bills.outputs.updatedRows