automate-whatsapp

Automate WhatsApp

When to use

Use this skill to build and run WhatsApp automations: workflow CRUD, graph edits, triggers, executions, function management, app integrations, and D1 database operations.

Setup

Env vars:

• KAPSO_API_BASE_URL (host only, no /platform/v1)
• KAPSO_API_KEY

How to

Edit a workflow graph

1. Fetch graph: node scripts/get-graph.js <workflow_id> (note the lock_version)
2. Edit the JSON (see graph rules below)
3. Validate: node scripts/validate-graph.js --definition-file <path>
4. Update: node scripts/update-graph.js <workflow_id> --expected-lock-version <n> --definition-file <path>
5. Re-fetch to confirm

For small edits, use edit-graph.js with --old-file and --new-file instead.

If you get a lock_version conflict: re-fetch, re-apply changes, retry with new lock_version.

Manage triggers

1. List: node scripts/list-triggers.js <workflow_id>
2. Create: node scripts/create-trigger.js <workflow_id> --trigger-type <type> --phone-number-id <id>
3. Toggle: node scripts/update-trigger.js --trigger-id <id> --active true|false
4. Delete: node scripts/delete-trigger.js --trigger-id <id>

For inbound_message triggers, first run node scripts/list-whatsapp-phone-numbers.js to get phone_number_id.

Debug executions

1. List: node scripts/list-executions.js <workflow_id>
2. Inspect: node scripts/get-execution.js <execution-id>
3. Get value: node scripts/get-context-value.js <execution-id> --variable-path vars.foo
4. Events: node scripts/list-execution-events.js <execution-id>

Create and deploy a function

1. Write code with handler signature (see function rules below)
2. Create: node scripts/create-function.js --name <name> --code-file <path>
3. Deploy: node scripts/deploy-function.js --function-id <id>
4. Verify: node scripts/get-function.js --function-id <id>

Set up agent node with app integrations

1. Find model: node scripts/list-provider-models.js
2. Find account: node scripts/list-accounts.js --app-slug <slug> (use pipedream_account_id)
3. Find action: node scripts/search-actions.js --query <word> --app-slug <slug> (action_id = key)
4. Create integration: node scripts/create-integration.js --action-id <id> --app-slug <slug> --account-id <id> --configured-props <json>
5. Add tools to agent node via flow_agent_app_integration_tools

Database CRUD

1. List tables: node scripts/list-tables.js
2. Query: node scripts/query-rows.js --table <name> --filters <json>
3. Create/update/delete with row scripts

Graph rules

• Exactly one start node with id = start
• Never change existing node IDs
• Use {node_type}_{timestamp_ms} for new node IDs
• Non-decide nodes have 0 or 1 outgoing next edge
• Decide edge labels must match conditions[].label
• Edge keys are source/target/label (not from/to)

For full schema details, see references/graph-contract.md.

Function rules

async function handler(request, env) {
  // Parse input
  const body = await request.json();
  // Use env.KV and env.DB as needed
  return new Response(JSON.stringify({ result: "ok" }));
}

• Do NOT use export, export default, or arrow functions
• Return a Response object

Execution context

Always use this structure:

• vars - user-defined variables
• system - system variables
• context - channel data
• metadata - request metadata

Scripts

Workflows

Script	Purpose
list-workflows.js	List workflows (metadata only)
get-workflow.js	Get workflow metadata
create-workflow.js	Create a workflow
update-workflow-settings.js	Update workflow settings

Graph

Script	Purpose
get-graph.js	Get workflow graph + lock_version
edit-graph.js	Patch graph via string replacement
update-graph.js	Replace entire graph
validate-graph.js	Validate graph structure locally

Triggers

Script	Purpose
list-triggers.js	List triggers for a workflow
create-trigger.js	Create a trigger
update-trigger.js	Enable/disable a trigger
delete-trigger.js	Delete a trigger
list-whatsapp-phone-numbers.js	List phone numbers for trigger setup

Executions

Script	Purpose
list-executions.js	List executions
get-execution.js	Get execution details
get-context-value.js	Read value from execution context
update-execution-status.js	Force execution state
resume-execution.js	Resume waiting execution
list-execution-events.js	List execution events

Functions

Script	Purpose
list-functions.js	List project functions
get-function.js	Get function details + code
create-function.js	Create a function
update-function.js	Update function code
deploy-function.js	Deploy function to runtime
invoke-function.js	Invoke function with payload
list-function-invocations.js	List function invocations

App integrations

Script	Purpose
list-apps.js	Search integration apps
search-actions.js	Search actions (action_id = key)
get-action-schema.js	Get action JSON schema
list-accounts.js	List connected accounts
create-connect-token.js	Create OAuth connect link
configure-prop.js	Resolve remote_options for a prop
reload-props.js	Reload dynamic props
list-integrations.js	List saved integrations
create-integration.js	Create an integration
update-integration.js	Update an integration
delete-integration.js	Delete an integration

Databases

Script	Purpose
list-tables.js	List D1 tables
get-table.js	Get table schema + sample rows
query-rows.js	Query rows with filters
create-row.js	Create a row
update-row.js	Update rows
upsert-row.js	Upsert a row
delete-row.js	Delete rows

OpenAPI

Script	Purpose
openapi-explore.mjs	Explore OpenAPI (search/op/schema/where)

Install deps (once):

npm i

Examples:

node scripts/openapi-explore.mjs --spec workflows search "variables"
node scripts/openapi-explore.mjs --spec workflows op getWorkflowVariables
node scripts/openapi-explore.mjs --spec platform op queryDatabaseRows

Notes

• Prefer file paths over inline JSON (--definition-file, --code-file)
• action_id is the same as key from search-actions
• --account-id uses pipedream_account_id from list-accounts
• Variable CRUD (variables-set.js, variables-delete.js) is blocked - Platform API doesn't support it
• Raw SQL execution is not supported via Platform API

References

Read before editing:

• references/graph-contract.md - Graph schema, computed vs editable fields, lock_version
• references/node-types.md - Node types and config shapes
• references/workflow-overview.md - Execution flow and states

Other references:

• references/execution-context.md - Context structure and variable substitution
• references/triggers.md - Trigger types and setup
• references/app-integrations.md - App integration and variable_definitions
• references/functions-reference.md - Function management
• references/functions-payloads.md - Payload shapes for functions
• references/databases-reference.md - Database operations

Assets

File	Description
workflow-linear.json	Minimal linear workflow
workflow-decision.json	Minimal branching workflow
workflow-agent-simple.json	Minimal agent workflow
workflow-customer-support-intake-agent.json	Customer support intake
workflow-interactive-buttons-decide-function.json	Interactive buttons + decide (function)
workflow-interactive-buttons-decide-ai.json	Interactive buttons + decide (AI)
workflow-api-template-wait-agent.json	API trigger + template + agent
function-decide-route-interactive-buttons.json	Function for button routing
agent-app-integration-example.json	Agent node with app integrations

Related skills

• integrate-whatsapp - Onboarding, webhooks, messaging, templates, flows
• observe-whatsapp - Debugging, logs, health checks

<!-- FILEMAP:BEGIN -->

[automate-whatsapp file map]|root: .
|.:{package.json,SKILL.md}
|assets:{agent-app-integration-example.json,databases-example.json,function-decide-route-interactive-buttons.json,functions-example.json,workflow-agent-simple.json,workflow-api-template-wait-agent.json,workflow-customer-support-intake-agent.json,workflow-decision.json,workflow-interactive-buttons-decide-ai.json,workflow-interactive-buttons-decide-function.json,workflow-linear.json}
|references:{app-integrations.md,databases-reference.md,execution-context.md,function-contracts.md,functions-payloads.md,functions-reference.md,graph-contract.md,node-types.md,triggers.md,workflow-overview.md,workflow-reference.md}
|scripts:{configure-prop.js,create-connect-token.js,create-function.js,create-integration.js,create-row.js,create-trigger.js,create-workflow.js,delete-integration.js,delete-row.js,delete-trigger.js,deploy-function.js,edit-graph.js,get-action-schema.js,get-context-value.js,get-execution-event.js,get-execution.js,get-function.js,get-graph.js,get-table.js,get-workflow.js,invoke-function.js,list-accounts.js,list-apps.js,list-execution-events.js,list-executions.js,list-function-invocations.js,list-functions.js,list-integrations.js,list-provider-models.js,list-tables.js,list-triggers.js,list-whatsapp-phone-numbers.js,list-workflows.js,openapi-explore.mjs,query-rows.js,reload-props.js,resume-execution.js,search-actions.js,update-execution-status.js,update-function.js,update-graph.js,update-integration.js,update-row.js,update-trigger.js,update-workflow-settings.js,upsert-row.js,validate-graph.js,variables-delete.js,variables-

---

*Content truncated.*