Search all guides

Reference · Nodes

Data & Storage integrations and nodes

Data and storage nodes read and write the places your records and files live: spreadsheets such as Google Sheets and Airtable, databases such as PostgreSQL, MySQL and MongoDB, and file stores such as Google Drive, Dropbox and AWS S3. The category also holds BusyBot's own Knowledge Base and Search Knowledge Base nodes, which add documents to a knowledge base and search it from inside a workflow.

54 nodes — 47 actions and 7 triggers. Every page documents the shipped node: real parameters, real outputs, real error behaviour.

Spreadsheets, databases, files and knowledge

Spreadsheets and table databases. Google Sheets reads, appends, updates and upserts rows. Airtable, Baserow, NocoDB, SeaTable and Grist do the same for their tables.

SQL and warehouses. PostgreSQL, MySQL and Oracle SQL run selects, inserts, updates, upserts and raw parameterized queries. Snowflake and Google BigQuery run queries and insert rows into warehouse tables, and TimescaleDB, QuestDB and CrateDB cover time-series workloads.

Document and key-value stores. MongoDB, AWS DynamoDB, Google Cloud Firestore, Redis and Elasticsearch.

Files. Google Drive, Dropbox, Box, Microsoft OneDrive and Microsoft SharePoint upload, download, search and share. AWS S3, S3 (for any S3-compatible service), Google Cloud Storage and Microsoft Azure Storage manage buckets and objects.

Knowledge. Knowledge Base creates knowledge bases and adds, replaces or removes their documents. Search Knowledge Base sends an AI research agent into a knowledge base and returns its findings and an answer.

Triggers

Polling: Google Sheets Trigger, Airtable Trigger, SeaTable Trigger, Google Drive Trigger and Microsoft OneDrive Trigger. Webhook: Box Trigger and AWS SNS Trigger.

Example workflows

  • Copy new Drive files to S3. Google Drive Trigger fires when a new file is created in a folder, Google Drive downloads it, and AWS S3 uploads it to a bucket.
  • Keep a knowledge base current. Dropbox searches for PDFs and downloads each one, and Knowledge Base adds it to a product manuals knowledge base.
  • Sheet rows into Postgres. Google Sheets Trigger fires when a row is added, Edit Fields renames the columns to match the table, and PostgreSQL upserts each row with ON CONFLICT so a re-run does not duplicate it.

Actions

Adalo Create, retrieve, update and delete records (rows) in the collections of an Adalo no-code app through the Adalo Collections API. Action Airtable Create, read, update, upsert, delete and search records in Airtable bases, with attachment fields downloadable as binary data. Also lists your bases and retrieves a base's table and field schema. Action (binary) AWS DynamoDB Put, get, scan or query, and delete items in Amazon DynamoDB tables, with condition, projection and filter expressions and secondary-index queries. Action AWS S3 Manage buckets, files, and folders in Amazon S3 and S3-compatible storage services. Supports upload, download, copy, delete, and listing operations with full encryption, ACL, and storage class support. Action (binary) Baserow Create, retrieve, update and delete rows in Baserow database tables, with filtering, sorting, searching and pagination when listing rows. Action Bitwarden Manage Bitwarden organization collections, events, groups, and members via the Public API Action Box Manage files and folders in Box cloud content management. Download, upload, copy, delete, search, share files, and create, delete, get, search, share, update folders. Action (binary) CrateDB Execute SQL queries, insert rows, and update rows in CrateDB distributed databases using parameterized queries. Action Dropbox Manage files and folders in Dropbox cloud storage. Upload, download, copy, move, delete files and folders, list folder contents, and search. Action (binary) Elasticsearch Create, search, update, and delete documents and indices within an Elasticsearch cluster. Action ERPNext Perform create, read, update, and delete operations on documents within an ERPNext instance. Action FileMaker Interact with the FileMaker Data API to create, read, update, delete, duplicate, and search records, as well as execute scripts in a FileMaker database. Action Google BigQuery Execute SQL queries and insert rows into Google BigQuery tables via the BigQuery REST API. Action Google Cloud Firestore Create, read, update, delete, and query documents and collections in Google Cloud Firestore. Action Google Cloud Storage Manage buckets and objects (files) in Google Cloud Storage. Upload, download, list, create, update, and delete buckets and objects. Action (binary) Google Drive Manage files, folders, and shared drives on Google Drive. Upload, download, copy, move, search, and share files with full shared drive support. Action (binary) Google Firebase Realtime Database Create, delete, get, push, and update records in a Google Firebase Realtime Database. Action Google Sheets Manage rows and sheet tabs within Google Sheets spreadsheets, including reading, appending, updating, clearing, and deleting data. Action GraphQL Send GraphQL queries and mutations to any endpoint, configuring authentication, variables, and response handling for each request. Action Grist Create, read, update, and delete rows in Grist spreadsheet database tables, supporting filtering and sorting when retrieving rows. Action Knowledge Base Create, delete, and manage knowledge bases, including adding, replacing, or removing documents within them. Action (binary) Microsoft Azure Storage Manage blobs and containers in Azure Blob Storage. Upload, download, list, and delete blobs and containers. Action (binary) Microsoft OneDrive Manage files and folders in Microsoft OneDrive. Upload, download, copy, delete, rename, search, and share files and folders via the Microsoft Graph API. Action (binary) Microsoft SharePoint Manage files, list items, and lists within Microsoft SharePoint Online. Perform file operations like download, upload, and update, and manage list items with create, read, update, delete, and upsert capabilities. Action (binary) MongoDB Find, insert, update, replace, delete, and aggregate documents in MongoDB. Manage Atlas Search indexes. Action MySQL Execute SQL queries, insert, update, upsert, select, and delete rows in a MySQL database. Action Nextcloud Manage files, folders, and users on a self-hosted Nextcloud instance via WebDAV and OCS APIs. Action (binary) NocoDB Read, create, update, and delete rows in NocoDB tables with binary attachment support. Action (binary) Odoo Interact with the Odoo ERP platform via its JSON-RPC 2.0 API to manage contacts, opportunities, notes, and custom resources Action Oracle SQL Execute SQL operations against Oracle Database. Supports SELECT, INSERT, UPDATE, UPSERT (MERGE), DELETE/TRUNCATE/DROP, and raw SQL execution with named bind parameters. Action PostBin Create temporary HTTP request collection bins, send test requests, and retrieve captured requests via PostBin (postb.in). Useful for debugging webhooks and testing HTTP integrations. Action PostgreSQL Get, add, update, and delete data in PostgreSQL databases. Supports SELECT, INSERT, UPDATE, UPSERT, DELETE, and raw SQL execution with parameterized queries. Action QuestDB Execute SQL queries and insert rows into QuestDB time-series databases, using parameterized values to prevent SQL injection. Action QuickBase Manage records, fields, files, and reports in QuickBase applications via the RESTful API. Action (binary) Redis Perform key-value data operations against an external Redis instance including get, set, delete, keys, increment, list push/pop, publish, and server info. Action S3 Interact with any S3-compatible object storage service (MinIO, DigitalOcean Spaces, Wasabi, Backblaze B2, etc.) to manage buckets, upload/download files, and organize folders. Action (binary) Search Knowledge Base Search a knowledge base with an AI research agent and return the findings and answer Action SeaTable Read, update, write, and delete data from SeaTable bases. Manage rows, base metadata, links, and file/image assets. Action (binary) Snowflake Execute queries, insert, and update data in Snowflake cloud data warehouse using parameterized queries. Action Stackby Append, read, list, and delete rows in Stackby spreadsheet database tables, combining spreadsheet simplicity with database power. Action Storyblok Manage stories in the Storyblok headless CMS via Content Delivery API and Management API Action Strapi CRUD operations for content entries in a self-hosted Strapi headless CMS instance Action Supabase Add, get, delete, and update rows in Supabase database tables via the PostgREST API. Action TimescaleDB Execute SQL queries, insert rows, and update rows in a TimescaleDB database. Uses the PostgreSQL wire protocol via the pg driver. Action Unleashed Software Manage inventory, sales orders, and stock on hand via the Unleashed Software API Action Upload to Spaces Uploads a local file or binary data to DigitalOcean Spaces cloud storage, storing the object URL and key. Action (binary) uProc Data processing, enrichment, and validation platform with 455+ processors across 11 categories Action

Triggers

Nodes that START a workflow when something happens.

Frequently asked questions

Which data sources can start a workflow?

Google Sheets Trigger, Airtable Trigger and SeaTable Trigger poll for new or updated rows. Google Drive Trigger and Microsoft OneDrive Trigger poll for new or changed files and folders. Box Trigger receives webhooks for file, folder and comment events, and AWS SNS Trigger starts a run when a message is published to an SNS topic. The databases have no trigger of their own, so a workflow that reads new database rows usually runs on a schedule.

What credentials do database nodes need?

Connection details for that database: PostgreSQL and MySQL take a host, port, database, user and password, Oracle SQL a connection string, and Snowflake an account, a warehouse and either a password or a private key. Google Sheets, Google BigQuery and Google Cloud Firestore accept either an OAuth2 credential or a Google API service account. Knowledge Base and Search Knowledge Base need no credential, because they work on your own BusyBot knowledge bases.

How do these nodes work with AI and core nodes?

Read rows, process each one, and write the result back. Google Sheets reads all rows from a sheet, an AI node such as Gemini Structured Output extracts fields from a free-text column, and Google Sheets updates the matching rows. For documents, Knowledge Base adds a file from binary data and indexes it the way a manual upload would, so agents and chats pointed at that knowledge base can search it.

Last reviewed . Spotted something wrong? Tell us.