23 integrations tagged with "oauth"
Add a single row of data to a Google Sheet. Use this to log events, track transactions, or append data to spreadsheets. Provide cell values as an array. Ideal for: transaction logs, event tracking, data collection, audit trails.
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.
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.
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.
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.
Send an SMS message using Twilio via Pipedream integration.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Set color and brightness of a Philips Hue light or group. 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: color animations, mood lighting, dynamic scenes, notifications.
