Pipedream
Tag25 integrations tagged with "pipedream"
Google Sheets: Get Values
Retrieve values from a specific range in a Google Sheet. Provide the full Google Sheets URL (spreadsheet ID and sheet tab are extracted automatically from the URL). Use A1 notation for the range without sheet name prefix (e.g., 'A1:D10', 'A:E'). Ideal for: reading configuration data, fetching lookup tables, getting historical data.
Google Sheets: Update Cell
Update a single cell value in a Google Sheet. Use this to modify specific cells, update statuses, change balances, or correct data. Provide the cell reference in A1 notation (e.g., 'B2'). Provide the full Google Sheets URL (spreadsheet ID and sheet tab are extracted automatically from the URL). Ideal for: status updates, balance tracking, dashboard values, single-field corrections.
Google Sheets: Add Multiple Rows
Add multiple rows of data to a Google Sheet in a single operation. Use this for batch imports or when you need to write many rows at once. More efficient than adding rows one by one. Ideal for: batch imports, bulk data exports, report generation.
Google Sheets: List Worksheets
List all worksheet tabs in a Google Sheets spreadsheet. Returns each sheet's numeric ID, title, and index. Provide the full Google Sheets URL (spreadsheet ID is extracted automatically). Use this to discover available sheets before other Google Sheets actions.
Airtable: Create Multiple Records
Create multiple records (up to 10) in an Airtable base table in a single operation. More efficient than creating records one by one. Ideal for: batch imports, bulk data entry, syncing data from other sources.
Discord Bot: List Channels
List all channels in a Discord server. Returns channel IDs, names, and types. Use this to discover channel IDs for the Send Message action.
Philips Hue: Activate Scene
Activate a predefined Philips Hue light scene. Accepts both v1 scene IDs (e.g., '5') and v2 UUIDs (e.g., '3f8a...'). Ideal for: mood setting, automation, scheduled ambiance, entertainment.
Notion: Update Page
Update properties of an existing Notion page or database entry. Use this to modify page metadata, status, or custom properties. Can also archive/unarchive pages. Ideal for: status updates, metadata changes, workflow state management.
Philips Hue: Turn Light On/Off
Turn a Philips Hue light or group of lights on or off. Accepts both v1 IDs (e.g., '81', '0') and v2 UUIDs (e.g., '2ec2b2f1-...'). At least one of lightId or groupId must be provided. Ideal for: automation, scheduling, presence detection, notifications.
QuickBooks: Create Purchase
Creates a purchase transaction in QuickBooks to record expenses. Supports Cash, Check, and CreditCard payment types. Records expenses with account references, line items, and amounts. Ideal for: automated bookkeeping, expense tracking, contractor payments, transaction logs.
Airtable: List Records
Retrieve records from an Airtable base table with filtering and sorting. Use filterByFormula for conditional queries. Supports pagination up to 100 records. Ideal for: data lookups, report generation, fetching CRM data, inventory queries.
QuickBooks Sandbox: Search Accounts
Search accounts in QuickBooks Sandbox by name, type, or other criteria (testing). Returns account IDs, names, types, and balances. Use this to look up account IDs needed for creating purchases or other transactions. Ideal for: account lookup, finding account IDs, listing expense categories.
Notion: Create Page
Create a new page in a Notion database or under a parent page. Use this to create documentation, notes, or structured records. Supports markdown content and custom titles. Ideal for: documentation, notes, task creation, knowledge base entries.
Airtable: Create Record
Create a single record in an Airtable base table. Use this to add new entries to your Airtable databases. Pass field values as key-value pairs. Ideal for: CRM entries, inventory tracking, lead capture, form submissions.
QuickBooks: Search Purchases
Search and list purchases in QuickBooks Online. Supports SQL-like queries for filtering (WHERE), sorting (ORDER BY), and pagination. Returns an array of purchase transactions matching your criteria. Ideal for: expense reports, transaction lookups, audit trails, data exports.
Gmail: Create Draft
Create a draft email in Gmail for later review and sending. Use this when you want to prepare emails that need human approval before sending. Ideal for: scheduled communications, review workflows, template-based emails.
Notion: Append Block
Append content to an existing Notion page. Use this to add new paragraphs, logs, or updates to existing pages. Supports markdown formatting. Ideal for: activity logs, running notes, status updates, append-only records.
Twilio: Send SMS
Send an SMS message using Twilio via Pipedream integration.
QuickBooks: Search Accounts
Search accounts in QuickBooks Online by name, type, or other criteria. Returns account IDs, names, types, and balances. Use this to look up account IDs needed for creating purchases or other transactions. Ideal for: account lookup, finding account IDs, listing expense categories.
QuickBooks Sandbox: Search Purchases
Search and list purchases in QuickBooks Sandbox (testing). Supports SQL-like queries for filtering (WHERE), sorting (ORDER BY), and pagination. Returns an array of purchase transactions matching your criteria. Ideal for: expense reports, transaction lookups, audit trails, data exports.
QuickBooks Sandbox: Create Purchase
Creates a purchase transaction in QuickBooks Sandbox to record expenses (testing). Supports Cash, Check, and CreditCard payment types. Records expenses with account references, line items, and amounts. Ideal for: automated bookkeeping, expense tracking, contractor payments, transaction logs.