Business and enterprise integrations for Data Machine.

This plugin extends Data Machine with business-focused integrations including:

• Google Sheets: Fetch data from spreadsheets and append data for reporting
• Slack: Post messages and fetch conversations from channels
• Discord: Post messages and fetch messages from server channels

• WordPress 6.9+
• PHP 8.2+
• Data Machine core plugin (required)

1. Install and activate Data Machine core plugin
2. Upload and activate this plugin
3. Configure Google Sheets authentication in Data Machine settings
4. Create flows using the Google Sheets handlers

1. Go to Google Cloud Console
2. Create a new project or select existing
3. Enable the Google Sheets API
4. Create OAuth 2.0 credentials (Web application type)
5. Add your site's URL as authorized redirect URI
6. Copy Client ID and Client Secret to Data Machine settings
7. Authenticate the handler

Fetches data from Google Sheets with three processing modes:

• By Row: Process one row at a time (deduplication supported)
• By Column: Process one column at a time
• Full Spreadsheet: Process entire sheet at once

Appends structured data to Google Sheets with customizable column mapping.

Slack integration uses a Bot Token (xoxb-...) rather than OAuth2. The token is long-lived and managed in your Slack App settings.

1. Go to Slack API: Applications
2. Click Create New App → From scratch
3. Give it a name (e.g., "Data Machine") and select your workspace

1. Go to OAuth & Permissions in the sidebar
2. Under Bot Token Scopes, add:
   • chat:write — Send messages
   • channels:history — Read messages from public channels
   • groups:history — Read messages from private channels
   • channels:read — List public channels (optional)
   • groups:read — List private channels (optional)
3. Click Install to Workspace (or reinstall if already installed)
4. Copy the Bot OAuth Token (xoxb-...)

1. Go to Data Machine → Settings in WordPress admin
2. Find the Slack provider configuration
3. Paste your Bot OAuth Token
4. Click Validate to verify the connection

The bot must be explicitly added to any channel it should post to or read from:

• Open the channel in Slack
• Type /invite @Data Machine (or whatever you named your app)

Posts messages to a configured Slack channel. Supports:

• Plain text and Slack mrkdwn formatting
• Source URL appending
• Thread replies (reply to a specific message)
• Link unfurling (rich previews)

Fetches messages from a configured Slack channel with:

• Configurable message limit (1-1000)
• Time-based filtering (oldest/latest timestamps)
• Per-message deduplication (skips already-processed messages)
• Automatic filtering of join/leave noise

• datamachine/post-message-slack — Post a message to any channel
• datamachine/fetch-messages-slack — Fetch messages from any channel

Discord integration uses a Bot Token from the Discord Developer Portal. The token is long-lived and managed in your application settings.

1. Go to Discord Developer Portal
2. Click New Application, give it a name (e.g., "Data Machine")
3. Go to Bot in the sidebar
4. Click Reset Token and copy the token (you only see it once)
5. Under Privileged Gateway Intents, enable any intents your use case requires

1. Go to OAuth2 → URL Generator in the sidebar
2. Under Scopes, select bot
3. Under Bot Permissions, select:
   • Send Messages — Post messages to channels
   • Read Message History — Fetch messages from channels
4. Copy the generated URL and open it to invite the bot to your server

1. Go to Data Machine → Settings in WordPress admin
2. Find the Discord provider configuration
3. Paste your Bot Token
4. Click Validate to verify the connection

The bot can see channels based on its server permissions:

• Ensure the bot's role has Read Messages and Send Messages permissions in the target channel
• For private channels, explicitly grant access to the bot's role

Posts messages to a configured Discord channel. Supports:

• Plain text messages
• Source URL appending
• Discord embed objects for rich formatting

Fetches messages from a configured Discord channel with:

• Configurable message limit (1-100)
• Pagination via before/after message IDs
• Per-message deduplication (skips already-processed messages)
• Automatic filtering of join/leave and system messages

• datamachine/post-message-discord — Post a message to any channel
• datamachine/fetch-messages-discord — Fetch messages from any channel

GPL v2 or later

Chris Huber - chubes.net