The NoCodeB (NocoDB) API transforms your databases into a smart Excel sheet, providing a platform for managing your data with the ease of a spreadsheet interface. When combined with Pipedream's capabilities, this API allows you to automate data operations, sync with other databases or apps, and streamline workflows without writing complex code. Using Pipedream, you can trigger events based on changes in your NocoDB, process and manipulate the data, and connect to countless apps to extend functionality, such as sending notifications, updating CRMs, or generating reports.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
nocodb: {
type: "app",
app: "nocodb",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://${this.nocodb.$auth.domain}/api/v1/db/meta/nocodb/info`,
headers: {
"accept": `application/json`,
"xc-token": `${this.nocodb.$auth.api_key}`,
},
})
},
})
Automated Data Sync Between NocoDB and Google Sheets: Use the NocoDB API to watch for new records or updates in your database tables. When a change is detected, a Pipedream workflow can be triggered to reflect these changes in a corresponding Google Sheets document, ensuring both NocoDB and Google Sheets have synchronized data.
Dynamic CRM Updates from NocoDB: When new contacts or deals are added to your NocoDB tables, a Pipedream workflow can automatically push this data to your CRM platform, such as Salesforce or HubSpot. This ensures that your sales team has the latest information without manual entry, saving time and reducing errors.
Email Notifications on Specific Triggers: Configure Pipedream to monitor specific columns or triggers within NocoDB—for instance, when a project status changes to "Complete." Upon this trigger, Pipedream can craft and send a customized email notification to team members or stakeholders via SendGrid or Mailgun, keeping everyone in the loop.
Emit new event for each new record in table. See the documentation
Emit new event for each new record in a view. See the documentation
Emit new event for each update in table. See the documentation
This action gets a row by row Id. See the documentation
This action lists all rows in a table. See the documentation
nocodb uses API keys for authentication. When you connect your nocodb account, Pipedream securely stores the keys so you can easily authenticate to nocodb APIs in both code and no-code steps.
Your API key
can be found in API Tokens Management within your database.
Your domain
is where your app is hosted, so for https://mytable.com
use mytable.com
for the domain.